Many ways to add column to existing table in MySQL. If you r using GUI tools, add column to table in MySQL is easy. If you are using CLI, then here’s the command to add column in MySQL table.
To add column in existing table, you may refer to the 2 examples below:-
Continue reading MySQL: How to add column to existing table »
Monitor what sql query is running in mysql is very import for performance analysis. By monitor sql query, you are be able to know what is running at the backend. if your framework logs all sql queries then you can monitor from there, if not, you might need to turn on mysql log to monitor all the sql query being executed.
To monitor sql query in MySQL, simply follow the steps below:-
Continue reading How to monitor sql query in mysql? »
The easiest way to install apache, php and mysql in Mac is thru mac port. You can also install apache, php and mysql by compiling each of the service but it’s too time consuming. If you just wan to install apache, php and mysql for development use, Mac Port install is good enough.
Follow the steps below to install apache, php and mysql in Mac OS X:-
Continue reading How to install apache, php, mysql with macport in Mac OS X »
