1 show
show tables; Show all tables of the database show databases ; for [email protected]; View the permissions of the current user show index from table; View the indexes of the current table definition
2 Describe getting information about columns
The Replace function of show columns
Describe table;describe columns;
3 Explain understanding the work process of the query
1) explain tables; The Direct query table is the same as describe table,show columns results
2) explain select * FROMT table; Querying SQL statements directly
4 MySQL Fulltext
Full-text indexes are typically used in fields of type text varchar, etc.
Most applications are under the MyISAM engine
The latest innodb in more than 5.6 versions also supports
Use MATCH () on the result ... Against syntax for querying
CREATE TABLE articles ( ID INT UNSIGNED auto_increment not NULL PRIMARY KEY, title VARCHAR ( ), body TEXT, Fulltext (title,body)) ENGINE
SELECT * from articles WHERE MATCH (title,body) against ('database'
5 MySQL Database Export Import
1) Import
After logging in to the corresponding database, locate the path to the SQL file and execute it directly
SOURCE 1.sql
2) Export
Mysqldump dbname >1.sql
6 resuming MySQL
The Mysqlbinlog log must be turned on before you can use
hostname-bin. [0-9]* | Mysql
Some grammatical show,describe,explain,fulltext of new-mysql are known by Wen