Adv. Systems Design pressed the little lettered thingies in this order...
> hello *:
> I have initially set a field named title to be
> varchar(50)...I am finding that it is not long
> enough...can I change the size without adversely
> affecting existing data?
ALTER TABLE table_name CHANGE field_name field_name
For a table called "tbl" and a field called "fld" use:
ALTER TABLE tbl CHANGE fld fld VARCHAR(100)
Increasing the length of the field has no adverse affect.
a.k.a. [EMAIL PROTECTED]
Meeting cutting edge dynamic
web site needs
For a good time,
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]