CreateTable demo

← List all

← Parse another

Parsing "CREATE TABLE IF NOT EXISTS ..."

Input

Original

CREATE TABLE IF NOT EXISTS `group_` (
  `group_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `group_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `group_description` text COLLATE utf8_unicode_ci,
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`group_id`),
  KEY `group_id` (`group_id`)
) ENGINE;

Results

  1. Table structure
  2. Cross-platform SQL
  3. Errata

CreateTable is still young—please comment on any errors or surprises in the Errata section! Thank you.

Table structure

Number of columns: 0

name data_type allow_null default primary_key unique autoincrement charset collate

Cross-platform SQL

MySQL
CREATE TABLE `IF` (  )
PostgreSQL
CREATE TABLE "IF" (  )
Sqlite3
CREATE TABLE "IF" (  )

Errata

comments powered by Disqus

© 2017 Brighter Planet, Inc.