CODEWITHSUNDEEP
mysql
Gion Rubitschung
Gion Rubitschung

Reputation: 822

What is the Problem with this sql Update?

When I want to execute this sql update statement, I get a syntax error, but I don't see any syntax mistakes that I made.

UPDATE database1 
SET database1.Name = 'Hans', database1.Grund = 'Defekt', database1.Gerätename = 'Beamer', database1.Ausleihdatum = '15/3/2019', database1.Rückgabedatum = '29/3/2019', database1.Gerät_ID = database_geräte.ID 
FROM database1 
    INNER JOIN database_geräte ON database1.ID = database_geräte.ID 
WHERE database1.Name = 'Peter' AND database1.Grund = 'Altes Gerät defekt' AND database1.Gerätename = 'Beamer' AND database1.Ausleihdatum = '21/3/2019' AND database1.Rückgabedatum = '10/4/2019'

The update statement should work, but I don't know why...

Upvotes: 0

Views: 33

Answers (1)

Tim Biegeleisen
Tim Biegeleisen

Reputation: 521914

The problem is that you are using SQL Server syntax for a MySQL update query. In MySQL, the join comes first, followed afterward by SET:

UPDATE database1 t1
INNER JOIN database_geräte t2
    ON t1.ID = t2.ID
SET
    t1.Name = 'Hans',
    t1.Grund = 'Defekt',
    t1.Gerätename = 'Beamer',
    t1.Ausleihdatum = '15/3/2019',
    t1.Rückgabedatum = '29/3/2019',
    t1.Gerät_ID = t2.ID;

Upvotes: 3

Related Questions