SQL Insert statement where single value selects from another table

Question

I have the following SQL:

INSERT INTO Invite VALUES (NULL,?,(SELECT id FROM User WHERE name = ?),?);

However this doesnt seem to work.

Can anyone tell me what i am doing wrong?

Update

The following php code gives me erro code 1136:

 $sql = 'INSERT INTO Invite SELECT NULL, ?, id, ? FROM User WHERE username = ?'; $variables = array($team_id,$_SESSION['User']['id'],$username); $result = $this->db->prepTemplate($sql, 'iis', $variables);

code 1136 clearly mention error "Column count doesn't match value count". Check the number of columns in table Invite. — Naveen
– Naveen, Commented Jan 14, 2014 at 5:14

Jean-Bernard Pellerin · Accepted Answer · 2014-01-14 00:58:30Z

3

INSERT INTO Invite SELECT NULL, ?, id, ? FROM User WHERE name = ?

answered Jan 14, 2014 at 0:58

Jean-Bernard Pellerin

12.7k10 gold badges59 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Marc Rasmussen Over a year ago

i cannot get the following to work: INSERT INTO Invite SELECT NULL, ?, id, ? FROM User WHERE username = ?

Collectives™ on Stack Overflow

SQL Insert statement where single value selects from another table

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related