SERIAL: Synonym for BIGINT AUTO_INCREMENT NOT NULL PRIMARY KEY : Serial « Data Type « SQL / MySQL

1. SQL / MySQL
2. Data Type
3. Serial

SERIAL: Synonym for BIGINT AUTO_INCREMENT NOT NULL PRIMARY KEY

 
mysql>
mysql>
mysql> CREATE TABLE a (
    ->  choice SERIAL,
    ->  ts TIMESTAMP);
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> drop table a;
Query OK, 0 rows affected (0.00 sec)

   
  

Related examples in the same category