CreateTable demo

← List all

← Parse another

Parsing "create table lll\r\n(\r\n id ..."

Input

Original

create table lll
(
   id bigint not null
)

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: 1

name data_type allow_null default primary_key unique autoincrement charset collate
id BIGINT false false false false

Cross-platform SQL

MySQL
CREATE TABLE lll ( `id` BIGINT )
PostgreSQL
CREATE TABLE lll ( "id" BIGINT )
Sqlite3
CREATE TABLE lll ( "id" BIGINT )

Errata

comments powered by Disqus

© 2017 Brighter Planet, Inc.