Shulou(Shulou.com)06/01 Report--

A simple DOS command to operate the database

Startup service: net start database service name

Shutdown service: net stop database service name

Connect to the database: mysql-u username-p password

Show databases-shows all the libraries in the server

Show tables;-shows all the tables in the library

Select * from table name; query all data in the specified table

Build the database:

Syntax: CREATE DATABASE database name DEFAULT CHARSET='utf8'

Use the library:

Syntax: USE database name

Use database name-Select the database to use

Delete the library:

Syntax: DROP DATABASE 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); the values of all column names of this table must be written in the following values

Quit-exit the current connection

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.