hey all,
using mysql ver 3.23.36
got stuck with something, here's a simplified example of it:
+---+---+
| a | b |
+---+---+
| 1 | 1 |
| 1 | 2 |
| 2 | 2 |
| 3 | 1 |
+---+---+
I would like to retrieve the set of all a where b !=2
so in the above example, only 3 would be returned...
but a simple
Hi Paco,
If I could make a suggestion... I think you'll be much happier using a
newer version of perl than 4. With perl 5 and up you get to use the
wonderful features of DBI (Perl's database interface module) and DBD
(database drivers such as the one for Mysql). Not without saying you'll
g
Basically mysql doesn't let you use data from one table in updating another
table. If you look at the update syntax at
http://www.mysql.com/doc/U/P/UPDATE.html you'll notice the lack of a very
much needed FROM option.
later,
mike
At 01:14 PM 9/18/2001 +0100, you wrote:
>Hi everyone.
>
>I'm t
