Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO `table` (`number`, `year`, `data`)
- VALUES (
- (SELECT MAX(`number`) + 1 FROM `table` WHERE `year` = YEAR(CURDATE())),
- YEAR(CURDATE()),
- 'some data...'
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement