SLTechnology News&Howtos › Database ›

Database creation and basic knowledge

Shulou Source: shulou.com Published: 2022-06-01 22:39:16 11月07日 Update

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