0

I use MySQL to update my table

So i have two tables. They are seat and seat_status

Here are the structure of both:

seat
------------------------------
id_seat     number(3) AI, PK;
seat_num    varchar(3);

seat_status
-----------------------------------
id_seat_status    number(3) AI, PK;
id_seat           number(3) FK;
status            varchar(14);

And here is MySQL query to update the status column in seat_status table:

UPDATE seat_status SET ss.status = 'Reserved' from seat_status ss, seat s
WHERE s.seat_num = 'A1' AND s.id_seat = ss.id_seat

But that query didn't work...How am I supposed to do? Please help me..thank you :)

Aprilia
  • 53
  • 2
  • 13

0 Answers0