TWiki . Catch0405 . DbConfigurations |
Database Configuration:
The search of a useful Windows Client to implement the MySql? Database aimed
Mysql Query Browser
A database 'kaisersrot' has been created.
A Table 'superMix' with the following strukture has been created:
PrimaryKey int(10) auto_increment Haustyp varchar(45) YES Anzahl varchar(45) Name varchar(45) Nname varchar(45) Breite varchar(45) Tiefe varchar(45) Fläche varchar(45) r varchar(45) g varchar(45) b varchar(45) strasse varchar(45) wasser varchar(45) gruen varchar(45) nix varchar(45)
The Inputdatafield 'superMix' originally in an exel format has been saved as a generic *.txt file with separating semicolons has been loaded with the following sql:
LOAD DATA INFILE 'superMix.txt' INTO TABLE kaisersrot.superMix FIELDS TERMINATED BY ';' LINES TERMINATED BY '\r\n';
-- OtherDenisRaschpichler - 28 Dec 2004
----- Revision r1.1 - 28 Dec 2004 - 13:26 - OtherDenisRaschpichler
|
This website has been archived and is no longer maintained.