mercredi 27 avril 2016

SQLite weird duplicate database

I'm working with SQLite in php, and I was just attempting to add a new column to table, and I went into my table.db file to check if it added it, and I noticed that I have 2 Users tables.

This is really weird to me, because I'm not sure how I have 2 tables with the same name? It also appears to save all of the data twice (Once to either table), which I believe is why I have been having some stability issues.

in my db file I have „CtableUsersUsersCREATE TABLE Users( and „%tableUsersUsersCREATE TABLE Users(

So my question is: Is this normal behavior? I'm fairly new to SQLite. And if not, how can I safely remove the 2nd table without deleting the 1st table at the same time?

Aucun commentaire:

Enregistrer un commentaire