Mysql常用命令

01：service mysql status

02：service mysqld start | stop | restart (/etc/init.d/mysql start | stop | restart)

03：mysql -u root -p

04：show databases;

05：use database_name;

06：show tables;

07：describe table_name;

08：drop table table_name;

09：drop database database-name;

10：show index from table_name;