On 13 Jun 2002, at 13:22, justin cunningham wrote:
> i found alter table properties drop bulletpoints; then, alter table
> properties add bulletpoints text not null after cities; in a book.
It's hard to tell for sure, but it seems that you may be using "row"
to mean what's generally called a "column" -- that is, a field in the
table. "Row" normally means a record -- a set of values, one for
each field/column.
If you want to set bulletpoints to the empty string for all the rows
in the table, just do
UPDATE properties SET bulletpoints = '';
With no WHERE clause, it will affect all the rows in the table. In
general, be very careful with UPDATE queries that have no WHERE.
[Filter fodder: SQL]
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
---------------------------------------------------------------------
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
