Some grammatical show,describe,explain,fulltext of new-mysql are known by Wen

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