Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE tmp(
- guid text default (hex(randomblob(16))) primary key,
- note text
- );
- Insert into tmp(note) VALUES
- ('val1'),
- ('val2'),
- ('val3'),
- ('val4'),
- ('val5'),
- ('val6'),
- ('val7');
- select * from tmp;
- -- Select last GUID:
- select * from tmp LIMIT (select count(*) from tmp)-1, 1;
Add Comment
Please, Sign In to add comment