MySQL Small finishing

Some small knowledge of using MySQL today

1. Log in to MySQL

Native: Command interface

Mysql-u username-p Password

Login to the specified machine: Port not modified

Mysql-u username-h IP address-p assword

Log on to the specified machine: Port modification

Mysql-u username-h IP Address--port port number-p Assword

View the database supported engines through the interface: The Navicat tool allows you to see

->information_schema Library->engines Table

The tables table in this library gives you a detailed idea of which engine is on a table.

To view the engine's version from the command line

SELECT Plugin_name, Plugin_version, Plugin_type_version, plugin_author from Inform
Ation_schema. PLUGINS WHERE plugin_name = ' InnoDB ';

View the version of your InnoDB, my version is 50615

The Show Engine InnoDB Status command allows you to see if a deadlock has occurred

Some versions need to execute the show InnoDB status command (MySQL follow-up version has been made with the new, command also has a slight change)

Reference Link: http://www.cnblogs.com/ggjucheng/archive/2012/11/07/2758014.html

Reference manual: http://dev.mysql.com/doc/refman/5.1/zh/

About INFORMATION_SCHEMA Library: http://dev.mysql.com/doc/refman/5.1/zh/information-schema.html