/SQL/Mysql see column types

Mysql see column types

Mysql show column data types

SELECT DATA_TYPE from INFORMATION_SCHEMA.COLUMNS where
table_schema = ’yourDatabaseName’ and table_name = ’yourTableName’.

1

Source: grepper.com

Similar codes

-2 votes122 views3 answers
How to fetch first 10 rows in sql
SQL
2 votes108 views1 answer
How to search table name in stored procedure in sql server
SQL
1 vote134 views2 answers
Mysql does sentance contain word
SQL
0 vote65 views2 answers
Jupyter notebook connect to database
SQL
2 votes126 views1 answer
Coalesce sql
SQL
50 votes203 views6 answers
Install mysql on ubuntu
SQL
1 vote93 views4 answers
Sql now
SQL
3 votes133 views2 answers
How to View column names of a table in SQL
SQL
11 votes118 views2 answers
Turn off safe mode mysql
SQL
0 vote175 views1 answer
How to find the most occuring in SQL
SQL

Share