Re: delete from querry - Jason Terry - com.mysql.lists.mysql

5 messages in com.mysql.lists.mysqlRe: delete from querry

From	Sent On	Attachments
Chuck Barnett	10 Nov 2000 09:39
Chris Matthews	10 Nov 2000 09:48
Chuck Barnett	10 Nov 2000 10:00
Jason Terry	10 Nov 2000 10:02
Jason Terry	10 Nov 2000 10:15

Subject:	Re: delete from querry
From:	Jason Terry (jter...@cartmanager.net)
Date:	11/10/2000 10:15:57 AM
List:	com.mysql.lists.mysql

DELETE FROM TableName WHERE vendors != "b" or DELETE FROM TableName WHERE vendors NOT LIKE "b"

But I cant imagine how this would be practical, as it would possibly delete A
LOT of important information....

Ok... a=vendors....I want to remove all of my "vendors" that are not named "b" chuck

Not enough information to answer....

The only anwer I can give is that "a" will NEVER be equal to "b"

So, you can DELETE FROM TableName

Please be more specific

what would be the correct syntax for deleting all records in a table except where "a" = "b"?

Thanks

Chuck

--------------------------------------------------------------------- Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail mysq...@lists.mysql.com

To unsubscribe, send a message to: <mysql-unsubscribe-jter-lists=cart...@lists.mysql.com>

If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php

To unsubscribe, send a message to: <mysql-unsubscribe-jter-lists=cart...@lists.mysql.com>

If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php