[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