I have this query, but don't work....
INSERT INTO Tests (Name) VALUES ('aaaaaa') SELECT ID FROM Tests WHERE Name='aaaaaa';
My table is:
| ID | Name |
| 1 | Test111 |
| 2 | Test222 |
| 3 | Test333 |
| 4 | Test444 |
I want insert value 'aaaaaa' and I want select ID only in one query....
Can you help????