Forums

Can we choose to install 5.7 instead of current 5.6? My local environment is 5.7, then when I load the sql file from local to pythonanywhere, there is some weirld problems. Such as after adding one row, the id was set to 0, and then I can not add rows anymore. From this list on stackoverflow: https://stackoverflow.com/questions/48808999/mysql-autoincrement-not-working, I believe it is the version problem.

Forget it, I fixed the problem. It was caused by dump data to a postresql format sql file, and then import to mysql.

OK, glad you worked it out! We are planning to roll out MySQL 5.7 fairly soon, at least for new accounts. We'll be able to move old accounts over to it, though that will be an on-demand thing rather than an automatic upgrade.