Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

select from describe sql

SELECT COLUMN_NAME AS `Field`, COLUMN_TYPE AS `Type`, IS_NULLABLE AS `NULL`, 
       COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS `Extra`
FROM information_schema.COLUMNS  
WHERE TABLE_SCHEMA = 'schemaName' AND TABLE_NAME = 'table1';
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #select #describe #sql
ADD COMMENT
Topic
Name
2+9 =