I am getting a syntax error report from an UPDATE using two tables in a MYSQL db. :cry: This must be my mistake but I can't see it and have changed around many times now. Any ideas to help me resolve this welcome.

Statement:
UPDATE hole,tee SET hole.hx=tee.tnx where hole.hid=tee.hid;

Error Report:
error in your SQL syntax near 'tee SET hole.hx=tee.tnx where hole.hid=tee.hid' at line 1

Server:
Server running version 4.3.8 of PHP on the Linux operating system

I am getting a syntax error report from an UPDATE using two tables in a MYSQL db. :cry: This must be my mistake but I can't see it and have changed around many times now. Any ideas to help me resolve this welcome.

Statement:
UPDATE hole,tee SET hole.hx=tee.tnx where hole.hid=tee.hid;

Error Report:
error in your SQL syntax near 'tee SET hole.hx=tee.tnx where hole.hid=tee.hid' at line 1

Server:
Server running version 4.3.8 of PHP on the Linux operating system

you want to update two tables at one go?

you want to update two tables at one go?

I have used two queries to get round it but I want to use one. It only updates one table but it uses another table in the condition. In the syntax I think it is called a multi-tabe update. I think you could extend the syntax to update fields in both tables but I just used the simple case to make the post so the problem was clear.

I tried the update on a local server and it worked so I am wondering if the error message is mis-leading?

Thanks for your post.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.