I'm running 3.21.33b (yes, I know it's old), and I run the command:
alter table branch change codebase codebase char(32) not null default
"IPriori";
where column codebase has type varchar(32) - but the type does not change to
char(32).
There's no error message or other indication of what went wrong, and if I create
a little play table I can succesfully change the column type to char(32) from
varchar(32).
The table "branch" has just 180 rows in it.
I'd like to change the column types from varchar to char to speed up queries &
etc.
Can anybody shed any light on what I'm doing wrong?
Thanks,
Lezz Giles
--
Leslie Giles Software Release Manager Avici Systems Inc
[EMAIL PROTECTED] Phone: 978.964.2030 Fax: 978.964.2100
"Do not fear the merge"
---------------------------------------------------------------------
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
