: update synopsis error
What version of MySQL are you using? Subqueries aren't available until
4.1.x.
saiph wrote:
>
> hi,
>
> mysql> update table1
> set c = (select c2 from table2 where c2 = 'value') where id = 123;
>
> give me an ERROR 1064.
>
>
>> What version of MySQL are you using?
i use:
mysql Ver 12.22 Distrib 4.0.18, for pc-linux-gnu (i386).
>> UPDATE t1, t2 SET t1.name=t2.name WHERE t1.id=1 AND t2.id=1;
it works :), tnx again.
--
>here are more things in heaven and earth,
horatio, than are dreamt of in your philosophy.
--
What version of MySQL are you using? Subqueries aren't available until
4.1.x.
saiph wrote:
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 pr
saiph <[EMAIL PROTECTED]> wrote:
>
> 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) );
>
>
