Servus Leute...Ich muss die Werte aus mehreren Tabellen löschen.
Mein Beispiel dazu:
Bekomme aber einen Fehler:
Mein Beispiel dazu:
Code:
delete from Hw left join Calibration, Hw left join HwIsConnectedWith, Hw left join Log, Hw left join RepairHistory where Hw.HwID = Calibration.CalibrationFrom, and Hw join HwIsConnectedWith on Hw.HwID = HwIsConnectedWith.HwID, and Hw join Log on Hw.HwID = Log.LogFrom, and Hw join RepairHistory on Hw.HwID = RepairHistory.RepairHistoryFrom and Hw.HwID = 2717;
Code:
FehlerSQL-Befehl: delete from Hw left join Calibration, Hw left join HwIsConnectedWith, Hw left join Log, Hw left join RepairHistory where Hw.HwID = Calibration.CalibrationFrom, and Hw join HwIsConnectedWith on Hw.HwID = HwIsConnectedWith.HwID, and Hw join Log on Hw.HwID = Log.LogFrom, and Hw join RepairHistory on Hw.HwID = RepairHistory.RepairHistoryFrom and Hw.HwID = 2717 MySQL meldet: #1064 - 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 'left join Calibration, Hw left join HwIsConnectedWith, Hw lef' at line 1
Kommentar