Mega Code Archive
Categories
/
MySQL
/
Table Index
Check table column settings
mysql> mysql> SELECT COLUMN_NAME, DATA_TYPE, CHAR_LENGTH, NULLABLE -> FROM COLUMNS -> WHERE TABLE_NAME = 'EmployeeS' -> AND TABLE_CREATOR = 'TENNIS' -> ORDER BY COLUMN_NO; Empty set (0.00 sec) mysql>