|
01-28-2005, 09:14 AM
|
#1 |
|
Junior Member
Join Date: Jan 2005
Posts: 2
|
Table with text and numeric primary keys
I'm recreating a database structure from an MSAccess database in MySQL that will be used for a web application written in JSP. I have a table that has multiple primary keys with some being text and some being integers. I can either create the text primary keys or the integer primary keys, but I'm having problems doing both. If I create the text primary keys, then try to alter the table to make the integer a primary key, I get the following error:
ERROR 1068 (42000): Multiple primary key defined Anybody know how I can resolve the issue? Thanks! |
|
|
|
01-28-2005, 10:55 AM
|
#2 |
|
Junior Member
Join Date: Jan 2005
Posts: 2
|
Re: Table with text and numeric primary keys
Nevermind! I was trying to recreate the database manually, which is quite the involved process. I found a program that converted the MS Access database over to a MySQL database. Thanks anyhow!
|
|
|
|
 |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| 1.8 MySQL Standards Compliance | Administrator | Documentation | 21 | 06-08-2004 03:18 AM |
