In this section we are covering the topics like ANALYZE TABLE, BACKUP TABLE, CHECK TABLE, CHECKSUM TABLE, OPTIMIZE TABLE, REPAIR TABLE, RESTORE TABLE Syntax.
ANALYZE TABLE Syntax
The general syntax of ANALYZE TABLE statement is:
        ANALYZE [LOCAL | NO_WRITE_TO_BINLOG] TABLE tbl_name [, tbl_name] …
This syntax is used to analyze and store the key distribution to a table. [...]

Continue reading...

In MySQL user account information’s are stored in mysql database tables. In this section we will describe you about Create User, Drop User, Grant Syntax, Rename User, Revoke Syntax and Set Password Syntax. 
CREATE USER Syntax
The general syntax of CREATE USER statement is :
        CREATE USER user [IDENTIFIED BY [PASSWORD] ‘password’]…..
In MySQL version 5.0.2 include the [...]

Continue reading...