Show column names in alphabetical order

SELECT c.column_name
  FROM INFORMATION_SCHEMA.COLUMNS c
 WHERE c.table_name = 'tbl_name'
-- AND c.table_schema = 'db_name'    
ORDER BY c.column_name

Total page views:

Comments

Popular posts from this blog

Check Change Files in Git

Run termux script using macrodroid

Create rish shortcut on Home Screen