Guest User

Untitled

a guest
Dec 14th, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. CREATE TABLE `SRC`(
  2. `id` INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY UNIQUE ,
  3. `event_id` int(10) NOT NULL ,
  4. `src` VARCHAR(55) NOT NULL ,
  5. `alternate` VARCHAR(20) NOT NULL,
  6. FOREIGN KEY (event_id) REFERENCES TEXTS(id)
  7. )ENGINE = MyISAM DEFAULT CHARSET =utf8 COLLATE = utf8_unicode_ci;
  8.  
  9.  
  10.  
  11. CREATE TABLE `TEXTS`(
  12. `id` INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY UNIQUE ,
  13. `big_text` VARCHAR(200) NOT NULL ,
  14. `small_text` VARCHAR(80) NOT NULL ,
  15. `datetime` DATETIME NOT NULL
  16. )ENGINE = MyISAM DEFAULT CHARSET =utf8 COLLATE = utf8_unicode_ci;
  17.  
  18. SELECT t.id,s.src,s.alternate,t.small_text,t.datetime FROM TEXTS as t
  19. INNER JOIN SRC s ON s.event_id=t.id
  20. INNER JOIN (SELECT id FROM TEXTS ORDER BY id LIMIT 3 OFFSET 14) t2
  21. ON t.id=t2.id;
  22.  
  23. SELECT t.id,s.src,s.alternate,t.small_text,t.datetime FROM TEXTS as t
  24. INNER JOIN SRC s ON s.event_id=t.id WHERE event_id=3;
Add Comment
Please, Sign In to add comment