/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

0 vote124 views1 answer
How to find total working hour in sql
SQL
0 vote160 views1 answer
Sql select without column name
SQL
5 votes127 views1 answer
Oracle sysdate - 1 month
SQL
0 vote120 views1 answer
Sqlplus change user
SQL
4 votes119 views1 answer
Mysql not equal
SQL
0 vote123 views8 answers
Convert sql query to linq online
SQL
11 votes117 views3 answers
Change column name sql server management studio
SQL
0 vote136 views1 answer
How to change mysql port in xampp
SQL
25 votes128 views4 answers
Metadata
SQL
0 vote104 views1 answer
Mysql percentage of total
SQL

Share