How To Use MySQL Command Line Interface? - PHP Script Tips - Working with MySQL Database

MySQL server comes with a command line interface, which will allow you to operate with the server with SQL statements and other commands. To start the command line interface, you can run the \mysql\bin\mysql program. The tutorial exercise below shows you how to use the command line interface to create a table and insert a row to table:

>\mysql\bin\mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.

mysql> use test;
Database changed

mysql> CREATE TABLE fyi_links (url varchar(80));
Query OK, 0 rows affected (0.58 sec)

mysql> INSERT INTO fyi_links VALUES ('dev.fyicenter.com');
Query OK, 1 row affected (0.38 sec)

mysql> SELECT * FROM fyi_links;
+-------------------+
| url               |
+-------------------+
| dev.fyicenter.com |
+-------------------+
1 row in set (0.00 sec)

mysql> DROP TABLE fyi_links;
Query OK, 0 rows affected (0.34 sec)

mysql> quit;
Bye