%BROADCASTMESSAGE%

	TWiki > Catch0405 > KaisersrotPersistenz > SoftwareVersions > ImplementierungInKaisersrot > DbConfigurations	TWiki webs: Admin| Aizo | Archinf | BIP | Bgyalex | Brandhub | Catch0405 | Cityscan05 | CommunityMedia | Control | Curtain | Easa005 | Easydb | Education | Extern | Extern0405 | Freudenhaus | Fund | Game0405 | Game05 | Gamearch | Luise | MAS0506 | MAS0506stu | Mas0506 | Mas0506stu | Maschinen0405 | Menz | Mill | Mill0405 | NDS | NDS0405 | NDS0405stu | Plugins | Qwipp | RZM | Replay | Replay0405 | Research | Second | Trash | Udintern | Urbandesign |
	Catch0405 . { Changes | Index | Search | Go }

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