you are at Encyclopedia of SQL >> CREATE TABLE
CREATE TABLE
This keyword creates new table.Syntax
CREATE TABLE `table_name`
{
`column_name1` data_type
`column_name2` data_type
...
}
Example
Create table `people` for name, surname and evidence_id
query
CREATE TABLE `people`
{
`name` text
`surname` text
`evidence_id` int
}
result
name | surname | evidence_id |
---|