faqts : Computers : Programming : Languages : Asp : ASP/VBScript : Database Backed Sites

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

8 of 11 people (73%) answered Yes
Recently 3 of 5 people (60%) answered Yes

Entry

Why do I always get error when try to delete a row in a table using SQL command "DELETE table1 WHERE x='aaa';"?

May 23rd, 2000 18:49
unknown unknown, Joe T,


You've forgotten the FROM clause:
DELETE
FROM table1
WHERE x="aaa";



© 1999-2004 Synop Pty Ltd