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