Simple DOS command operation database

Simple DOS command operation database

Start service: NET start database service name

Shutdown Service: net stop database service name

Connection database: Mysql-u user name-p password

Show databases--show all the libraries in the server

Show tables; --Show all the tables in the library

SELECT * from table name; Querying all data in a specified table

Build Library:

Syntax: CREATE database name DEFAULT charset= ' UTF8 ';

Using libraries:

Syntax: use database name;

Use database name--Select the database to be used

To delete a library:

Syntax: DROP database name;

Added: INSERT into table name (column name 1, column name 2, column name 3,.....) VALUES (column name 1 value, column name 2 value, column name 3 value,...);

Insert into table name values (column name 1 value, column name 2 value, column name 3 value); In the following values, you must write the value of all the column names in this table.

Quit--Exits the current connection

Simple DOS command operation database