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:

<code>CREATE TABLE table_name (
  column_name1 data_type,
  column_name2 data_type,
  ...
);</code>

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:

Suppose you want to create a table named

students with the following columns:

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

This table can be created using the following statement:

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

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, and UNIQUE.

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!