All Amazing Articles

When I’m developing PHP applications I normally have a DOS window open so I can run SQL scripts from the command line. Often, this is so I can check that MySQL database tables are being updated correctly while I am running PHP scripts.

There are not that many command line tasks I need to perform, but it is useful to be able to run them as and when I need to. In this tutorial I’ll look at a few MySQL commands I find really useful during the development of PHP applications.

Logging onto the MySQL monitor

To log onto the MySQL monitor:

1. Open a command prompt window, and navigate to the the mysql\bin folder.
2. Run the command:

mysql

OR

mysql -u user -p

If prompted, enter the password for the database user.

Continue reading »

\\ tags: MySQL, PHP Development, Web Development