futharksoftware
vishalkurup
/ iosjson.sql
Last active
April 17, 2016 00:23
SQL code to generate the table and data we will use in our PHP json page. This data will be consumed in our iOS app. This is the companion code to my iOS Tutorial on loading data from an external database into a table view on YouTube. Youtube channel: www.youtube.com/vtkurup/
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- create table | |
| CREATE TABLE cities | |
| ( | |
| id INT PRIMARY KEY NOT NULL auto_increment, | |
| cityName VARCHAR(255), | |
| cityState VARCHAR(255), | |
| cityPopulation int, | |
| country VARCHAR(255) | |
| ); |