From Wiki

Mysql: AlterTable

ALTER TABLE titles ADD UNIQUE title (title);

ALTER TABLE tablo_adi ADD yeni_sutun VARCHAR(99)

ALTER TABLE tablo_adi MODIFY yeni_sutun VARCHAR(22)

ALTER TABLE tablo_adi CHANGE yeni_sutun yepyeni_SUTUN INT

ALTER TABLE tablo_adi DROP yeni_sutun

ALTER TABLE tablo_adi RENAME yeni_tablo_adi

ALTER TABLE cities ADD FULLTEXT(city_name);
SELECT city_name FROM cities WHERE MATCH (city_name) AGAINST ('Palm Springs');
SELECT city_name FROM cities WHERE MATCH (city_name) AGAINST ('+Palm +Springs' IN BOOLEAN MODE);
SELECT city_name, MATCH (city_name) AGAINST ('+South +(>Kensington Kensington 

Retrieved from http://kozgun.net/wiki/pmwiki.php?n=Mysql.AlterTable
Page last modified on March 24, 2006, at 12:19 AM