mysql  Ver 14.14 Distrib 5.7.28, for Linux (x86_64) using  EditLine wrapper
root@another10:/home/jpmh# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 21
Server version: 5.7.28-0ubuntu0.18.04.4-log (Ubuntu)

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use co2018a
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> describe main
    -> ;
+-------------------------+--------------+------+-----+---------+----------------+
| Field                   | Type         | Null | Key | Default | Extra          |
+-------------------------+--------------+------+-----+---------+----------------+
| id                      | int(11)      | NO   | PRI | NULL    | auto_increment |
| VOTER_ID                | varchar(9)   | YES  |     | NULL    |                |
| COUNTY_CODE             | varchar(11)  | YES  |     | NULL    |                |
| COUNTY                  | varchar(11)  | YES  |     | NULL    |                |
| LAST_NAME               | varchar(28)  | YES  | MUL | NULL    |                |
| FIRST_NAME              | varchar(26)  | YES  | MUL | NULL    |                |
| MIDDLE_NAME             | varchar(30)  | YES  |     | NULL    |                |
| NAME_SUFFIX             | varchar(11)  | YES  |     | NULL    |                |
| VOTER_NAME              | varchar(55)  | YES  |     | NULL    |                |
| STATUS_CODE             | varchar(11)  | YES  |     | NULL    |                |
| PRECINCT_NAME           | varchar(13)  | YES  |     | NULL    |                |
| ADDRESS_LIBRARY_ID      | varchar(18)  | YES  |     | NULL    |                |
| HOUSE_NUM               | varchar(9)   | YES  |     | NULL    |                |
| HOUSE_SUFFIX            | varchar(12)  | YES  |     | NULL    |                |
| PRE_DIR                 | varchar(7)   | YES  |     | NULL    |                |
| STREET_NAME             | varchar(32)  | YES  |     | NULL    |                |
| STREET_TYPE             | varchar(11)  | YES  |     | NULL    |                |
| POST_DIR                | varchar(8)   | YES  |     | NULL    |                |
| UNIT_TYPE               | varchar(9)   | YES  |     | NULL    |                |
| UNIT_NUM                | varchar(10)  | YES  |     | NULL    |                |
| RESIDENTIAL_ADDRESS     | varchar(42)  | YES  |     | NULL    |                |
| RESIDENTIAL_CITY        | varchar(19)  | YES  |     | NULL    |                |
| RESIDENTIAL_STATE       | varchar(17)  | YES  |     | NULL    |                |
| RESIDENTIAL_ZIP_CODE    | varchar(20)  | YES  |     | NULL    |                |
| RESIDENTIAL_ZIP_PLUS    | varchar(20)  | YES  |     | NULL    |                |
| EFFECTIVE_DATE          | varchar(14)  | YES  |     | NULL    |                |
| REGISTRATION_DATE       | varchar(17)  | YES  |     | NULL    |                |
| STATUS                  | varchar(8)   | YES  |     | NULL    |                |
| STATUS_REASON           | varchar(20)  | YES  |     | NULL    |                |
| BIRTH_YEAR              | varchar(10)  | YES  |     | NULL    |                |
| GENDER                  | varchar(7)   | YES  |     | NULL    |                |
| PRECINCT                | varchar(10)  | YES  |     | NULL    |                |
| SPLIT                   | varchar(10)  | YES  |     | NULL    |                |
| VOTER_STATUS_ID         | varchar(15)  | YES  |     | NULL    |                |
| PARTY                   | varchar(5)   | YES  |     | NULL    |                |
| PARTY_AFFILIATION_DATE  | varchar(22)  | YES  |     | NULL    |                |
| PHONE_NUM               | varchar(25)  | YES  |     | NULL    |                |
| MAIL_ADDR1              | varchar(138) | YES  |     | NULL    |                |
| MAIL_ADDR2              | varchar(69)  | YES  |     | NULL    |                |
| MAIL_ADDR3              | varchar(52)  | YES  |     | NULL    |                |
| MAILING_CITY            | varchar(31)  | YES  |     | NULL    |                |
| MAILING_STATE           | varchar(13)  | YES  |     | NULL    |                |
| MAILING_ZIP_CODE        | varchar(16)  | YES  |     | NULL    |                |
| MAILING_ZIP_PLUS        | varchar(16)  | YES  |     | NULL    |                |
| MAILING_COUNTRY         | varchar(27)  | YES  |     | NULL    |                |
| SPL_ID                  | varchar(9)   | YES  |     | NULL    |                |
| PERMANENT_MAIL_IN_VOTER | varchar(23)  | YES  |     | NULL    |                |
| CONGRESSIONAL           | varchar(15)  | YES  |     | NULL    |                |
| STATE_SENATE            | varchar(15)  | YES  |     | NULL    |                |
| STATE_HOUSE             | varchar(14)  | YES  |     | NULL    |                |
| ID_REQUIRED             | varchar(11)  | YES  |     | NULL    |                |
+-------------------------+--------------+------+-----+---------+----------------+
51 rows in set (0.01 sec)

mysql> ALTER TABLE  main CHANGE FIRST_NAME FIRST;
ERROR 1064 (42000):
mysql> ^C