How to create a table in mysql

The syntax for creating a table in MySQL is: CREATE TABLE table_name (column_name1 data_type, column_name2 data_type, ...); where table_name is the table name, column_name# is the column name, and data_type is the column data type.

Title: How to create a MySQL table

Answer:
In MySQL The basic syntax for creating a table in is as follows:

CREATE TABLE table_name ( column_name1 data_type, column_name2 data_type, ... );

Detailed description:

• ##table_name:The name of the table you want to create.
• column_name#:The name of each column.
• data_type:The data type of each column. MySQL supports multiple data types, such as VARCHAR, INT, FLOAT, etc.

Example:

studentswith the following columns:

• id(INT) - The student's unique ID
• name(VARCHAR(255)) - The student's name
• age(INT) - The age of the student

CREATE TABLE students ( id INT NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL, age INT NOT NULL );

Notes:

• NOT NULL:Specifies that the column cannot contain null values.
• AUTO_INCREMENT:Automatically generate unique ID values for newly inserted rows.
You can add additional constraints after the column name, such as
• PRIMARY KEY,FOREIGN KEY, andUNIQUE.

The above is the detailed content of How to create a table in mysql. For more information, please follow other related articles on the PHP Chinese website!