On Mon, Dec 01, 2003 at 01:56:20PM +0200, Lorin wrote: > Salut! > M-am blocat si io la o problema mai marunta: > > MySQL-server-4.0.14-0/MDK9.2 > --- > #!/bin/sh > id=arrakis > mysql -u root -p"xxx" -n -N -B -q -S /var/lib/mysql/mysql.sock accounting > <<QUERY_INPUT > SELECT srcaddr FROM flow WHERE srcaddr IN (SELECT ip FROM clients WHERE > id="$id"); > QUERY_INPUT
"Starting with version 4.1, MySQL supports all subquery forms and operations which the SQL standard requires, as well as a few features which are MySQL-specific. The main advantages of subqueries are:" "For MySQL versions prior to 4.1, most subqueries can be successfully rewritten using joins and and other methods. See section 6.4.2.11 Rewriting Subqueries for Earlier MySQL Versions." http://www.mysql.com/doc/en/Subqueries.html ToySQL++ -- Birzan George Violence is the last refuge of Cristian the incompetent -- Salvor Hardin --- Detalii despre listele noastre de mail: http://www.lug.ro/
