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

1. Database operations:

Create: create databases xxx

Use: use xxx

Delete: drop databases xxx

Display: show databases

Data type:

Numerical type:

1. Integer:

Bit 、 int

two。 Floating point type:

Float 、 double 、 decimal

String type:

1.varchar: normal string

2.text: large text

Date type:

Datetime

Timestamp

two。 Operation of the table:

Usage table: use xxx

View table structure: desc xxx

Create a table: create table (...)

Delete table: drop table xxx

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.