='.$order.' AND o.orders_id=f.pedido);
Thanks all,
Tomás
-Mensaje original-
De: Felix Geerinckx [mailto:[EMAIL PROTECTED]
Enviado el: jueves, 11 de enero de 2007 19:25
Para: mysql@lists.mysql.com
Asunto: Re: Need any that can translate this
[EMAIL PROTECTED] (Tomás Abad Fernández) wrote
I dont know why thease don't work at MySql 3.21 , anyone can help me to make
this compatible with mysql3?
$query = SELECT * FROM facturas WHERE pedido IN (SELECT orders_id FROM
orders WHERE user_id='.$user.') ORDER BY factura_id;
Thanks for all.
Ysgrifennodd Tomás Abad Fernández:
I dont know why thease don't work at MySql 3.21 , anyone can help me to make
this compatible with mysql3?
$query = SELECT * FROM facturas WHERE pedido IN (SELECT orders_id FROM
orders WHERE user_id='.$user.') ORDER BY factura_id;
Thanks for all.
If I
[EMAIL PROTECTED] (Tomás Abad Fernández) wrote in
news:[EMAIL PROTECTED]:
I dont know why thease don't work at MySql 3.21 , anyone can help me
to make this compatible with mysql3?
3.21 is really ancient ...
$query = SELECT * FROM facturas WHERE pedido IN (SELECT orders_id
FROM orders
Not necessarily to use temp tables,they are expensicve.
Temp tables introduce extra disk IOs which slows down compare to using
explicit JOINs which is done in memory.
Here is techniques on how to rewrite a subquery with JOINs:
http://dev.mysql.com/doc/refman/4.1/en/rewriting-subqueries.html
Temporary tables are stored in memory so they are as quick as joins.
Dusan
Ran napsal(a):
Not necessarily to use temp tables,they are expensicve.
Temp tables introduce extra disk IOs which slows down compare to using
explicit JOINs which is done in memory.
Here is techniques on how to rewrite
Hi,
I never use MySQL, but force to learn about it. So far
I found that MySQL can use BerkeleyDB as underlying
DB. My question is how to translate existing Berkeley
DB (which was created by other tools) into MySQL DB.
Our application has been used Berkeley DB and now we
need to move on to MySQL
Does anyone know of a Perl function or package that can take a
user-inputted string (like from a search form on web page) and turn it into
proper SQL.
Something that might be able to deal with quoting, parenthesis and use of
AND and OR. Perhaps also + and - syntax.
For example, if a user
I need translate this SQL to any SQL that work in MYSQL
SELECT * FROM cons WHERE NOT EXISTS (SELECT idc FROM cp where
cons.id=cp.idc and cp.idp = 1);
-
Before posting, please check:
http://www.mysql.com/manual.php
