SERIAL
Contents
Overview
This is an alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE.
EXAMPLES
CREATE TABLE serial_example ( id SERIAL, data VARCHAR(32) );
SHOW CREATE TABLE serial_example\G
*************************** 1. row ***************************
Table: serial_example
Create Table: CREATE TABLE `serial_example` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`data` varchar(32) DEFAULT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
EXTERNAL REFERENCES
Additional information is available here.
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
