Question about DELETE FROM
Posted by: InvaderCyn (---.ptld.qwest.net)
Date: July 09, 2009 10:32PM

I am working through the Head First SQL book and I ran into a problem. I can't delete a row with the DELETE FROM command.

My database has two entries in it: (shortened for simplicity)

name activities
Clarabelle yelling, dancing
Clarabelle dancing

I have been trying to remove the one that has the activities 'yelling, dancing'

DELETE FROM clown_info
WHERE activities = 'yelling'
AND name = 'Clarabelle';

and

DELETE FROM clown_info
WHERE activities = 'yelling%'
AND name = 'Clarabelle';

Both of these find no queries to modify. What am I doing wrong? Shouldn't I be able to delete a row based on parial information?

Please help!

Options: ReplyQuote


Sorry, only registered users may post in this forum.