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