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;
Messung V0.5 in Prozent C=62 H=100 G=83
¤ Dauer der Verarbeitung: 0.0 Sekunden
(vorverarbeitet am 2026-10-08)
¤
*© Formatika GbR, Deutschland