Guest User

Untitled

a guest
Jan 18th, 2019
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS `chunks` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `start` date NOT NULL,
  4. `length` smallint(4) unsigned NOT NULL,
  5. PRIMARY KEY (`id`)
  6. ) ENGINE=MyISAM ;
  7.  
  8.  
  9. INSERT INTO `chunks` (`id`, `start`, `length`) VALUES
  10. (1, '2012-01-01', 5),
  11. (2, '2012-05-01', 3),
  12. (3, '2012-01-03', 3),
  13. (4, '2012-01-06', 3),
  14. (5, '2012-01-09', 13);
  15.  
  16. 2012-01-01 5
  17. 2012-01-02 4
  18. 2012-01-06 3
Add Comment
Please, Sign In to add comment