Advertisement
Guest User

Untitled

a guest
Apr 26th, 2015
194
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.60 KB | None | 0 0
  1. DROP TABLE products;
  2.  
  3. CREATE TABLE products(
  4. id int not null auto_increment,
  5. name varchar(255),
  6. stocks int,
  7. created_at datetime,
  8. updated_at datetime,
  9. primary key (id)
  10. ) ENGINE=InnoDB;
  11.  
  12. INSERT INTO products(name, stocks, created_at, updated_at) values('high performance mysql', 1, now(), now());
  13. INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
  14. INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
  15. INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
  16. INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
  17. INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
  18. INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
  19. INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
  20. INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
  21. INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
  22. INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
  23. INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
  24. INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
  25. INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
  26. INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
  27. INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
  28. INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
  29. INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
  30. INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
  31. INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
  32. INSERT INTO products(name, stocks, created_at, updated_at) SELECT name, stocks, created_at, updated_at FROM products;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement