#MYSQL WORKBENCH FOR MAC TUTORIAL HOW TO#

Third, after the column lists, you can specify the table constraints such as PRIMARY KEY, FOREIGN KEY, UNIQUE, and CHECK.ДЇor example, if you want to declare the primary key on the combination of two or more columns, you can use the following syntax. In MySQL, the initial value for the AUTO_INCREMENT is 1 and each table can have a maximum of one AUTO_INCREMENT column.

Iv) The AUTO_INCREMENT specifies that the value of the column is automatically incremented by one whenever a new row is inserted into the table. Iii) The optional parameter DEFAULT specifies the default value for the column that means if a value is not provided for the column during data insertion, the default value will be inserted.

Besides NOT NULL, you can specify constraints such as UNIQUE, CHECK, etc. Ii) After the column name and data type, you optionally specify the NOT NULL constraint which ensures that the column will not contain any null value. Each column has a data type and optional size e.g. I) The column_name denotes the name of the column. Each column is separated by commas.Д«elow is the generic syntax of a column definition: column_name data_type(length) Second, you specify the list of columns required for the table along with the columnвЂ™s data types and columnвЂ™s constraints. Optionally, you can use IF NOT EXIST after the CREATE TABLE keywords, the MySQL will not throw any error in case of a duplicate table. If the table name you specify already exists in the database, MySQL throws an error. The name of the table should be unique within the database. LetвЂ™s understand each termвЂ™s in great detail.ДЇirst, you specify the name of the table after the CREATE TABLE keywords. The following illustration shows the generic syntax for creating a table in the MySQL database. The CREATE TABLE statement is used to create a new table in the MySQL database. So, we must have a very clear idea about creating a table in any relational database. MySQL CREATE TABLE IntroductionДЄ table in any relational database is a basic element that holds data in the form of rows and columns.

#MYSQL WORKBENCH FOR MAC TUTORIAL HOW TO#

Summary: in this tutorial, you will learn how to create a new table in the MySQL database using the CREATE TABLE statement.

Mysql workbench for mac tutorial