how to get table field names in mysql code example

Example 1: how to alter table name in mysql

ALTER TABLE table_name
  RENAME TO new_table_name;

Example 2: mysql get column names from table

SELECT `COLUMN_NAME` 
FROM `INFORMATION_SCHEMA`.`COLUMNS` 
WHERE `TABLE_SCHEMA`='yourdatabasename' 
    AND `TABLE_NAME`='yourtablename';