Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql show column data types

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

PREVIOUS NEXT
Code Example
Sql :: postgresql get difference in hours between two dates 
Sql :: stuff in sql server 
Sql :: Inserting data into different tables at once in oracle sql 
Sql :: set a value by excuting stored procedure 
Sql :: tablo silme SQL 
Sql :: triggers in mysql example 
Sql :: oracle datafile max size 32gb 
Sql :: sql alias 
Sql :: sql order by except one row 
Sql :: postgresql populate data random 
Sql :: postgresql inheritance 
Sql :: compound trigger oracle 
Sql :: sql asc 
Sql :: Find the names of sailors who have reserved a red boat, and list in the order of age 
Sql :: change column in mysql 
Sql :: mysql not 
Sql :: postgres advance auto increment 
Sql :: SQL Switch Databases 
Sql :: duplicate row mysql 
Sql :: sql server get week dates from week number 
Sql :: advantages of stored procedures sql 
Sql :: sql query to delete duplicate records 
Sql :: postgres backup of table 
Sql :: Deleting data from tables 
Sql :: oracle procedure teamplate 
Sql :: adding column 
Sql :: select first and last row mysql 
Sql :: Example SQL Test 
Sql :: sql limit results 
Sql :: mariadb errno 121 
ADD CONTENT
Topic
Content
Source link
Name
9+5 =