MySQL command line client uses commands

Source: Internet
Author: User
Tags mysql command line

Original address: http://blog.csdn.net/jack2009win/article/details/6319261

Feel good to write, copy it.

Semicolons can't forget semicolons can't forget semicolons can't forget

The important thing three times

1. Enter the password: ******
2.ues MySQL; using MySQL
3.show databases; Show database
4.use Register; Use the database named register
5.show tables; Displays the tables in the Register database
6.describe user, operation on table User:

Insert into User (Username,password) VALUES ("XiaoYan", "123456"); Insert data
Insert into User (Username,password) VALUES ("FF", "123456"); Insert data
Delete from user where username= "XiaoYan";
Update user set Username= "XiaoYan" where username= "FF";
select * from user; query data

7.quit; launch
1. Displays the list of databases in the current database server:
Mysql> SHOW DATABASES;
Note: MySQL library has the MySQL system information, we change the password and new users, is actually using this library to operate.
2. Display the data table in the database:
mysql> use library name;
Mysql> SHOW TABLES;
3, display the structure of the data table:
mysql> DESCRIBE table name;
4. Establish the database:
mysql> CREATE database name;
5. Set up the data sheet:
mysql> use library name;
mysql> CREATE table name (field name VARCHAR (20), Field name CHAR (1));
6. Delete the database:
mysql> DROP database name;
7. Delete Data sheet:
mysql> DROP table name;
8. Empty the records in the table:
Mysql> DELETE from table name;
9. Display the records in the table:
Mysql> SELECT * from table name;
10. Insert a record into the table:
mysql> INSERT into table name VALUES ("HyQ", "M");
11. Update the data in the table:
mysql-> UPDATE table name SET field name 1= ' A ', field name 2= ' B ' WHERE field name 3= ' C ';
12. Load data into the data table in text mode:
mysql> LOAD DATA LOCAL INFILE "d:/mysql.txt" into table name;
13. Import the. sql File command:
mysql> use database name;
Mysql> SOURCE D:/mysql.sql;
14, the command line to modify the root password:
mysql> UPDATE mysql.user SET password=password (' New password ') WHERE user= ' root ';
mysql> FLUSH privileges;
15. Display the database name of use:
Mysql> SELECT DATABASE ();
16. Display the current User:
Mysql> SELECT USER ();

MySQL command line client uses commands

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.