Question

MySQL: Insert a row and get the content?

Answer 1

Something like...

INSERT INTO `items` (`item`, `number`, `state`)

(SELECT '3', `number`, `state` FROM `item_bug` WHERE `id`='3')

And then, get ID and execute a

SELECT * FROM `items` WHERE `id`='$id'

But using only one query.