MySQL Common commands

Basic command:

1  <!--command to add '; ' Indicates the end of the command -2mysql> status<!--Check current login information, MySQL version information -3Mysql> Help<!--frequently used help commands -4Mysql> select version ();<!--MySQL version information -5Mysql> exit;<!--quit MySQL -6Mysql> quit;<!--quit MySQL -Mysql> Ctrl + C (mouse button)<!--exit the current command line-
7 mysql> Select Now (); <!--Check current time--
8 mysql> Select version (); <!--Check the current MySQL version--
9 mysql> Select Now () version (); <!--version and time display query --

Database Operations Command:

1mysql> show databases;<!--Show All Databases -2mysql> use MyDB;<!--Use a database -3 mysql> Show tables; 4 mysql> desc t_user;5 mysql> drop table t_user;6mysql> CREATE DATABASE MyDB;<!--Create a database -7mysql> drop Database mydb;<!--Deleting a database -

MySQL Common commands