Advertisement
Guest User

Untitled

a guest
May 11th, 2020
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.40 KB | None | 0 0
  1. CREATE TABLE tabela (
  2. id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  3. category INT(11) NOT NULL,
  4. title VARCHAR(30) NOT NULL
  5. );
  6.  
  7. INSERT INTO `tabela` (`id`, `category`, `title`) VALUES
  8. (31, 1, 'Title1'),
  9. (32, 1, 'Title2'),
  10. (33, 5, 'Title3'),
  11. (34, 5, 'Title4'),
  12. (35, 5, 'Title5'),
  13. (36, 6, 'Title6'),
  14. (37, 6, 'Title7'),
  15. (38, 6, 'Title8'),
  16. (39, 8, 'Title9'),
  17. (40, 8, 'Title10'),
  18. (41, 9, 'Title11');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement