SERIAL
This page is part of MariaDB's Documentation.
The parent of this page is: Data Types for MariaDB Enterprise Server
Topics on this page:
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
CHANGE HISTORY
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.