Monday, March 23, 2015

Lesson 52: sort table names in mysql

SELECT COLUMN_NAME
  FROM INFORMATION_SCHEMA.COLUMNS
 WHERE table_name = <tablename> ORDER BY column_name ASC

No comments:

Post a Comment