Skip to content

Instantly share code, notes, and snippets.

@tanepiper

tanepiper/Correct Secret

Created September 20, 2010 16:51
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tanepiper/bea5d75754cf5f05a57b to your computer and use it in GitHub Desktop.
Save tanepiper/bea5d75754cf5f05a57b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Correct
CREATE TABLE IF NOT EXISTS `Locations` (`id` INT NOT NULL auto_increment PRIMARY KEY, `name` VARCHAR(255), `narrative` TEXT, `priority` INT, `type` VARCHAR(255), `group` VARCHAR(255), `address` TEXT, `postcode` VARCHAR(255), `time_to_recover` VARCHAR(255), `createdAt` DATETIME, `updatedAt` DATETIME)
Raw
Incorrect
CREATE TABLE IF NOT EXISTS Locations (id INT NOT NULL auto_increment PRIMARY KEY, name VARCHAR(255), narrative TEXT, priority INT, type VARCHAR(255), group VARCHAR(255), address TEXT, postcode VARCHAR(255), time_to_recover VARCHAR(255), createdAt DATETIME, updatedAt DATETIME)
Raw
Select Example
SELECT `foo`, `bar`, `group` FROM `table` WHERE `id` = 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment