1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
drop table if exists t1;
CREATE TABLE t1 (
`Vorgangsnr` int(10) unsigned NOT NULL AUTO_INCREMENT,
`Datum_Eingang` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Erfassungs-/Buchungsdatum',
`Warennummer` varchar(20) DEFAULT NULL,
`BenutzerID` int(10) unsigned DEFAULT NULL,
`Vermerke_Versand` varchar(1024) DEFAULT NULL,
`Zubeh�r` varchar(250) DEFAULT NULL,
`Datum_Annahme` varchar(12) DEFAULT NULL,
`K_Lieferscheinnummer` int(10) unsigned DEFAULT NULL,
`RMANr` int(10) unsigned DEFAULT '0',
`K_Bestelldaten` varchar(1024) DEFAULT NULL COMMENT 'Bestellnr, Datum, Auftraggeber',
PRIMARY KEY (`Vorgangsnr`),
KEY `Datum_Eingang` (`Datum_Eingang`)
) ENGINE=Aria AUTO_INCREMENT=250 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
alter table t1 disable keys;
lock tables t1 write;
INSERT INTO t1 (Datum_Eingang, BenutzerID, Zubeh�r, Datum_Annahme) VALUES ('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006');
INSERT INTO t1 (Datum_Eingang, BenutzerID, Zubeh�r, Datum_Annahme) VALUES ('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006'),('2006-06-21 00:00:00', 713, 'ohne Zubeh�r', '21.06.2006');
unlock tables;
select count(*) from t1;
count(*)
88
check table t1 extended;
Table Op Msg_type Msg_text
test.t1 check status OK
alter table t1 enable keys;
check table t1 extended;
Table Op Msg_type Msg_text
test.t1 check status OK
drop table t1;
|