SaMz Posted September 2, 2007 Share Posted September 2, 2007 is there anyway to change all the int 11 to bigint 20 with a command on php admin for example update database set int 11 to bigint blah blah........ Quote Link to comment Share on other sites More sharing options...
hamster01 Posted September 3, 2007 Share Posted September 3, 2007 Re: Sql Comand Try this, ALTER TABLE `column` `column` BIGINT(20) Quote Link to comment Share on other sites More sharing options...
SaMz Posted September 23, 2007 Author Share Posted September 23, 2007 Re: Sql Comand what does that do? change all the tables in the column to bigint 20? Quote Link to comment Share on other sites More sharing options...
Isomerizer Posted September 23, 2007 Share Posted September 23, 2007 Re: Sql Comand what does that do? change all the tables in the column to bigint 20? You replace column with the actual column... and it will change it to bigint20... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.