MySQL commands used in the test

Restart MYSQL:
Sudo/etc/init. d/MySQL restart;

Mysql-uroot-proot <database> # connect to MySQL

Mysql> use <database>

Mysql> show tables;

Mysql> select * from <Table>;

Mysql> Delete from <Table> where <condition>;

Mysql> DESC <Table >;# table structure

Mysql> show variables like '% set %'; # displays the encoding used by the database.

Mysql> insert into <Table> <field> values ('<value> ');

Mysql> insert into <Table> values ('<value1>', '<value2> ');

Mysql> Update <Table> set <filed> = '<value> ';

Mysql> select length (<field>) from <Table>; # obtain the current length of the field value.

Mysql> source/home/XX/documents/XX/proc/testproc_usages. SQL # Run the. SQL script on the MySQL command line.

Mysql> Update traffic_stats set query_time = query_time-interval 5 day;