Change type in a field

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Siryx
Forum Newbie
Posts: 11
Joined: Tue Jul 26, 2005 9:58 am

Change type in a field

Post by Siryx »

in a db I got a field called "download", is varchar(16), i want to "download" field be varchar(64).

How can i do that, without lose the information in the db?
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post by John Cartwright »

User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

mysqlautobackup
Forum Newbie
Posts: 3
Joined: Fri Oct 07, 2005 4:47 am

Post by mysqlautobackup »

ALTER TABLE table_name CHANGE download download VARCHAR(64);
Post Reply