Advertisement
Guest User

Untitled

a guest
Oct 23rd, 2014
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.17 KB | None | 0 0
  1. INSERT INTO `table` (`number`, `year`, `data`)
  2. VALUES (
  3. (SELECT MAX(`number`) + 1 FROM `table` WHERE `year` = YEAR(CURDATE())),
  4. YEAR(CURDATE()),
  5. 'some data...'
  6. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement