cmd operation in Windows MySQL (RPM)

Switch the working directory to the bin of MySQL

Mysql-u root-p

Enter your password to log in to MySQL

Question mark to view Help

First you need to select the Operational database use database_name

You can then perform the Select and other operations

It should be noted that the operation should remember the end of the semicolon

If you forget to enter a semicolon you can use \c to end the command input

Common operations are the following table

The Mysql.exe in the bin directory under the MySQL directory is placed under C:\WINDOWS, and you can execute the following command

Connection: Mysql-h host address-u user name-P user Password (note: U and root can be used without spaces, others are the same)
Disconnect: Exit (Enter)


Create authorization: Grant SELECT on database. * To User name @ login host identified by \ "Password \"
Change Password: mysqladmin-u user name----old password password new password
Delete authorization: Revoke select,insert,update,delete OM * * from [email protected];


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


Create Library: Name of creation database;
Delete Library: drop database name;
Usage Library: Use library name;


Creating Tables: Create table table names (field settings list);
Delete tables: drop table name;
Modify 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 table: Mysqlbinmysql-h (IP)-uroot-p (password) databasename tablename < Tablename.sql (first delete the original table before operation)


Add column: ALTER TABLE T2 ADD C INT UNSIGNED not NULL auto_increment,add INDEX (c);
Modify column: ALTER TABLE T2 MODIFY A TINYINT not NULL, change b C CHAR (20);
Delete column: ALTER TABLE T2 DROP column C;


Backup database: Mysql\bin\mysqldump-h (IP)-uroot-p (password) databasename > Database.sql

cmd operation in Windows MySQL (RPM)