[SOLUCIONADO] sintaxis DELETE

[alfa18]

Hola,
en un "tutorial" de Oracle sobre MySQL me he encontrado esta orden:

Código MySQL:

delete City,Country
from Country inner join City
on Country.Code=City.CountryCode
where City.name=............
 

la sxis de DELETE es DELETE FROM tab1....; ¿porke en esta orden se indican las tablas a brorar(delete City,Country......)?
Gracias:D

[Libras]

Oracle sobre mysql?? o sea como?? oracle y mysql son 2 cosas distintas...lo que funciona en un DBMS puede no funcionar en otro

[gnzsoloyo]

en un "tutorial" de Oracle sobre MySQL me he encontrado esta orden:

Asumo que llegaste a l manual de MySQL desde la página de Oracle... ¿Es asi?

Como te dice Libras, no son la misma cosa. Oracle compró MySQL cuando adquirió a Sun Microsystems, pero no son el mismo DBMS. No confundas los términos.

Por otro lado, el manual es bastante detallado al respecto. ¿Lo leíste atentamente?

[alfa18]

Me explico..........es doumentacion sobre MySQL(probe la orden en MySQL y funciona perfectamente, aunque no se porque)

[gnzsoloyo]

OK, pero ¿leíste o no leíste la documentación?

Multi-Table Deletes

You can specify multiple tables in a DELETE statement to delete rows from one or more tables depending on the condition in the WHERE clause. You cannot use ORDER BY or LIMIT in a multiple-table DELETE. The table_references clause lists the tables involved in the join, as described in Section 13.2.9.2, “JOIN Syntax”.

For the first multiple-table syntax, only matching rows from the tables listed before the FROM clause are deleted. For the second multiple-table syntax, only matching rows from the tables listed in the FROM clause (before the USING clause) are deleted. The effect is that you can delete rows from many tables at the same time and have additional tables that are used only for searching:

Código MySQL:

DELETE t1, t2 FROM t1 INNER JOIN t2 INNER JOIN t3
WHERE t1.id=t2.id AND t2.id=t3.id;
 

Or:

Código MySQL:

DELETE FROM t1, t2 USING t1 INNER JOIN t2 INNER JOIN t3
WHERE t1.id=t2.id AND t2.id=t3.id;
 

These statements use all three tables when searching for rows to delete, but delete matching rows only from tables t1 and t2.

The preceding examples use INNER JOIN, but multiple-table DELETE statements can use other types of join permitted in SELECT statements, such as LEFT JOIN. For example, to delete rows that exist in t1 that have no match in t2, use a LEFT JOIN:

Código MySQL:

DELETE t1 FROM t1 LEFT JOIN t2 ON t1.id=t2.id WHERE t2.id IS NULL;
The syntax permits .* after each tbl_name for compatibility with Access.
 

If you use a multiple-table DELETE statement involving InnoDB tables for which there are foreign key constraints, the MySQL optimizer might process tables in an order that differs from that of their parent/child relationship. In this case, the statement fails and rolls back. Instead, you should delete from a single table and rely on the ON DELETE capabilities that InnoDB provides to cause the other tables to be modified accordingly.

[alfa18]

Parece ser k no estuve muy atento ese dia en clase

GRacias @gnzsoloyo :D

[Libras]

hace falta leer un poco mas las documentaciones ;)