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
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.