Skip to content

Instantly share code, notes, and snippets.

@Swader
Created February 14, 2014 01:22
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 Swader/8994154 to your computer and use it in GitHub Desktop.
Save Swader/8994154 to your computer and use it in GitHub Desktop.
Sample DB with test table and three sample rows
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
DROP SCHEMA IF EXISTS `sample` ;
CREATE SCHEMA IF NOT EXISTS `sample` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
USE `sample` ;
-- -----------------------------------------------------
-- Table `sample`.`test`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`test` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`key` VARCHAR(45) NULL,
`value` VARCHAR(45) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
-- -----------------------------------------------------
-- Data for table `sample`.`test`
-- -----------------------------------------------------
START TRANSACTION;
USE `sample`;
INSERT INTO `sample`.`test` (`id`, `key`, `value`) VALUES (NULL, 'key one', 'value one');
INSERT INTO `sample`.`test` (`id`, `key`, `value`) VALUES (NULL, 'key two', 'value two');
INSERT INTO `sample`.`test` (`id`, `key`, `value`) VALUES (NULL, 'key three', 'value three');
COMMIT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment