What command is used to create a basic table in sql

The command to create a basic table in SQL is CREATE TABLE. It is used to create a basic table with column names, data types and constraints like NOT NULL, DEFAULT.

Commands to create basic tables in SQL

In SQL, useCREATE TABLEcommand to create basic tables.

Syntax:

CREATE TABLE table_name ( column_name1 data_type [NOT NULL | NULL] [DEFAULT default_value], column_name2 data_type [NOT NULL | NULL] [DEFAULT default_value], ... column_nameN data_type [NOT NULL | NULL] [DEFAULT default_value] );

Parameters:

• table_name:Table name.
• column_name:Column name.
• data_type:The data type of the column (for example, INT, VARCHAR, DATE).
• NOT NULL | NULL:Specify whether the column allows NULL values.
• DEFAULT default_value:Specifies the default value of the column (if specified).

Example:

Create a table namedcustomerswithcustomer_id(primary key),first_name,last_nameandemailcolumns:

CREATE TABLE customers ( customer_id INT NOT NULL AUTO_INCREMENT, first_name VARCHAR(50) NOT NULL, last_name VARCHAR(50) NOT NULL, email VARCHAR(100) UNIQUE NOT NULL );

Note:

• Primary Key Columns are defined usingPRIMARY KEYconstraints.
• Unique index columns are defined usingUNIQUEconstraints.
• Auto-increment columns are defined using theAUTO_INCREMENTkeyword.

The above is the detailed content of What command is used to create a basic table in sql. For more information, please follow other related articles on the PHP Chinese website!