MySQL Forums
Forum List  »  Microsoft Access

Changing the integer field
Posted by: Willy Henkens
Date: December 06, 2010 10:05AM

I just came to transfer an Access 2003 database into a MySQL database in phpMyAdmin.
The first field 'stnr' appeared in phpMyAdmin as a varchar type with a key.

I wish to change this as follows :
I added already a new field 'id' on the top of the table.
This new 'id'-field should become the new integer field, and the existing 'stnr'-field should change from key-field with type varchar into text-field without a key.
How can I manage this?

Additional question : Two date fields appeared as having primary keys. (Under the Action area.) Is that normal?

Options: ReplyQuote


Subject
Views
Written By
Posted
Changing the integer field
2784
December 06, 2010 10:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.