I have a column of type big int that I would like to convert to type int I used the sql alter command with IGNORE and all the values greater than 2147483647 where all set to 2147483647 now what I would like to happen is I would like to keep the last bit and have it flag the negative
for example Bigint int 2147483648 should become -2147483648 2147483649 should become -2147483647 Is there an easy way to do this if not does anyone know an update query that I could run to convert the numbers before I do the alter? Roger Karnouk --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php