两个INSERT INTO语句用于同一行SQL / php

Question

I have been trying so hard and I can't find a solution for this problem. I have two different INSERT statements:

INSERT INTO `logList`(`User_ID`) SELECT `User_ID` FROM `userList` WHERE keyname='somevalue';
INSERT INTO `logList`(`ttime`) VALUES (CURRENT_TIMESTAMP);

If I execute them, they will of course insert 2 different rows. How can I make a single INSERT that returns only one row? Thank you in advance.

Answer 1

I am going to assume that this is what you really want:

INSERT INTO logList (User_ID, ttime)
    SELECT User_ID, CURRENT_TIMESTAMP
    FROM userList
    WHERE keyname = 'somevalue';

I doubt you want two separate rows, one with the user and NULL for time and the other with NULL for user and a value of the time.

I should note that you can define the loglist so ttime is defaulted to the current timestamp on the insert. The use of such defaults is described in the documentation.

If you did that, then:

INSERT INTO logList (User_ID)
    SELECT User_ID
    FROM userList
    WHERE keyname = 'somevalue';

would always set ttime.