At 9:21 -0500 3/12/03, Luc Foisy wrote:
Perhaps one day UNION will be added to UPDATE
You'd still have to name every column to be updated explicitly.
There is no update whatever column happens to contain this value
syntax.
At 11:01 -0800 3/11/03, Keith Roberts wrote:
I need to look in several
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 11:33 AM
To: Luc Foisy; MYSQL-List (E-mail)
Subject: RE: Is there any way to search a whole database for a value?
At 9:21 -0500 3/12/03, Luc Foisy wrote:
Perhaps one day UNION will
mysqldump dbname | grep 'text'
Keith Roberts wrote:
I need to look in several different tables/columns in a database for a
particular value. If I find it, I need to update it. Is there any way to
search/update every table/column in one query in a particular database?
--
Keith Roberts
IT
At 11:01 -0800 3/11/03, Keith Roberts wrote:
I need to look in several different tables/columns in a database for a
particular value. If I find it, I need to update it. Is there any way to
search/update every table/column in one query in a particular database?
No.
--
Keith Roberts
IT Manager -
A request such as this make me think the database is not properly normalized.
If there is one value that can be in several columns, it is very likely
those columns need to be broken into their own table, so that they can be
queried with a SELECT statement that has only one column in its WHERE