Select to show all tables that have fields with specific data type

Question

Select to show all tables that have fields with specific data type

Asked 8 years, 4 months ago

Viewed 897 times

4

I have a database that I need to change all the columns that are in FLOAT AND DOUBLE to DECIMAL, are about 150 tables and I spend a lot of time looking one by one, there is some command that shows me this?

MY SQL Database, use Workbench 6.3

Thank you.

Existed, you will need to do a search for your tables in the database with the name of the tables you will have to take a course to go through all the tables one by one and check if there is the column you want. Look at that answer

– Marco Souza

2016/07/21 at 14:33
Thank you, I managed to do it in a simple way.

– Mauricio Ferraz

2016/07/21 at 14:36

1 answer

Browser other questions tagged mysql

You are not signed in. Login or sign up in order to post.

by Mauricio Ferraz • **2,074** points · Answer 1 · 2016-07-21T14:35:47+00:00

Great, I found what I needed :D

Follows the code:

SELECT 
    *
FROM
    information_schema.COLUMNS
WHERE
    1 = 1
        AND TABLE_SCHEMA = 'nome_do_meu_banco_de_dados'
        AND (DATA_TYPE = 'FLOAT'
        OR DATA_TYPE = 'DOUBLE')

I found this link: http://rubsphp.blogspot.com.br/2011/04/tabelas-e-colunas-no-mysql.html

Thank you.