Skip to content

Instantly share code, notes, and snippets.

@curtiszimmerman

curtiszimmerman/sample.sql

Created August 15, 2016 19:57
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 curtiszimmerman/6bc63d5a91b0ab9a0ccdce89ad5c63a0 to your computer and use it in GitHub Desktop.
Save curtiszimmerman/6bc63d5a91b0ab9a0ccdce89ad5c63a0 to your computer and use it in GitHub Desktop.
Download ZIP
Sample SQL Import
Raw
sample.sql
CREATE DATABASE IF NOT EXISTS Testing;
CREATE USER 'testing'@'%' IDENTIFIED BY '';
GRANT ALL PRIVILEGES ON Testing.* TO 'testing'@'%';
CREATE TABLE `Testing`.`Test` (
`Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`Data` int(11) DEFAULT NULL,
`Url` varchar(255) DEFAULT NULL,
`Timestamp` int(11) DEFAULT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment