Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO `aTable` (`A`,`B`) VALUES((SELECT MAX(`A`) FROM `aTable`)*2),'name');
- INSERT INTO `aTable` (`A`, `B` )
- VALUES
- (
- (
- SELECT MAX(`A`)
- FROM `aTable`
- ) *2
- , 'name'
- )
- insert into aTable select max(a)^2, 'name' from aTable;
- insert into aTable select max(a)^2, 'name' from aTable group by B;
- insert into aTable select max(a)^2, 'name' from aTable, bTable;
- INSERT INTO `aTable` (`A`,`B`)
- SELECT MAX(`A`)^2,'name' FROM `aTable`
Add Comment
Please, Sign In to add comment