MySQL command line

Create a database

Create DATABASE test;
To delete a database:

drop database test;
To delete a table:

drop table Ceshi;

To display the database table structure:
describe table name;

Import Database
Method One:
(1) Select database
Mysql>use ABC;
(2) Setting the database encoding
Mysql>set names UTF8;
(3) Import data (note the path to the SQL file)
mysql>source/home/abc/abc.sql;
Method Two:
Mysql-u User name-p password database name < database name. sql
#mysql-UABC_F-P ABC < Abc.sql

Restart:

1. Start with service: service MySQL restart

2. Start with mysqld script:/etc/inint.d/mysql restart

MySQL command line