CREATE TABLE in MySQL

CREATE TABLE in MySQL

by

CREATE TABLE In MySQL, the MySQL CREATE TABLE statement is used to create a new table in a database. Syntax 1: To create a Table in MySQL. CREATE TABLE table_name ( column_1 data_type column_constraint, column_2 data_type column_constraint, … ); Syntax 2: To see all the already created Tables in a database. SHOW tables; Syntax 3: … Read more

CREATE TABLE in MySQL

by

MySQL CREATE TABLE To create a new table in a database, MySQL provides the MySQL CREATE TABLE statement. Syntax 1: To create a Table in MySQL. CREATE TABLE table_name ( column_1 data_type column_constraint, column_2 data_type column_constraint, … ); Syntax 2: To see all the already created Tables in a database. SHOW tables; Syntax 3: To … Read more