Sql

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

SHOW COLUMNS FROM mydb.mytable;

PREVIOUS	NEXT

Code Example
Sql :: postgresql format date dd/mm/yyyy
Sql :: postgres drop column if exists
Sql :: alert table name mysql
Sql :: select item.* as json mysql
Sql :: mysql id reset
Sql :: t-sql find object by name
Sql :: set statistics on in ssms
Sql :: sql find column name like
Sql :: sql headers delphi
Sql :: tsql find foreign key references
Sql :: sql get user account
Sql :: mysql bidirectional composite primary key
Sql :: Disabling foreign key checks while performing Sqlalchemy Upgrade
Sql :: pentaho + pasar de excel a sql
Sql :: oracle list index on table
Sql :: psql human readable
Sql :: Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates.
Sql :: get rows affected mysql python
Sql :: get parameter value in mysql trigger
Sql :: create table with primary key auto increment in sql
Sql :: mysql smallint range
Sql :: oracle current date plus 1 month
Sql :: oracle list service names
Sql :: sql server drop table if exists
Sql :: get first 3 letters name in sql
Sql :: alter table sql
Sql :: mysql update set sum
Sql :: psql client write to bash variable
Sql :: postgres concat_ws
Sql :: phpmyadmin delete user