mysql CREATE TABLE statement
Translation results:
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 statementsyntax
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 statementexample
//创建名为 "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));