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 usage

a) when inserting ignore in the execution of a command , there is no error when inserting the primary key repeatedly.

5, Get help

A) help is available for assistance

b) "Show databases \p;" or direct "\p", the parameter \p prints out the executed statement. PS( The parameter format in Help is the same as \p )

6, display the database creation, or the language created by the table

A) Show create database / table

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Mysql Environment Configuration Query