Menu
Web support banner

Unix commands

The mysql command

The mysql command-line tool, or "MySQL Monitor", may be used on Socrates and Plato. The Unix command line options are documented in the Unix man page man mysql. If you type "help" in mysql, it will list the commands that it supports in addition to standard SQL commands. You can also search the MySQL site at http://www.mysql.com/search. If you provide an argument to the help command, mysql uses it as a search string to access server-side help from the contents of the MySQL Reference Manual. Use "help contents" to see a list of the help categories.

The following example illustrates the use of the command to examine table people in database ucabwww, owned by user ucabwww:

mysql -h mysql-server.ucl.ac.uk -u ucabwww -p
Enter password: *******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4440 to server version: 3.23.51-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use ucabwww;
Database changed
mysql> describe people;
+-------+---------+------+-----+---------+----------------+
| Field | Type    | Null | Key | Default | Extra          |
+-------+---------+------+-----+---------+----------------+
| ID    | int(11) |      | PRI | NULL    | auto_increment |
| Name  | text    | YES  |     | NULL    |                |
| Age   | int(11) | YES  |     | NULL    |                |
+-------+---------+------+-----+---------+----------------+
3 rows in set (0.01 sec)

mysql> select name,age from people order by name;
+--------+------+
| name   | age  |
+--------+------+
| arthur |   44 |
| fred   |   23 |
| james  |  123 |
| jane   |   56 |
| jill   |   23 |
| john   |   44 |
| mary   |   34 |
| susan  |   35 |
| tony   |   98 |
+--------+------+
9 rows in set (0.00 sec)

mysql> quit
Bye

Other Unix commands

The following Unix commands are also available. Click on the command name for the relevant manual entry:

mysqldump Dump Table Structure and Data
mysqlimport Import Data from Text Files
mysqlshow Show Databases, Tables, and Columns
mysqlcheck Table Maintenance and Crash Recovery
mysqlhotcopy Copy MySQL Databases and Tables
perror
Explain Error Codes