Execute the following command: mysql_ Upgrade - U root - P password
Since the versions of MySQL 5.5 and above, the column attribute of comment field in the proc table of MySQL database has been changed from char (64) to text type
The following data types need to be changed for versions of mysql5.5 and above:
ALTER TABLE `proc`
MODIFY COLUMN `comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL AFTER `sql_mode`;Similar Posts:
- [Solved] SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘vod_content’.
- When mysql creates a table, set timestamp DEFAULT NULL error 1067-Invalid default value for’updated_at’
- ERROR: Functions in index expression must be marked IMMUTABLE
- Mysqldump common error reports and Solutions
- [Solved] MySQL uses the workbench tool, and the table status is read only
- used in key specification without a key length
- Incorrect key file for table [How to Solve]
- [Solved] mapper.xml Error: java.lang.AbstractMethodError: Method oracle/jdbc/driver/OracleResultSetImpl.getNString(Ljava/lang/String;)Ljava/lang/String; is abstract,
- MYSQL ERROR 1005 (HY000): Can’t create table [How to Solve]
- mysqldump unknown table ‘column_statistics’