how to list table columns in mysql code example Example: show table columns mysql command line SHOW COLUMNS from tablename;