Insert Into Where (syntax help)

[theresep]

I am having trouble with the syntax on this;

INSERT INTO t1.mgroup VALUES(11) SELECT FROM members AS t1, moredata AS t2 WHERE t1.id = t2.member_id AND t1.mgroup = 3 AND t2.field_1 ="N"

The objective is that in table Members, I want to insert the number 11 where the member id =3 and the extra data table = "N". The insert and select syntax is challenging to me.

Thanks

 

[ericbrunson]

select what? That's not a valid select statement because you don't have a list of fields.

 

[theresep]

sorry, I am really trying this..

INSERT INTO t1.mgroup VALUES(11) SELECT t1.mgroup,t2.field_1 FROM members AS t1, moredata AS t2 WHERE t1.id = t2.member_id AND t1.mgroup = 3 AND t2.field_1 ="N

 

[ericbrunson]

I think you're trying to do something that you can't or else just making it way more difficult than it should be.

Create a select statement that gets the values you want to insert, then stick "insert into desttable ( list, of, columns, to, insert, into )" in front of it.

 

[theresep]

my select statement works, but my conditional insert isn't working. I must be approaching this wrong.. thanks.

 

[ericbrunson]

There's not such thing as an "insert where" Are you really wanting to do an "update where"?

 

[theresep]

I am going to try UPDATE, but where my confusion must be is that in the MySQL manual, there is a reference to INSERT SELECT WHERE; but there is no VALUE. So maybe I assumed I could use VALUE in the syntax.

Thanks for the tip. I'll also try REPLACE.