1
This is my command:
UPDATE address SET lat = :latitude, lng = :longitude WHERE menu_id = :menu
Only that menu_id is not from the same table.
How can I do?
0No answers
Browser other questions tagged database postgresql
You are not signed in. Login or sign up in order to post.
your database is mysql?
– Marco Souza
In which database? the syntax can vary from one to another.
– rray
No, my database is the postgres
– Ana Carolina Ribeiro
How to update with a Join?
– rray
The data I have in common between the menu table and the address table is the address_id field
– Ana Carolina Ribeiro