命令行

# connect to a mysql server
mysql -h<ip> -u<user> -p
 
# specify a database
mysql> use <database_name>
 
# 修改列(shortnm)的数据类型
mysql> ALTER TABLE equity_delta_price MODIFY COLUMN shortnm varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;

see: https://www.runoob.com/mysql/mysql-command-manual.html