Home » RDBMS Server » Server Administration » cannot delete*from
cannot delete*from [message #372351] Sun, 04 February 2001 16:28 Go to next message
timmy
Messages: 10
Registered: February 2001
Junior Member
learning some basic sql....created a table...i can select, insert into the created table but when i go to delete something i keep getting an error that it is a invalid or missing table(can't find table) would have to do with privilege or locks or? thanks

Report message to a moderator

Re: cannot delete*from [message #372356 is a reply to message #372351] Mon, 05 February 2001 08:07 Go to previous message
Balazs VISSY
Messages: 17
Registered: January 2001
Junior Member
If you used the expression as in the subject, then it is the problem. You don't need the asterix (*). The right syntax:

delete from table_name
where ...

Report message to a moderator

Previous Topic: cannot delete*from
Next Topic: How to take spaces out on string
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 00:23:38 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.