作者:雇Anitamia | 来源:互联网 | 2023-10-10 14:19
While copying my one database, it's gives "1136 Column count doesn't match value count at row 1" error about "REPLACE INTO
.
(db_name, table_name, column_name, comment) VALUES('kitti','ayar','ayar')" sql.
Sql query is wrong. It has appeared 4.5.4, before that update I could copy this database without issue.
I have latest phpmaydmin version 4.6.6 on Windows 10.
该提问来源于开源项目:phpmyadmin/phpmyadmin
I've found a temporary solution. I've deleted all rows in pma__column_info table related with my database with this query...
"DELETE FROM pma__column_info WHERE db_name='my_database'"
(Also I've controlled before deletion all rows; have no any pma db value, only have db_name, table_name, column_name values)