Skip to content

Instantly share code, notes, and snippets.

@m00dawg
Created July 8, 2010 15:34
Show Gist options
  • Save m00dawg/468157 to your computer and use it in GitHub Desktop.
Save m00dawg/468157 to your computer and use it in GitHub Desktop.
DROP DATABASE test;
CREATE DATABASE test;
USE test;
CREATE TABLE t1 (num1 SERIAL) ENGINE='InnoDB';
INSERT INTO t1 VALUES ('');
INSERT INTO t1 VALUES ('');
INSERT INTO t1 VALUES ('');
INSERT INTO t1 VALUES ('');
CREATE VIEW v1 AS SELECT * FROM t1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment