Duplicate tables in the database

Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/70903?pagenum=1
04 November 2025, 21:12

Topic


tomasalsbro
Duplicate tables in the database
23 February 2015, 11:32


It's been more then four years since I transformed the original Access Databas into a mySQL database. Now entering the databas (phpMyAdmin) I see two identical tables in the same data base.

Each table comes in two editions - one lowercase and the other large letters in each table name. Table contents are identical. I've taken a screenshot showing the table structure in the database and put it into Dropbox. Please see the image via this link. WhiplashInfo Help Forum databas image Thanks / Tomas

 

Replies ...


HuwR
24 February 2015, 05:55


Can't help on this one I'm afraid, is one set of table empty ?
Doug G
24 February 2015, 15:03


I seem to recall that mysql has a setting that can force lower-case identifiers. Perhaps something got changed in the mysql server? Just guessing.
tomasalsbro
24 February 2015, 17:14


Originally posted by HuwR
Can't help on this one I'm afraid, is one set of table empty ?

No - both tables contain identical information. Se Screenshot showing duplicate tables
© 2000-2021 Snitz™ Communications