Posts Tagged with "mysql"

How to update fields from another table in MySQL

Posted by Stanislav Furman on May 28, 2014
Read how to update a bunch of fields from another table in MySQL

Meet AMPPS - a good alternative for XAMPP and WAMP

Posted by Stanislav Furman on October 7, 2013

Meet AMPPS - a good alternative for XAMPP and WAMP  

For those who is looking for a good alternative for XAMMP or WAMP web server stacks. There is a very good option called AMPPS!

The listed number of provided features is impressive. Unlike the other solutions Ampps comes with over 300 PHP web applications, over 1000 PHP classes and libraries including Joomla!, WordPress, Magento, Dolphin and more. 

Very easy to install and manage services with the administration panel. You can easily switch PHP versions with only one-click action.

One thing to notice though... Despite the fact that there are several versions of PHP included, you cannot switch MySQL version which, to be honest, I don't find too critical.

Server configuration is also very straightforward using the web panel. If you mess up the configuration, you can reset it to default state which might be useful sometimes. :)

Also it is very easy to update! The app has built-in updater which makes life way easier when it comes to update Ampps.


Concatenating NULL and blank fields in MySQL

Posted by Stanislav Furman on May 17, 2013
How to concatenate empty and null fields in MySQL database

MySQL. How to insert a row or update if exists in MySQL.

Posted by Stanislav Furman on February 25, 2013
Insert a row into DB, or update row on duplicated key in MySQL.