tag:blogger.com,1999:blog-6395361280120165112.post9041550174303407989..comments2023-05-11T17:58:36.074+02:00Comments on Treble Click: Reorder mysql table columnsESVhttp://www.blogger.com/profile/00378746204489625224noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-6395361280120165112.post-71368566695739267672012-11-22T20:55:20.299+01:002012-11-22T20:55:20.299+01:00Super usefull :)
Thanks!Super usefull :)<br />Thanks!KUMAtronhttps://www.blogger.com/profile/05351532309080437080noreply@blogger.comtag:blogger.com,1999:blog-6395361280120165112.post-2321019564376939432011-12-23T00:28:47.975+01:002011-12-23T00:28:47.975+01:00Thank you , that was Great help for meThank you , that was Great help for meomarhttps://www.blogger.com/profile/18124367479313968539noreply@blogger.comtag:blogger.com,1999:blog-6395361280120165112.post-74721833627463407182011-12-23T00:28:14.340+01:002011-12-23T00:28:14.340+01:00Thank you , this helped me very much .. Wish u nic...Thank you , this helped me very much .. Wish u nice timesomarhttps://www.blogger.com/profile/18124367479313968539noreply@blogger.comtag:blogger.com,1999:blog-6395361280120165112.post-15178934191903409282011-06-25T02:41:05.682+02:002011-06-25T02:41:05.682+02:00Thanks for the great tip!Thanks for the great tip!Kruncherhttps://www.blogger.com/profile/06477502020709472344noreply@blogger.comtag:blogger.com,1999:blog-6395361280120165112.post-24204224960123910212011-06-04T17:42:09.814+02:002011-06-04T17:42:09.814+02:00Hi, Solaiman.
This reorder command actually works...Hi, Solaiman.<br /><br />This reorder command actually works, and according to your query, the column "country" should be appearing now next to the "user_email" column (after that column, on its right side.)<br /><br />Also check that you specified the right data type and creation attributes of the modified column or the reorder could have no effect.<br /><br />Take into account that this will change the printed column order when browsing MySQL columns, but the actual, internal order of stored data remains unchanged.ESVhttps://www.blogger.com/profile/00378746204489625224noreply@blogger.comtag:blogger.com,1999:blog-6395361280120165112.post-22989405748975899422011-06-04T13:39:49.615+02:002011-06-04T13:39:49.615+02:00ALTER table `site_user`
MODIFY COLUMN `coun...ALTER table `site_user`<br /> MODIFY COLUMN `country` varchar(40)<br /> AFTER `user_email` <br /><br />I used your this comand , but nothing to happend, but mysql query showed no error ..... <br />Is this command realy work.. confusedsolaiman ibnahttps://www.blogger.com/profile/03446747891821983585noreply@blogger.comtag:blogger.com,1999:blog-6395361280120165112.post-53215447962598796602010-03-25T23:36:33.073+01:002010-03-25T23:36:33.073+01:00Right, Jouni: other column attributes (if any) sho...Right, Jouni: other column attributes (if any) should be specified in the modify clause, as they were used in the original definition.ESVhttps://www.blogger.com/profile/00378746204489625224noreply@blogger.com