hi,
mysql> update table1 set c = (select c2 from table2 where c2 = 'value') where id = 123; give me an ERROR 1064. i.e. create table t1 ( id int primary key, name varchar(20) ); create table t2 ( id int primary key, name varchar(20) ); insert into t1 values(1, 'not right') insert into t2 values(1, 'right') update t1 set name = (select name from t2 where id = 1) where id = 1; how i can update right? tnx. -- >here are more things in heaven and earth, horatio, than are dreamt of in your philosophy. ------------------------------------------------------- -- >here are more things in heaven and earth, horatio, than are dreamt of in your philosophy. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
