There are various reasons I'd like to do this, so I don't want to
detail that here. I can easily do this within a SQL Server stored
procedure, by creating a list of all tables, and for each table, run a
search to list of all fields, then run a query on the current table in
the current field for a parameter. Then, I would move on to the next
one. However, I'm not sure how to do that in MySQL. Any helpful code
available out there? I'm not sure quote how to google this one, so I
keep coming up with junk.

Thanks.

J

javelin wrote:
> There are various reasons I'd like to do this, so I don't want to
> detail that here. I can easily do this within a SQL Server stored
> procedure, by creating a list of all tables, and for each table, run a
> search to list of all fields, then run a query on the current table in
> the current field for a parameter. Then, I would move on to the next
> one. However, I'm not sure how to do that in MySQL. Any helpful code
> available out there? I'm not sure quote how to google this one, so I
> keep coming up with junk.
>
> Thanks.
>
> J


look at the stored proc in sqlserver... and then:
http://dev.mysql.com/doc/refman/5.0/...on-schema.html

Michael Austin <maustin@firstdbasource.com> wrote:
> javelin wrote:
>> There are various reasons I'd like to do this, so I don't want to
>> detail that here. I can easily do this within a SQL Server stored
>> procedure, by creating a list of all tables, and for each table, run a
>> search to list of all fields, then run a query on the current table in
>> the current field for a parameter. Then, I would move on to the next
>> one. However, I'm not sure how to do that in MySQL. Any helpful code
>> available out there? I'm not sure quote how to google this one, so I
>> keep coming up with junk.

> look at the stored proc in sqlserver... and then:
> http://dev.mysql.com/doc/refman/5.0/...on-schema.html

Use mysqldump to generate a flat file, then grep for the desired data.

QED, HAND,
--
Charles Polisher

Michael Austin <maustin@firstdbasource.com> wrote:
> javelin wrote:
>> There are various reasons I'd like to do this, so I don't want to
>> detail that here. I can easily do this within a SQL Server stored
>> procedure, by creating a list of all tables, and for each table, run a
>> search to list of all fields, then run a query on the current table in
>> the current field for a parameter. Then, I would move on to the next
>> one. However, I'm not sure how to do that in MySQL. Any helpful code
>> available out there? I'm not sure quote how to google this one, so I
>> keep coming up with junk.

> look at the stored proc in sqlserver... and then:
> http://dev.mysql.com/doc/refman/5.0/...on-schema.html

Use mysqldump to generate a flat file, then grep for the desired data.

QED, HAND,
--
Charles Polisher

On 16 Jan, 02:10, javelin <google.1.jvm...@spamgourmet.com> wrote:
> There are various reasons I'd like to do this, so I don't want to
> detail that here. I can easily do this within a SQL Server stored
> procedure, by creating a list of all tables, and for each table, run a
> search to list of all fields, then run a query on the current table in
> the current field for a parameter. Then, I would move on to the next
> one. However, I'm not sure how to do that in MySQL. Any helpful code
> available out there? I'm not sure quote how to google this one, so I
> keep coming up with junk.
>
> Thanks.
>
> J

Sounds like you need to normalise your design

On 2009-01-16, javelin <google.1.jvmail@spamgourmet.com> wrote:
> There are various reasons I'd like to do this, so I don't want to
> detail that here. I can easily do this within a SQL Server stored
> procedure, by creating a list of all tables, and for each table, run a
> search to list of all fields, then run a query on the current table in
> the current field for a parameter. Then, I would move on to the next
> one. However, I'm not sure how to do that in MySQL. Any helpful code
> available out there? I'm not sure quote how to google this one, so I
> keep coming up with junk.
>
> Thanks.
>
> J
>
>
> ---
> avast! Antivirus: Inbound message clean.
> Virus Database (VPS): 090117-0, 01/17/2009
> Tested on: 1/18/2009 7:50:37 PM
> avast! - copyright (c) 1988-2009 ALWIL Software.
> http://www.avast.com

I'm not sure how efficient this would be but the COLUMNS table in
the INFORMATION_SCHEMA database will let you know the table name,
column and and data type of the column for each of the databases you
have.

Should give you all the information you need to do that type
of general string seach within a storeed procedure.

jmh