Common SQL commands

1.net start/stop mysql start stop MySQL

Mysqladmin-uroot-p shutdown Stop MySQL

2.show Create database/table XXX view Table/library Details

3.show variables like '%character% ' view individual character sets

4.show databases/tables View all libraries/tables

5.mysql-uroot-p/mysql--user root--password connect to MySQL server

MySQL--host localhost--user root--password/mysql-hhost-uroot-pmysql-uroot-p connect to MySQL server

6.quit/exit quit MySQL

Common SQL commands