CreateTable demo

← List all

← Parse another

Parsing "CREATE TABLE `my_10` (\r\n `..."

Input

Original

CREATE TABLE `my_10` (
  `ip` varchar(64) DEFAULT NULL,
  `uv` varchar(64) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=gbk

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

name data_type allow_null default primary_key unique autoincrement charset collate
ip CHARACTER VARYING(64) true NULL false false false
uv CHARACTER VARYING(64) true NULL false false false

Cross-platform SQL

MySQL
CREATE TABLE my_10 ( ip CHARACTER VARYING(64), uv CHARACTER VARYING(64) )
PostgreSQL
CREATE TABLE my_10 ( ip CHARACTER VARYING(64), uv CHARACTER VARYING(64) )
Sqlite3
CREATE TABLE my_10 ( ip CHARACTER VARYING(64), uv CHARACTER VARYING(64) )

Errata

comments powered by Disqus

© 2017 Brighter Planet, Inc.