MySQL Forums
Forum List  »  MySQL Query Browser

Unable to resolve Syntax error; Code 106
Posted by: Ed Yost
Date: March 21, 2006 09:55PM

Hi all,

I have some experience with Microsoft SQL server and am just starting with MySQL. I am trying a simple Delete statement through Query Browser but am getting an error code 106. The statement is as follows:

Use DatabaseName Delete from Vendors where vend_id = 1006

When I try to run this it errors on me saying I have a syntax error. The kick is that I can run this through another GUI for MySQL without any problem. Any ideas on what I am doing wrong. I have tried many combinations including:

Use DatabaseName Delete from Vendors.vend_id where vend_id = 1006

Thanks for any help,

Ed

Options: ReplyQuote


Subject
Written By
Posted
Unable to resolve Syntax error; Code 106
March 21, 2006 09:55PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.