mysql cmd common commands

To place mysql.exe in bin under C:\WINDOWS, you can execute the following command

Connection: mysql-h host address -u user name -p user password (note :u and root do not need to add space, the others are also 1)
Disconnect: exit (enter)

Create authorization: grant select on database.* to username @ login host identified by \" password \"
Change password: mysqladmin-u username -p old password password new password
Remove authorization: revoke select insert, update, delete om *. * from test2 @ localhost;

Display database: show databases;
Display data sheet: show tables;
Display table structure: describe table name;

Create library: create database library name;
Delete library: drop database library name;
Library name: use library name;

Create table: create table table name (field setting list);
Delete table: drop table table name;
Modification table: alter table t1 rename t2
Query table: select * from table name;
Empty table: delete from table name;
Backup table: mysqlbinmysqldump-h (ip) -uroot-p (password) databasename tablename > tablename.sql
Recovery form: mysqlbinmysql-h (ip) -uroot-p (password) databasename tablename < tablename.sql (delete the original table before operation)

Added columns: ALTER TABLE t2 ADD c INT UNSIGNED NOT AUTO_INCREMENT,ADD INDEX (c);
Modified columns: ALTER TABLE t2 MODIFY a NOT NULL, CHANGE b c CHAR(20);
Delete columns: ALTER TABLE t2 DROP COLUMN c;

Backup database: mysql\bin\ mysqldump-h (ip) - uroot-p (password) databasename > database.sql
Restore database: mysql\bin\ mysql-h (ip) -uroot-p (password) databasename < database.sql
Copy database: mysql\bin\mysqldump -- all-databases > all-databases.sql
Fix database: mysqlcheck-A-o-uroot-p54safer

Text data import: load data local infile \" file name \" into table table name;
Data import and export: mysql\bin\mysqlimport database tables.txt