Mysql Environment Configuration Query

Mysql Environment Query

1. View all Engines

A) show engines or go inside the Information_schama to see the engines table .

2, view current user

A) Select user () can view the current

b) Show full processlist view current operations

3. View Environment variables

A) Show variables View all environment variables

4. Ignore how to use

A) when inserting a ignore in a Run command , it is not an error when inserting the primary key repeatedly.

5, Get help

A) help to get assistance

b) "Show databases \p;" or direct "\p", the number of references \p print out the statement being run.

PS ( Help the format of the parameters in the \p same)

6. Displays database creation. or the language created by the table

A) Show create database / table

Mysql Environment Configuration Query