Search code examples
mysqlauto-increment

MySQL can't show table after altering auto_increment


I created two tables like this enter image description here

and I want to change the added data's id so I use

alter table member auto_increment=5;

after this, it couldn't show my member table. It shows

error 2013: lost connection to MySQL server during query.

I thought my table is too big to run, so I changed the limit and the DBMS time out, but it didn't work either. Can someone tell me what's the problem now?


Solution

  • I found the problem. Don't edit your MySQL database when you're connecting it with your Python Flask program. Edit means any CRUD actions.