Hi rob,
I have another question but still in this solution. How did you
delete data which different in 2 table?
Sommai
At 10:28 27/2/2002 +, Rob wrote:
>I've been having this problem as well, which results from mySQL not allowing
>you to select and insert from the same table at th
Hi Rob,
You're right for my problem. I'll hope this solution to be fixed
in MySQL someday. thanks anyway.
Sommai
At 10:28 27/2/2002 +, Rob wrote:
>I've been having this problem as well, which results from mySQL not allowing
>you to select and insert from the same table at the same
I've been having this problem as well, which results from mySQL not allowing
you to select and insert from the same table at the same time. This
restriction makes some sense even in your case- mySQL wants to insert each
row as it finds it in the select, but then that might change what results
the
I was successful to get result from select (this sub-select appear in MySQL
manual).
At 21:20 26/2/2002 -0600, Paul DuBois wrote:
>At 9:18 +0700 2/27/02, Sommai Fongnamthip wrote:
>>Hi,
>> MySQL has insert into function and sub select (mysql style) but
>> I could not conclude these func
At 9:18 +0700 2/27/02, Sommai Fongnamthip wrote:
>Hi,
> MySQL has insert into function and sub select (mysql style)
>but I could not conclude these function togethter.
>
> If I want to select not existing row in 2 table, I used:
>
> SELECT table1.* FROM table1 LEFT JOIN ta
Hi,
MySQL has insert into function and sub select (mysql style) but I
could not conclude these function togethter.
If I want to select not existing row in 2 table, I used:
SELECT table1.* FROM table1 LEFT JOIN table2 ON
table1.id=table2.id where table2.id is null
t
