Advertisement
Guest User

test table

a guest
Feb 16th, 2011
403
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.55 KB | None | 0 0
  1.  
  2. CREATE TABLE IF NOT EXISTS `test` (
  3.   `id` smallint(6) NOT NULL AUTO_INCREMENT,
  4.   `text` varchar(7) NOT NULL,
  5.   PRIMARY KEY (`id`)
  6. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;
  7.  
  8.  
  9.  
  10. INSERT INTO `test` (`id`, `text`) VALUES
  11. (1, 'text 1'),
  12. (2, 'text 2'),
  13. (3, 'text 3'),
  14. (4, 'text 4'),
  15. (5, 'text 5'),
  16. (6, 'text 6'),
  17. (7, 'text 7'),
  18. (8, 'text 8'),
  19. (9, 'text 9'),
  20. (10, 'text 10'),
  21. (11, 'text 11'),
  22. (12, 'text 12'),
  23. (13, 'text 13'),
  24. (14, 'text 14'),
  25. (15, 'text 15'),
  26. (16, 'text 16'),
  27. (17, 'text 17'),
  28. (18, 'text 18'),
  29. (19, 'text 19');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement