mysql CREATE TABLE statement

create

UK[kriˈeɪt] 美[kriˈet]

vt. To produce; to create, to create; to ennoble, to ennoble...(noble)

vi.[English][Slang] Lose your temper, complain

Third person singular: creates Present participle: creating Past tense: created Past participle: created

table

英[ˈteɪbl] 美[ˈtebəl]

n.Table; table, directory; operating table, workbench, game table; flat floor

vt. tabulation; shelving; chimera; shelving

adj.table

Third person singular: tables Plural: tables Present participle: tabling Past tense: tabled

mysql CREATE TABLE statement syntax

Function:Create a table in the database.

Syntax: CREATE TABLE table name (column name 1 data type, column name 2 data type, column name 3 data type,....)

mysql CREATE TABLE statement example

//创建名为 "Person" 的表。该表包含 5 个列，列名分别是："Id_P"、"LastName"、"FirstName"、"Address" 以及 "City"
CREATE TABLE Persons(Id_P int,LastName varchar(255),FirstName varchar(255),Address varchar(255),City varchar(255));