change field to variable

[kitaeshi]

Hi all, how do u change sql field as variable.

which function should i use.

thxs

[acrabadabra]

With the following statement:

ALTER TABLE `yourtable` CHANGE `field` `field` yourtype

Or take a look at: http://dev.mysql.com/doc/mysql/en/alter-table.html

Personally I like to use phpMySQL, a webinterface written in PHP. You can download it at http://www.phpmyadmin.net/