[theforum] Launch deadline

John Handelaar john at userfrenzy.com
Tue Apr 5 07:16:46 CDT 2005


William Anderson wrote:
> Jeff Howden wrote:
> 
>>[snip]
>>
>>Are you saying the dump I gave you had the primary keys stored as strings?

Actually after export I have tables without primary keys set (probably
soemthing that Navicat did).  Not having access to SQL Server I don't
know what data type the numerics had before, to be honest.

> ALTER TABLE tablename MODIFY fieldname TYPE; ought to do it
> 
> i.e ALTER TABLE users MODIFY id INT(11) TYPE;

I'll give it a go.  That ought to get us most of the way there if it
works.  I can't try an update before tomorrow, though.

jh


More information about the theforum mailing list