Creating Tables with AUTO_INCREMENT and NOT NULL column : Create Table « Table « MySQL Tutorial






  1. MySQL Tutorial
  2. Table
  3. Create Table

The attribute AUTO_INCREMENT for the column id has the effect that with each new record the appropriate value for id is automatically inserted.

The attribute NOT NULL ensures that actual values must be placed in both columns. It is not permitted to store the data record NULL or not to insert any value at all. Thus this attribute prevents invalid data records from being stored.

PRIMARY KEY (id) has the effect that the column id is used to identify the data records.

mysql>
mysql> CREATE TABLE myTable (
    ->    id      INT     NOT NULL AUTO_INCREMENT,
    ->    choice  TINYINT NOT NULL,
    ->    ts      TIMESTAMP,
    ->    PRIMARY KEY (id));
Query OK, 0 rows affected (0.05 sec)

mysql>
mysql> DROP TABLE myTable;
Query OK, 0 rows affected (0.00 sec)

mysql>








4.1.Create Table
4.1.1.The syntax for creating a table
4.1.2.Creating Tables with AUTO_INCREMENT and NOT NULL column
4.1.3.Use a CREATE TABLE statement to specify the layout of your table:
4.1.4.'IF NOT EXISTS' parameter can be used to check if a table exists before you actually create it
4.1.5.CREATE TABLE table_name (column_name field_type [NULL|NOT NULL],KEY col_index(column_name));
4.1.6.TYPE=MYISAM
4.1.7.Copy a table with Create ... Select statement
4.1.8.Create a table by UNION another table
4.1.9.Creating table with Foreign key
4.1.10.Creating a Table with an Index
4.1.11.Table and Column Definition with character and collate
4.1.12.The CHARACTER SET attribute specifies the character set, and the COLLATE attribute specifies a collation for the character set