In message <[EMAIL PROTECTED]>, James Keeline <[EMAIL PROTECTED]> writes >I don't think you can set an arbitrary length of an INT field like you can with >VARCHAR (not you can't with TEXT either).
I have got a project where the previous 'person' put all sorts of values, quite often int(10), which works, but just seems very inefficient. Either the table must run more slowly or space is wasted, I can't see it being neither. I haven't tested int(10) to destruction, though, I have just changed it. There was no reason for it anyway. >>From your latest example, it seems that you are trying to renumber the value >>in >a field. As you have discovered, dropping and readding the column won't do >this. Nothing in your queries has actually placed a value in that column. I hate to disagree (he lied <G>) but adding an autoinc field will make that field automatically renumber itself. -- Pete Clark http://www.hotcosta.com http://www.spanishholidaybookings.com Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
