MySQL Common commands

Install a MySQL5.5.27 today to see some common commands

1. Log in to MySQL
In the cmd window, go to the MySQL-Installed bin directory,
Command: bin >mysql–u root–p [database name] carriage return, enter password

2. View version number:mysql>select versions ();

3. View server Current date:mysql> select Current_date;

4. View all databases on the server:mysql> show databases;

5. View the name of the database currently being manipulated:mysql> Select Databases ();

6. Switch database:mysql>use databasename;

7. View all table names under the current database:mysql>show tables;

8. View table structure:mysql>describe tablename;

In addition, Sqlyog-9.6.1-0community is installed to display MySQL graphical interface for easy data operation.

MySQL Common commands