Hi All,

What's wrong with the following SQL:

INSERT INTO user_info ( ID, Title, Notes ) VALUES ( SELECT ID, Title, Notes FROM user WHERE ID = 129)

Error:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT ID, Title, Notes FROM user WHERE ID = 129)' at line 2

user and user_info have a one-to-one relationship (innodb/myisam) for full-text searchability.

TIA

INSERT INTO user_info ( ID, Title, Notes )
SELECT ID, Title, Notes
FROM user WHERE ID = 129;

The VALUES is not needed when using a SELECT

It worked!!

Thanks much!

Btw: next time simply read the manual
http://dev.mysql.com/doc/refman/5.0/en/insert.html