Skip to content

Instantly share code, notes, and snippets.

@vishalkurup

vishalkurup/iosjson.sql

Last active April 17, 2016 00:23
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save vishalkurup/5382389 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save vishalkurup/5382389 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. vishalkurup revised this gist Apr 14, 2013. 1 changed file with 2 additions and 2 deletions.
    4 changes: 2 additions & 2 deletions iosjson.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -13,10 +13,10 @@ INSERT INTO cities(cityName, cityState, cityPopulation, country)
    VALUE ('London', 'London', 8173194, 'United Kingdom');

    INSERT INTO cities(cityName, cityState, cityPopulation, country)
    VALUE ('Bombay', 'Maharashtra', 12478447, 'United Kingdom');
    VALUE ('Bombay', 'Maharashtra', 12478447, 'India');

    INSERT INTO cities(cityName, cityState, cityPopulation, country)
    VALUE ('Kuala Lumpur', 'Federal Territory', 1627172, 'United Kingdom');
    VALUE ('Kuala Lumpur', 'Federal Territory', 1627172, 'Malaysia');

    INSERT INTO cities(cityName, cityState, cityPopulation, country)
    VALUE ('New York', 'New York', 8336697, 'United States');
  2. vishalkurup renamed this gist Apr 14, 2013. 1 changed file with 0 additions and 0 deletions.
    0 iosjosn.sql → iosjson.sql
    View file
    File renamed without changes.
  3. vishalkurup revised this gist Apr 14, 2013. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion iosjosn.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,7 +1,7 @@
    -- create table
    CREATE TABLE cities
    (
    id INT PRIMARY KEY NOT NULL auto_increment,
    id INT PRIMARY KEY NOT NULL auto_increment,
    cityName VARCHAR(255),
    cityState VARCHAR(255),
    cityPopulation int,
  4. vishalkurup created this gist Apr 14, 2013.
    26 changes: 26 additions & 0 deletions iosjosn.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,26 @@
    -- create table
    CREATE TABLE cities
    (
    id INT PRIMARY KEY NOT NULL auto_increment,
    cityName VARCHAR(255),
    cityState VARCHAR(255),
    cityPopulation int,
    country VARCHAR(255)
    );

    -- Insert data into our table
    INSERT INTO cities(cityName, cityState, cityPopulation, country)
    VALUE ('London', 'London', 8173194, 'United Kingdom');

    INSERT INTO cities(cityName, cityState, cityPopulation, country)
    VALUE ('Bombay', 'Maharashtra', 12478447, 'United Kingdom');

    INSERT INTO cities(cityName, cityState, cityPopulation, country)
    VALUE ('Kuala Lumpur', 'Federal Territory', 1627172, 'United Kingdom');

    INSERT INTO cities(cityName, cityState, cityPopulation, country)
    VALUE ('New York', 'New York', 8336697, 'United States');

    INSERT INTO cities(cityName, cityState, cityPopulation, country)
    VALUE ('Berlin', 'Berlin', 3538652, 'Deutschland');