Skip to content

Instantly share code, notes, and snippets.

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<meta http-equiv="x-ua-compatible" content="ie=edge, chrome=1" />
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1, minimum-scale=1">
<title>Accountkit</title>
</head>
<body>
-- NEXTVAL function for mySQL database
-- @see http://www.microshell.com/database/mysql/emulating-nextval-function-to-get-sequence-in-mysql/
-- Table `SEQUENCE_DATA`
DROP TABLE IF EXISTS SEQUENCE_DATA;
CREATE TABLE IF NOT EXISTS `SEQUENCE_DATA` (
`SEQUENCE_NAME` varchar(100) NOT NULL,
`SEQUENCE_INCREMENT` int(11) unsigned NOT NULL DEFAULT 1,
`SEQUENCE_MIN_VALUE` int(11) unsigned NOT NULL DEFAULT 1,