Skip to content

Instantly share code, notes, and snippets.

@takatoshiono
Last active January 29, 2016 03:53
Show Gist options
  • Save takatoshiono/41bfc4ec52c3a89da2eb to your computer and use it in GitHub Desktop.
Save takatoshiono/41bfc4ec52c3a89da2eb to your computer and use it in GitHub Desktop.
オンラインDDLの実験用データ
DROP TABLE products;
CREATE TABLE products(
id int not null auto_increment,
name varchar(255),
stocks int,
created_at datetime,
updated_at datetime,
primary key (id)
) ENGINE=InnoDB;
INSERT INTO products(name, stocks, created_at, updated_at) values('high performance mysql', 1, now(), now());
INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment