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 :: mysql reset auto increment
Sql :: sql select roundup column
Sql :: set permanent SET GLOBAL sql_mode ubuntu
Sql :: age postgres
Sql :: Aqua Data studio postgresql ssl
Sql :: python how to connect to sql server
Sql :: mysql full outer join java
Sql :: hw to delete a procedure in pl sql
Sql :: display users in mysql
Sql :: mysql user permission database
Sql :: get rows affected mysql python
Sql :: mssql get running queries
Sql :: oracle current timestamp insert statement
Sql :: search query in mysql
Sql :: oracle limit user tablespace
Sql :: postgresql if null then 0
Sql :: sql get number of days between two dates
Sql :: how to delete table sqlite
Sql :: delete all table oracle
Sql :: postgresql list columns
Sql :: oracle create program if not exists
Sql :: oracle list of long running queries
Sql :: hour and minute between two datatime sql
Sql :: postgresql restore from dump
Sql :: install mysql 8 linux
Sql :: use of now() in mysql
Sql :: how to reset table in sql server
Sql :: mysql config user password
Sql :: epoch time converter in snowflake
Sql :: psql connect