How to use the SQL CREATE TABLE statement

The

SQL CREATE TABLE statement is very important in php, and this article will explain it in detail.

CREATE TABLE statement

The CREATE TABLE statement is used tocreate a table in the database.

SQL CREATE TABLE syntax

CREATE TABLE table name
(
Column name 1 Data type,
Column name 2 data type,
Column name 3 data type,
....
)

SQL CREATE TABLE example

This example demonstrates how to create a table named "Person".

The table contains 5 columns, the column names are: "Id_P", "LastName", "FirstName", "Address" and "City":

CREATE TABLE Persons
(
Id_P int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
)

Data type of the Id_P column Is an int, containing integer. The data type of the remaining 4 columns is varchar, with a maximum length of 255 characters.

This article explains the relevant knowledge. For more learning materials, please pay attention to the php Chinese website to view.

Related recommendations:

Understand the relevant knowledge of SQL INNER JOIN keyword

Related knowledge about SQL JOIN

Explanation on SQL Alias ​​(alias) in php

The above is the detailed content of How to use the SQL CREATE TABLE statement. For more information, please follow other related articles on the PHP Chinese website!