Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `SRC`(
- `id` INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY UNIQUE ,
- `event_id` int(10) NOT NULL ,
- `src` VARCHAR(55) NOT NULL ,
- `alternate` VARCHAR(20) NOT NULL,
- FOREIGN KEY (event_id) REFERENCES TEXTS(id)
- )ENGINE = MyISAM DEFAULT CHARSET =utf8 COLLATE = utf8_unicode_ci;
- CREATE TABLE `TEXTS`(
- `id` INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY UNIQUE ,
- `big_text` VARCHAR(200) NOT NULL ,
- `small_text` VARCHAR(80) NOT NULL ,
- `datetime` DATETIME NOT NULL
- )ENGINE = MyISAM DEFAULT CHARSET =utf8 COLLATE = utf8_unicode_ci;
- SELECT t.id,s.src,s.alternate,t.small_text,t.datetime FROM TEXTS as t
- INNER JOIN SRC s ON s.event_id=t.id
- INNER JOIN (SELECT id FROM TEXTS ORDER BY id LIMIT 3 OFFSET 14) t2
- ON t.id=t2.id;
- SELECT t.id,s.src,s.alternate,t.small_text,t.datetime FROM TEXTS as t
- INNER JOIN SRC s ON s.event_id=t.id WHERE event_id=3;
Add Comment
Please, Sign In to add comment