1drop table if exists test; 2CREATE TABLE test ( 3gnr INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, 4url VARCHAR(80) DEFAULT '' NOT NULL, 5shortdesc VARCHAR(200) DEFAULT '' NOT NULL, 6longdesc text DEFAULT '' NOT NULL, 7description VARCHAR(80) DEFAULT '' NOT NULL, 8name VARCHAR(80) DEFAULT '' NOT NULL, 9FULLTEXT(url,description,shortdesc,longdesc), 10PRIMARY KEY(gnr) 11) ENGINE = InnoDB; 12insert into test (url,shortdesc,longdesc,description,name) VALUES 13("http:/test.at", "kurz", "lang","desc", "name"); 14insert into test (url,shortdesc,longdesc,description,name) VALUES 15("http:/test.at", "kurz", "","desc", "name"); 16update test set url='test', description='ddd', name='nam' where gnr=2; 17update test set url='test', shortdesc='ggg', longdesc='mmm', 18description='ddd', name='nam' where gnr=2; 19check table test; 20Table Op Msg_type Msg_text 21test.test check status OK 22drop table test; 23