Changing the integer field
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?
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.