Mazanie dat z 2 tabuliek – MySQL – Fórum – Programujte.com

Zdravim potreboval by som poradit. Potrebujem zmazat data z dvoch tabuliek.
1. tabulka - structura
id tp_id equipment_settings_id value

2. tabulka - structura
id description value

stary dotaz ktory maze data z jednej tabulky potrebujem aby mazal aj z druhej tabulky a to riadok kde
2.tabulka.id = 1.tabulka.equipment_settings_id

Vopred diky za pomoc.

Oh zabudol som na staru dotaz tu je:
$result0 = mysql_query("DELETE FROM equipment_settings where description='$description' && value='$value' LIMIT 1");

Dospel som k niecomu takemuto ale hadze my to chibu syntaxu:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where equipment_settings.id = equipment_info.equipment_settings_id && descriptio' at line 1

$result0 = mysql_query("DELETE FROM equipment_settings, equipment_info
where equipment_settings.id = equipment_info.equipment_settings_id && description='$description' && value='$value' LIMIT 1");

No neviem ci to pojde mazat z dvoch v jednom SQL prikaze

Neviem aky typ databaze pouzivas, ale ak su tabulky spojene pomocou `foreign_key`
tak by sa pri zmazani riadku z primarnej tabulky mali zmazat riadky aj v inych tabulkach na ktore je tento riadok naviazany

http://www.1keydata.com/sql/sql-foreign-key.html

Foreign keye jsou asi to co hledas.

Efektu mazani dvou veci najdnou se da dosahnout i pomoci transakci.

strč pred to where ešte using...
DELETE FROM equipment_settings, equipment_info USING equipment_settings, equipment_info
where equipment_settings.id = equipment_info.equipment_settings_id && description='$description' && value='$value' LIMIT 1


http://dev.mysql.com/doc/refman/4.1/en/delete.html
hneď na začiatku - "Multiple-table syntax"

diky vsem za rady nakoniec som to vyriesil pomocou viacerych dotazov a funguje to ale urcite to skusim pretoze by som rad zefektivnil svoju pracu :)