Responding to my own post. i found alter table properties drop bulletpoints; then, alter table properties add bulletpoints text not null after cities; in a book.
I don't know what the low priority etc is for on the mysql manual. Now I'm repopulating the data, this time first editing it in notepad before I copy it over into my insert into properties (bulletpoints) values ('paste from notepad'); Maybe there's a better way since the above seems cumbersome. Regards, justin -----Original Message----- From: justin cunningham [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 12:46 PM To: 'mysql' Subject: deleteing data from a row How do I delete data from a table? I tried the man pages for delete and replace but there not working. I have a table with 8 rows. The table is called properties. The row is called bulletpoints. i tried deleting and replacing the fuged data and sql says ok bla but when I select bulletopints from properties I see the same fuged data I'm trying to eliminate. Please help. justin --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php