mysql commands cheat sheet

Tags: some common commands for MySQL initializationView all users in the MySQL databasemysql> SELECT DISTINCT CONCAT (' User: ', user, ' @ ', host, '; ') as query from Mysql.user;To view the permissions of a specific user in a databaseMysql> Show grants for ' cactiuser ' @ '%';Delete UserDelete from user Where user= ' test ' and host= ' localhost ';Modify User P

mytable; 7: Add a record to the table mysql> INSERT INTO MYTABLE values ("HyQ", "M"); 8: Loading data into a database table in text mode (for example, D:/mysql.txt) mysql> LOAD DATA LOCAL INFILE "D:/mysql.txt" into TABLE MYTABLE; 9: Import. sql File command (for example, D:/mysql.sql) Mysql>use database; Mysql>source

database currently in use: select databases ();1. Delete the students data sheet from the Student_course database:Rm-f student_course/students.* 　　 2. Back up the database: (Backup DATABASE Test)Mysqldump-u root-p Test>c:\test.txtBackup table: (Back up the MyTable table under test database)Mysqldump-u root-p Test Mytable>c:\test.txtImport the backup data into the database: (Back to test database)Mysql-u ro

Data sheet: show tables;Display table structure: describe table name;6.Create Library: Name of creation database;Delete Library: drop database name;Usage Library: Use library name;7.Creating Tables: Create table table names (field settings list);Delete tables: drop table name;Modify table: ALTER TABLE t1 rename T2Query table: SELECT * from table name;Empty table: Truncate table name;Backup table: Mysqlbinmysqldump-h (IP)-uroot-p (password) databasena

[email protected] identified by ' 1234 ';3. Delete a user@>mysql-u root-p@> PasswordMysql>delete from user Where user= ' test ' and host= ' localhost ';Mysql>flush privileges;Mysql>drop database TestDB; Delete a user's databaseDelete account and permissions: >drop user username @ '% ';>drop user username @ localhost;4. Modify the specified user password@>

Tags: style blog color io os using AR file databasic commands for MySQLstart: net start MySQL; Enter: MySQL-U root-P/Mysql-h localhost-U root-p databaseName; list database: show databases; Select database: UsedatabaseName; List table: show tables; Show table column properties: Show Columns fromTableName; Establish a da

Tags: mysql\ directory password dem SQL settings ODI revoke originalMySQL cmd Common command mysql cmd Common command has the following command: Put the Mysql.exe in the bin directory under the MySQL directory under C:\WINDOWS, you can execute the following commandConnection: Mysql-h host address-u user name-P user Pas