Wiki | Mysql / AlterTable

Mysql.AlterTable History

Hide minor edits - Show changes to markup

March 24, 2006, at 12:19 AM by 85.105.66.26

Changed lines 2-5 from:

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

to:

ALTER TABLE titles ADD UNIQUE title (title);

Deleted lines 6-8:

code[= ALTER TABLE tablo_adi MODIFY yeni_sutun VARCHAR(22)

Changed line 10 from:

ALTER TABLE tablo_adi CHANGE yeni_sutun yepyeni_SUTUN INT

to:

ALTER TABLE tablo_adi MODIFY yeni_sutun VARCHAR(22)

Changed line 14 from:

ALTER TABLE tablo_adi DROP yeni_sutun

to:

ALTER TABLE tablo_adi CHANGE yeni_sutun yepyeni_SUTUN INT

Added lines 18-21:

ALTER TABLE tablo_adi DROP yeni_sutun =]

(:code:)[=

Added lines 23-29:

(:code:)[= 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

Restore

March 24, 2006, at 12:17 AM by 85.105.66.26

Added lines 6-24:

(:code:) ALTER TABLE tablo_adi ADD yeni_sutun VARCHAR(99) [@(:code:)@][= ALTER TABLE tablo_adi MODIFY yeni_sutun VARCHAR(22)

(:code:) ALTER TABLE tablo_adi CHANGE yeni_sutun yepyeni_SUTUN INT

(:code:) ALTER TABLE tablo_adi DROP yeni_sutun

(:code:)[= ALTER TABLE tablo_adi RENAME yeni_tablo_adi

Restore

March 24, 2006, at 12:14 AM by 85.105.66.26

Added lines 1-6:

(:code:) 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

Restore