update a table using a subselect in a query?

[Riverman1111]

Hey,

Does anyone know the syntax to insert a row to a table using a sub-select on the same table using the primary key? I know how to do it in MS Sql Server, can't do in MySql.

Sql Server syntax is:

INSERT TABLE
SELECT FIELD1,
FIELD2
FROM TABLE A
WHERE TABLE_ID = @TABLE_ID

 

[vacunita]

The mysql online documentation is your friend:

http://dev.mysql.com/doc/refman/5.0/en/insert-select.html

INSERT INTO tablename (field1,field2,field3) SELECT field1,field2,field3 FROM tablename WHERE id=xxx

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[Riverman1111]

That syntax gives me the error message:

'column count doesn't match value count at row 1'

???

 

[DonQuichote]

Then read the error message. It says that the SELECT part of the query does not have the same amount of fields as the INSERT part. In other words: you forgot a column in either the SELECT or the INSERT part.

+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)