I was needed to upgrade mysql 5.5 to 5.6, to avoid some issues on importing sql files.
我需要将mysql 5.5升级到5.6,以避免导入sql文件时出现一些问题。
ERROR 1293 (HY000) at line 231: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
ERROR 1293(HY000)第231行:表定义不正确;在DEFAULT或ON UPDATE子句中只能有一个TIMESTAMP列和CURRENT_TIMESTAMP
How do you upgrade it?
你如何升级它?
1 个解决方案
#1
Just run the following commands:
只需运行以下命令:
apt-get -y remove mysql-server
apt-get -y autoremove
apt-get -y install software-properties-common
add-apt-repository -y ppa:ondrej/mysql-5.6
apt-get update
apt-get -y install mysql-server
#1
Just run the following commands:
只需运行以下命令:
apt-get -y remove mysql-server
apt-get -y autoremove
apt-get -y install software-properties-common
add-apt-repository -y ppa:ondrej/mysql-5.6
apt-get update
apt-get -y install mysql-server