UPDATE syntax error

Expand Post »

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

Similar Threads

Syntax error in UPDATE statement. in VB.NET
Update syntax error in VB.NET
Syntax error on update database code in VB.NET
MySQL/PHP UPDATE Syntax error in MySQL
Invalid Syntax Error in Viruses, Spyware and other Nasties

mikeps

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Dec 2004

Permalink

Dec 9th, 2004

Re: UPDATE syntax error

Quote originally posted by mikeps ...

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?

starsunited

Reputation Points: 11

Solved Threads: 1

Light Poster

Offline

44 posts
since Dec 2004

Permalink

Dec 10th, 2004

Re: UPDATE syntax error

Quote originally posted by starsunited ...

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.

mikeps

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Dec 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: any experiences with embedded mysql?

Next Thread in MySQL Forum Timeline: Checking existance of table

DaniWeb Message

Cancel Changes

User Name
Password