Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MySql
 Duplicate tables in the database		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

tomasalsbro
Average Member

Sweden
818 Posts
Posted - 23 February 2015 :  11:32:30  Show Profile  Visit tomasalsbro's Homepage  Reply with Quote
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
!-Keep distance in traffic-!
www.whiplashinfo.se
Edited by - tomasalsbro on 24 February 2015 03:06:24

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 24 February 2015 :  05:55:41  Show Profile  Visit HuwR's Homepage  Reply with Quote
Can't help on this one I'm afraid, is one set of table empty ?
MVC .net dev/test site | MVC .net running on Raspberry Pi
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts
Posted - 24 February 2015 :  15:03:44  Show Profile  Reply with Quote
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.
======
Doug G
======
Computer history and help at www.dougscode.com
Go to Top of Page

tomasalsbro
Average Member

Sweden
818 Posts
Posted - 24 February 2015 :  17:14:52  Show Profile  Visit tomasalsbro's Homepage  Reply with Quote
quote:
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
!-Keep distance in traffic-!
www.whiplashinfo.se
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.1 seconds. Powered By: Snitz Forums 2000 Version 3.4.07