ComputerBase Menü
Aktuelles

Sqllite Datenbank in sql umwandeln

tiga05

tiga05

Lt. Commander
Registriert
Sep. 2008
Beiträge
1.050
Hey Leute,

langsam bin ich echt am verzweifeln. Ich habe einen Minecraftserver auf dem verschiedene Plugins laufen. Viele dieser Plugins benutzen eine Datenbank in Form von SQLLite 3 (Endung: .db). Ich wollte nun endlich mal auf MYSQL umsteigen und suche deswegen einen Converter, da das phpMyAdmin einen import dieses Formates nicht untersützt. Ich habe auch ein Programm gefunden welches das kann. Bloß leider kostet dieses Programm 80$, die mir ein Import von ein paar Daten nicht wert sind.

Es wird doch auf dieser Welt noch irgendeine kostenlose alternative geben, welche mir das konvertieren in ein .sql-Format ermöglicht! . Ich habe jetzt schon 5 Programme ausprobiert die das angeblich können. Aber jedesmal heißt es da, dass dieses Format nicht unterstützt wird!!! :grr::grr::grr:

Ich bin auf diese Seite gestoßen: http://www.sqlite.org/cvstrac/wiki/wiki?p=ConverterTools

Dort gibt es viele solcher Programme. Laut Beschreibung sollten einige Programme auch das können, was ich benötige. Aber wie bereits geschrieben: Bis jetzt geht keins so wirklich. Zugegeben, ich kenne mich auch nicht wirklich mit Datenbanken aus. Vielleicht mache ich ja auch prinzipiell was falsch.

Kennt jemand von euch ein Programm mit dem das geht?

MfG

tiga05
 
Zuletzt bearbeitet:
Hey

wie kompliziert ist denn deine Datenbank

SQLite kann niht genau das selbe wie MySQL
zB.: Verschlüsselungen um jetzt nur ein zu nennem sofernd as vorkommt

Ich würde einfach versuchen sofern das möglich ist SQLite DBs zB.: in ein Format zu exprotieren (sofern das geht kenne SQLite net) was sich in MYsql importieren lässt (über PHPadmin zB.: welches ich kenne :-)

Wäre xxx.txt. oder xxx.csv

So exportierst du die Datenbanken aus SQLLite und importierst diese im MYsql aber wie gesagt obacht das Lite sagt schond as MYSQL nicht alles schmeckt was du eventuell drin stehen hast

So ahste ebend daten und tabellenstruktur und musst nur noch eventuelle nacharbeit leisten
 
@snmhero

Scheinbar nicht sehr kompliziert. Sie besteht aus drei Tabellen und jeweilige Einträge. Verschlüsselt is da nichts. Und mit welche Programm?

@Silent1337

Ok, das habe ich. Die DB geht auch zu öffnen. Wo passe ich den Syntax an?
 
Ja iwe gesagt ich kenne SQLite ledier nicht ob es da eine möglichkeit gibt die tabellen zu exportieren.

Bin auch noch auf arbeit und kanns hia nicht testen/ fix installeiren

Mit myPhpadmin kanns du die vllt exportierte datei dann wieder einfügen
Kann aber auch gu sein das das FF Addon gut funzt probiere es erstmal damit
Ansonsten hab ichd as hier aber sind alles nur Denkanstöße habe damit selber noch nie was gemacht

http://www.heise.de/software/download/sqlite_database_browser/41685

Das 3. klingt nach dem was du amcehn möchtest
 
Also es scheint beides zu funktionieren. Ich habe eine .sql Datei darraus gemacht. Leider meckert er wegen dem Syntax beim importieren.

@snmhero

Ich habe es auch mal als .csv-Datei exportiert. Ich kann als Import-Format aber nur DocSQL oder SQL einstellen. Also geht das scheinbar nicht.
 
Ohh ok dann Sorry versuch wars wert

Also ich kann komischerweise mit "Xampp" (wo myphpadmin drin ist) .txt und .csv und noch 5-6 andere vormate importieren

Komisch... Aber najad as andere scheint ja zu gehen

Gutes gelingen
 
Mh... Habe ich es doch falsch exportiert? Wenn ich die Datei mit notepad++ öffne, zeigt er mir das an:

Code: 
DROP TABLE IF EXISTS "bankaccounts";
CREATE TABLE `bankaccounts` (`accountname` VARCHAR( 255 ) NOT NULL , `owners` LONGTEXT NOT NULL, `users` LONGTEXT NOT NULL, `password` VARCHAR( 255 ) NULL DEFAULT '', `amount` DOUBLE( 255,2 ) NOT NULL DEFAULT '0', `cleanname` LONGTEXT NOT NULL DEFAULT '');
INSERT INTO "bankaccounts" VALUES('tiga05','tiga06;tiga06','tiga06;tiga06','',0,'tiga05');
INSERT INTO "bankaccounts" VALUES('eXchange','eXchange178;eXchange178','eXchange178;eXchange178','',878.8665561256565,'exchange');
INSERT INTO "bankaccounts" VALUES('Darlfire','Darlfire','Darlfire','',2538.8416092387747,'darlfire');
INSERT INTO "bankaccounts" VALUES('spectar','Spectar;bla','Spectar;bla','',3115.160075532454,'spectar');
INSERT INTO "bankaccounts" VALUES('tiga06','tiga06;tiga06','tiga06;tiga06','',2876.477940060601,'tiga06');
INSERT INTO "bankaccounts" VALUES('mirko911','Mirko;1','Mirko;1','',1.068438529143898,'mirko911');
INSERT INTO "bankaccounts" VALUES('Eralod','Eralod','Eralod','',49.9951497904909,'eralod');
INSERT INTO "bankaccounts" VALUES('Steve1983','Steve1983','Steve1983','',151.87664128659253,'steve1983');
INSERT INTO "bankaccounts" VALUES('12345','Nameless;Nameless','Nameless;Nameless','F34C903E17CFEEA18E499D4627EEB3EC',221.29028284600943,'12345');
INSERT INTO "bankaccounts" VALUES('Auspex','Auspex','Auspex','',1564.6205054367308,'auspex');
INSERT INTO "bankaccounts" VALUES('Elgert','Elgert;Elgert','Elgert;Elgert','',1252.689964735882,'elgert');
INSERT INTO "bankaccounts" VALUES('farm','WeeD;WeeD','WeeD;WeeD','',2557.3063988679883,'farm');
INSERT INTO "bankaccounts" VALUES('Sleepwalker','Sleepwalker','Sleepwalker','',2121.4619726331234,'sleepwalker');
INSERT INTO "bankaccounts" VALUES('DaveTheBorrow','DaveTheBorrow;DaveTheBorrow','DaveTheBorrow;DaveTheBorrow','',63.40301438920471,'davetheborrow');
INSERT INTO "bankaccounts" VALUES('3xp','Mirko;scrappy;mirko911','Mirko;scrappy;mirko911','2F43B42FD833D1E77420A8DAE7419000',2445.4817948583222,'3xp');
INSERT INTO "bankaccounts" VALUES('dance17','Dance17','Dance17','',159.6184173581326,'dance17');
INSERT INTO "bankaccounts" VALUES('Henrik','Henrik','Henrik','',121.09414710974121,'henrik');
INSERT INTO "bankaccounts" VALUES('xentrics','Spectar','Spectar','',211.83111081169943,'xentrics');
INSERT INTO "bankaccounts" VALUES('chemosmartie','chemosmartie;chemosmartie','chemosmartie;chemosmartie','',531.0966687463408,'chemosmartie');
INSERT INTO "bankaccounts" VALUES('dance27','Dance17','Dance17','',0,'dance27');
DROP TABLE IF EXISTS "bankareas";
CREATE TABLE `bankareas` (`areaname` VARCHAR( 255 ) NOT NULL , `world` VARCHAR( 255 ) NOT NULL , `x1` INT( 255 ) NOT NULL , `y1` INT( 255 ) NOT NULL , `z1` INT( 255 ) NOT NULL , `x2` INT( 255 ) NOT NULL , `y2` INT( 255 ) NOT NULL , `z2` INT( 255 ) NOT NULL);
INSERT INTO "bankareas" VALUES('bank','world',8,68,1931,23,68,1921);
INSERT INTO "bankareas" VALUES('bank_schalter','world',10,68,1926,22,68,1929);
INSERT INTO "bankareas" VALUES('bank_automat','world',21,68,1924,19,68,1923);
INSERT INTO "bankareas" VALUES('bank_automat2','world',10,68,1923,12,68,1924);
DROP TABLE IF EXISTS "banktransactions";
CREATE TABLE `banktransactions` (`player` VARCHAR( 255 ) NOT NULL, `account` VARCHAR( 255 ) NULL, `type` INT( 255 ) NOT NULL, `amount` DOUBLE( 255,2 ) NULL, `time` INT( 255 ) NOT NULL);
INSERT INTO "banktransactions" VALUES('tiga06','tiga05',1,0,1308189440);
INSERT INTO "banktransactions" VALUES('eXchange178','eXchange',1,0,1308342656);
INSERT INTO "banktransactions" VALUES('eXchange178','eXchange',2,1,1308342656);
INSERT INTO "banktransactions" VALUES('eXchange178','eXchange',2,56,1308342784);
INSERT INTO "banktransactions" VALUES('Darlfire','Darlfire',1,0,1308345216);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',1,0,1308345344);
INSERT INTO "banktransactions" VALUES('Darlfire','Darlfire',2,60,1308345344);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',2,25,1308345344);
INSERT INTO "banktransactions" VALUES('tiga06','tiga06',1,0,1308350720);
INSERT INTO "banktransactions" VALUES('Darlfire','Darlfire',2,50,1308350720);
INSERT INTO "banktransactions" VALUES('tiga06','tiga06',2,40,1308350848);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',2,35,1308352640);
INSERT INTO "banktransactions" VALUES('Mirko','mirko911',1,0,1308356480);
INSERT INTO "banktransactions" VALUES('chemosmartie','chemo',1,0,1308356864);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',2,30,1308403072);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',2,30,1308405248);
INSERT INTO "banktransactions" VALUES('tiga06','tiga06',2,35,1308411648);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',2,20,1308413312);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',2,60,1308416896);
INSERT INTO "banktransactions" VALUES('Eralod','Eralod',1,0,1308418432);
INSERT INTO "banktransactions" VALUES('Eralod','Eralod',2,3,1308418432);
INSERT INTO "banktransactions" VALUES('Eralod','Eralod',2,27,1308418432);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',2,30,1308439680);
INSERT INTO "banktransactions" VALUES('tiga06','tiga06',2,39,1308441472);
INSERT INTO "banktransactions" VALUES('Eralod','Eralod',2,2.5,1308445312);
INSERT INTO "banktransactions" VALUES('Steve1983','Steve1983',1,0,1308460928);
INSERT INTO "banktransactions" VALUES('Steve1983','Steve1983',2,20,1308460928);
INSERT INTO "banktransactions" VALUES('Steve1983','Darlfire',3,50,1308461056);
INSERT INTO "banktransactions" VALUES('Steve1983','Darlfire',2,50,1308461056);
INSERT INTO "banktransactions" VALUES('Darlfire','Darlfire',3,140,1308461184);
INSERT INTO "banktransactions" VALUES('tiga06','tiga06',2,38,1308489856);
INSERT INTO "banktransactions" VALUES('Darlfire','Darlfire',2,200,1308519168);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',2,50,1308519296);
INSERT INTO "banktransactions" VALUES('tiga06','tiga06',2,10.3,1308519296);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',2,30,1308523392);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',2,30,1308600832);
INSERT INTO "banktransactions" VALUES('Nameless','12345',1,0,1308607232);
INSERT INTO "banktransactions" VALUES('Nameless','12345',2,45,1308607360);
INSERT INTO "banktransactions" VALUES('Nameless','12345',2,101,1308620160);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',2,90,1308690048);
INSERT INTO "banktransactions" VALUES('Nameless','12345',2,70,1308702464);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',2,65,1308741120);
INSERT INTO "banktransactions" VALUES('Nameless','12345',9,0,1308782976);
INSERT INTO "banktransactions" VALUES('Nameless','12345',3,56,1308782976);
INSERT INTO "banktransactions" VALUES('Nameless','12345',3,32,1308869248);
INSERT INTO "banktransactions" VALUES('Auspex','Auspex',1,0,1308915712);
INSERT INTO "banktransactions" VALUES('Auspex','Auspex',2,50,1308915712);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',2,70,1308949504);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',2,40,1308955904);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',2,10,1308958208);
INSERT INTO "banktransactions" VALUES('Auspex','Auspex',2,60,1309005184);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',2,40,1309013888);
INSERT INTO "banktransactions" VALUES('tiga06','tiga06',2,156,1309014912);
INSERT INTO "banktransactions" VALUES('Eralod','Eralod',2,79.63,1309019776);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',2,90,1309025920);
INSERT INTO "banktransactions" VALUES('Auspex','Auspex',2,70,1309032064);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',2,45,1309103360);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',2,75,1309111424);
INSERT INTO "banktransactions" VALUES('Auspex','Auspex',2,50,1309166848);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',3,10,1309353600);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',3,20,1309353728);
INSERT INTO "banktransactions" VALUES('chemosmartie','chemo',2,100,1309363584);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',3,20,1309370624);
INSERT INTO "banktransactions" VALUES('Elgert','Elgert',1,0,1309381120);
INSERT INTO "banktransactions" VALUES('Elgert','Elgert',2,11,1309381248);
INSERT INTO "banktransactions" VALUES('chemosmartie','chemo',2,20,1309434496);
INSERT INTO "banktransactions" VALUES('chemosmartie','chemo',3,120,1309434496);
INSERT INTO "banktransactions" VALUES('chemosmartie','chemo',2,125,1309434496);
INSERT INTO "banktransactions" VALUES('Auspex','Auspex',2,100,1309437696);
INSERT INTO "banktransactions" VALUES('Elgert','Elgert',2,43.41,1309447552);
INSERT INTO "banktransactions" VALUES('Mirko','mirko911',2,200,1309447680);
INSERT INTO "banktransactions" VALUES('Elgert','Elgert',2,75,1309458176);
INSERT INTO "banktransactions" VALUES('Mirko','mirko911',2,60,1309458816);
INSERT INTO "banktransactions" VALUES('WeeD','farm',1,0,1309463936);
INSERT INTO "banktransactions" VALUES('WeeD','farm',2,97,1309463936);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',3,40,1309464320);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',3,20,1309467392);
INSERT INTO "banktransactions" VALUES('Sleepwalker','Sleepwalker',1,0,1309470976);
INSERT INTO "banktransactions" VALUES('Sleepwalker','Sleepwalker',2,590.52,1309470976);
INSERT INTO "banktransactions" VALUES('WeeD','farm',2,7,1309472000);
INSERT INTO "banktransactions" VALUES('Elgert','Elgert',2,44,1309515520);
INSERT INTO "banktransactions" VALUES('Elgert','Elgert',3,0.15,1309515520);
INSERT INTO "banktransactions" VALUES('Nameless','12345',2,39,1309516288);
INSERT INTO "banktransactions" VALUES('WeeD','farm',2,20,1309530496);
INSERT INTO "banktransactions" VALUES('Elgert','Elgert',2,30,1309537664);
INSERT INTO "banktransactions" VALUES('WeeD','farm',3,120,1309549568);
INSERT INTO "banktransactions" VALUES('tiga06','tiga06',3,50,1309550592);
INSERT INTO "banktransactions" VALUES('Elgert','Elgert',3,100,1309550720);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',3,40,1309557120);
INSERT INTO "banktransactions" VALUES('Mirko','mirko911',2,64,1309564032);
INSERT INTO "banktransactions" VALUES('WeeD','farm',2,14,1309629056);
INSERT INTO "banktransactions" VALUES('Elgert','Elgert',2,70,1309637248);
INSERT INTO "banktransactions" VALUES('Elgert','Elgert',2,26.81,1309637376);
INSERT INTO "banktransactions" VALUES('Darlfire','Darlfire',2,150,1309637376);
INSERT INTO "banktransactions" VALUES('Mirko','mirko911',2,115,1309703680);
INSERT INTO "banktransactions" VALUES('Auspex','Auspex',2,95,1309704448);
INSERT INTO "banktransactions" VALUES('chemosmartie','chemo',2,17.35,1309712256);
INSERT INTO "banktransactions" VALUES('Mirko','mirko911',2,14,1309712768);
INSERT INTO "banktransactions" VALUES('Elgert','Elgert',2,118,1309713408);
INSERT INTO "banktransactions" VALUES('WeeD','farm',2,13,1309717504);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',3,60,1309737216);
INSERT INTO "banktransactions" VALUES('WeeD','farm',2,46,1309785856);
INSERT INTO "banktransactions" VALUES('Mirko','mirko911',2,47,1309807744);
INSERT INTO "banktransactions" VALUES('Elgert','Elgert',2,122.4,1309808384);
INSERT INTO "banktransactions" VALUES('Nameless','12345',3,150,1309855616);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',3,60,1309859328);
INSERT INTO "banktransactions" VALUES('WeeD','farm',2,22,1309877888);
INSERT INTO "banktransactions" VALUES('WeeD','farm',2,63,1309890688);
INSERT INTO "banktransactions" VALUES('WeeD','farm',2,21,1309898880);
INSERT INTO "banktransactions" VALUES('Elgert','Elgert',2,59.52,1309902976);
INSERT INTO "banktransactions" VALUES('WeeD','farm',2,14,1309912704);
INSERT INTO "banktransactions" VALUES('WeeD','farm',2,98,1309915904);
INSERT INTO "banktransactions" VALUES('WeeD','farm',2,237,1309916416);
INSERT INTO "banktransactions" VALUES('Elgert','Elgert',3,130,1309958400);
INSERT INTO "banktransactions" VALUES('WeeD','farm',2,154,1309958528);
INSERT INTO "banktransactions" VALUES('WeeD','farm',2,201,1309967232);
INSERT INTO "banktransactions" VALUES('WeeD','farm',2,71,1309975552);
INSERT INTO "banktransactions" VALUES('Mirko','mirko911',2,18,1309976448);
INSERT INTO "banktransactions" VALUES('chemosmartie','chemo',2,80,1309986432);
INSERT INTO "banktransactions" VALUES('eXchange178','eXchange',2,90,1309998976);
INSERT INTO "banktransactions" VALUES('WeeD','farm',2,40,1309999232);
INSERT INTO "banktransactions" VALUES('eXchange178','eXchange',3,30,1309999360);
INSERT INTO "banktransactions" VALUES('WeeD','farm',2,30,1309999488);
INSERT INTO "banktransactions" VALUES('eXchange178','eXchange',2,81.6,1310004096);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',3,120,1310031488);
INSERT INTO "banktransactions" VALUES('WeeD','farm',2,30,1310033536);
INSERT INTO "banktransactions" VALUES('WeeD','farm',2,19,1310046208);
INSERT INTO "banktransactions" VALUES('eXchange178','eXchange',2,33.53,1310068224);
INSERT INTO "banktransactions" VALUES('DaveTheBorrow','DaveTheBorrow',1,0,1310068224);
INSERT INTO "banktransactions" VALUES('Mirko','3xp',1,0,1310071680);
INSERT INTO "banktransactions" VALUES('Mirko','mirko911',3,792,1310071808);
INSERT INTO "banktransactions" VALUES('Mirko','3xp',2,792,1310071808);
INSERT INTO "banktransactions" VALUES('Mirko','3xp',9,0,1310071808);
INSERT INTO "banktransactions" VALUES('WeeD','farm',3,50,1310073728);
INSERT INTO "banktransactions" VALUES('Eralod','Eralod',2,35.97,1310073856);
INSERT INTO "banktransactions" VALUES('Sleepwalker','Sleepwalker',2,75.39,1310081792);
INSERT INTO "banktransactions" VALUES('Sleepwalker','Sleepwalker',3,350,1310081920);
INSERT INTO "banktransactions" VALUES('tiga06','tiga06',2,100,1310081920);
INSERT INTO "banktransactions" VALUES('Dance17','dance17',1,0,1310081920);
INSERT INTO "banktransactions" VALUES('Eralod','Eralod',3,402,1310130304);
INSERT INTO "banktransactions" VALUES('Henrik','Henrik',1,0,1310135680);
INSERT INTO "banktransactions" VALUES('Henrik','Henrik',2,72.79,1310135680);
INSERT INTO "banktransactions" VALUES('Eralod','Eralod',2,30,1310142592);
INSERT INTO "banktransactions" VALUES('tiga06','tiga06',2,266,1310142592);
INSERT INTO "banktransactions" VALUES('WeeD','farm',2,10,1310145152);
INSERT INTO "banktransactions" VALUES('Auspex','Auspex',2,41.4,1310145280);
INSERT INTO "banktransactions" VALUES('WeeD','farm',3,50,1310146560);
INSERT INTO "banktransactions" VALUES('Darlfire','Darlfire',2,200,1310157696);
INSERT INTO "banktransactions" VALUES('WeeD','farm',2,26,1310204544);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',3,90,1310210816);
INSERT INTO "banktransactions" VALUES('Mirko','3xp',2,11,1310213888);
INSERT INTO "banktransactions" VALUES('ScrappY','3xp',2,220,1310214016);
INSERT INTO "banktransactions" VALUES('DaveTheBorrow','DaveTheBorrow',2,10,1310235136);
INSERT INTO "banktransactions" VALUES('DaveTheBorrow','DaveTheBorrow',2,8,1310239744);
INSERT INTO "banktransactions" VALUES('WeeD','farm',2,320,1310305664);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',3,90,1310308480);
INSERT INTO "banktransactions" VALUES('Nameless','12345',3,100,1310315136);
INSERT INTO "banktransactions" VALUES('Elgert','Elgert',2,44.07,1310319104);
INSERT INTO "banktransactions" VALUES('Sleepwalker','Sleepwalker',2,41.95,1310322176);
INSERT INTO "banktransactions" VALUES('WeeD','farm',3,20,1310329984);
INSERT INTO "banktransactions" VALUES('chemosmartie','chemo',3,120,1310419200);
INSERT INTO "banktransactions" VALUES('WeeD','farm',2,25,1310578944);
INSERT INTO "banktransactions" VALUES('Elgert','Elgert',2,33,1310578944);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',3,100,1310648320);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',3,80,1310648704);
INSERT INTO "banktransactions" VALUES('Sleepwalker','Sleepwalker',2,28.75,1310868352);
INSERT INTO "banktransactions" VALUES('tiga06','tiga06',2,300,1310868352);
INSERT INTO "banktransactions" VALUES('Mirko','3xp',2,250,1310953216);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',3,150,1311036928);
INSERT INTO "banktransactions" VALUES('Sleepwalker','Sleepwalker',2,141,1311126656);
INSERT INTO "banktransactions" VALUES('Sleepwalker','Sleepwalker',2,3.7,1311126784);
INSERT INTO "banktransactions" VALUES('Nameless','12345',3,50,1311199872);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',3,100,1311199872);
INSERT INTO "banktransactions" VALUES('Mirko','3xp',2,204,1311271424);
INSERT INTO "banktransactions" VALUES('Spectar','spectar',3,165.71,1311282048);
INSERT INTO "banktransactions" VALUES('Spectar','xentrics',1,0,1311282176);
INSERT INTO "banktransactions" VALUES('Spectar','xentrics',2,170,1311282176);
INSERT INTO "banktransactions" VALUES('Darlfire','Darlfire',2,400,1311370880);
INSERT INTO "banktransactions" VALUES('Sleepwalker','Sleepwalker',2,145.1,1311414016);
INSERT INTO "banktransactions" VALUES('Elgert','Elgert',2,115.9,1311441664);
INSERT INTO "banktransactions" VALUES('DaveTheBorrow','DaveTheBorrow',2,20,1311512832);
INSERT INTO "banktransactions" VALUES('Mirko','3xp',2,75.75,1311512832);
INSERT INTO "banktransactions" VALUES('Sleepwalker','Sleepwalker',2,23.47,1311541888);
INSERT INTO "banktransactions" VALUES('Dance17','dance17',2,168.01,1311542016);
INSERT INTO "banktransactions" VALUES('Dance17','dance17',2,40.05,1311565056);
INSERT INTO "banktransactions" VALUES('chemosmartie','chemo',2,130,1311599360);
INSERT INTO "banktransactions" VALUES('tiga06','tiga06',3,10,1311599616);
INSERT INTO "banktransactions" VALUES('tiga06','chemo',9,0,1311599616);
INSERT INTO "banktransactions" VALUES('tiga06','chemo',3,476.9346808218279,1311599872);
INSERT INTO "banktransactions" VALUES('tiga06','chemo',6,0,1311599872);
INSERT INTO "banktransactions" VALUES('chemosmartie','chemosmartie',1,0,1311599872);
INSERT INTO "banktransactions" VALUES('chemosmartie','chemosmartie',2,460,1311600000);
INSERT INTO "banktransactions" VALUES('chemosmartie','chemosmartie',3,10,1311600000);
INSERT INTO "banktransactions" VALUES('chemosmartie','chemosmartie',2,10,1311600000);
INSERT INTO "banktransactions" VALUES('Dance17','dance17',2,160.95,1311706752);
INSERT INTO "banktransactions" VALUES('Elgert','Elgert',2,15,1311711616);
INSERT INTO "banktransactions" VALUES('DaveTheBorrow','DaveTheBorrow',3,20,1311875840);
INSERT INTO "banktransactions" VALUES('DaveTheBorrow','DaveTheBorrow',2,30,1311875968);
INSERT INTO "banktransactions" VALUES('Sleepwalker','Sleepwalker',2,356.33,1311885824);
INSERT INTO "banktransactions" VALUES('Nameless','12345',3,150,1311889280);
INSERT INTO "banktransactions" VALUES('Dance17','dance17',2,100,1311954944);
INSERT INTO "banktransactions" VALUES('Dance17','dance27',1,0,1311954944);
INSERT INTO "banktransactions" VALUES('Dance17','dance17',3,350,1311955200);

commit, begin transaction etc. gibt es hier garnicht.
 
Zuletzt bearbeitet:
Muss es ja auch nicht umbedingt. :)

" = durch ` ersetzen.
So sollte es sein:

Code: 
DROP TABLE IF EXISTS `bankaccounts`;
CREATE TABLE `bankaccounts` (`accountname` VARCHAR( 255 ) NOT NULL , `owners` LONGTEXT NOT NULL, `users` LONGTEXT NOT NULL, `password` VARCHAR( 255 ) NULL DEFAULT '', `amount` DOUBLE( 255,2 ) NOT NULL DEFAULT '0', `cleanname` LONGTEXT NOT NULL DEFAULT '');
INSERT INTO `bankaccounts` VALUES('tiga05','tiga06;tiga06','tiga06;tiga06','',0,'tiga05');
INSERT INTO `bankaccounts` VALUES('eXchange','eXchange178;eXchange178','eXchange178;eXchange178','',878.8665561256565,'exchange');
INSERT INTO `bankaccounts` VALUES('Darlfire','Darlfire','Darlfire','',2538.8416092387747,'darlfire');
INSERT INTO `bankaccounts` VALUES('spectar','Spectar;bla','Spectar;bla','',3115.160075532454,'spectar');
INSERT INTO `bankaccounts` VALUES('tiga06','tiga06;tiga06','tiga06;tiga06','',2876.477940060601,'tiga06');
INSERT INTO `bankaccounts` VALUES('mirko911','Mirko;1','Mirko;1','',1.068438529143898,'mirko911');
INSERT INTO `bankaccounts` VALUES('Eralod','Eralod','Eralod','',49.9951497904909,'eralod');
INSERT INTO `bankaccounts` VALUES('Steve1983','Steve1983','Steve1983','',151.87664128659253,'steve1983');
INSERT INTO `bankaccounts` VALUES('12345','Nameless;Nameless','Nameless;Nameless','F34C903E17CFEEA18E499D4627EEB3EC',221.29028284600943,'12345');
INSERT INTO `bankaccounts` VALUES('Auspex','Auspex','Auspex','',1564.6205054367308,'auspex');
INSERT INTO `bankaccounts` VALUES('Elgert','Elgert;Elgert','Elgert;Elgert','',1252.689964735882,'elgert');
INSERT INTO `bankaccounts` VALUES('farm','WeeD;WeeD','WeeD;WeeD','',2557.3063988679883,'farm');
INSERT INTO `bankaccounts` VALUES('Sleepwalker','Sleepwalker','Sleepwalker','',2121.4619726331234,'sleepwalker');
INSERT INTO `bankaccounts` VALUES('DaveTheBorrow','DaveTheBorrow;DaveTheBorrow','DaveTheBorrow;DaveTheBorrow','',63.40301438920471,'davetheborrow');
INSERT INTO `bankaccounts` VALUES('3xp','Mirko;scrappy;mirko911','Mirko;scrappy;mirko911','2F43B42FD833D1E77420A8DAE7419000',2445.4817948583222,'3xp');
INSERT INTO `bankaccounts` VALUES('dance17','Dance17','Dance17','',159.6184173581326,'dance17');
INSERT INTO `bankaccounts` VALUES('Henrik','Henrik','Henrik','',121.09414710974121,'henrik');
INSERT INTO `bankaccounts` VALUES('xentrics','Spectar','Spectar','',211.83111081169943,'xentrics');
INSERT INTO `bankaccounts` VALUES('chemosmartie','chemosmartie;chemosmartie','chemosmartie;chemosmartie','',531.0966687463408,'chemosmartie');
INSERT INTO `bankaccounts` VALUES('dance27','Dance17','Dance17','',0,'dance27');
DROP TABLE IF EXISTS `bankareas`;
CREATE TABLE `bankareas` (`areaname` VARCHAR( 255 ) NOT NULL , `world` VARCHAR( 255 ) NOT NULL , `x1` INT( 255 ) NOT NULL , `y1` INT( 255 ) NOT NULL , `z1` INT( 255 ) NOT NULL , `x2` INT( 255 ) NOT NULL , `y2` INT( 255 ) NOT NULL , `z2` INT( 255 ) NOT NULL);
INSERT INTO `bankareas` VALUES('bank','world',8,68,1931,23,68,1921);
INSERT INTO `bankareas` VALUES('bank_schalter','world',10,68,1926,22,68,1929);
INSERT INTO `bankareas` VALUES('bank_automat','world',21,68,1924,19,68,1923);
INSERT INTO `bankareas` VALUES('bank_automat2','world',10,68,1923,12,68,1924);
DROP TABLE IF EXISTS `banktransactions`;
CREATE TABLE `banktransactions` (`player` VARCHAR( 255 ) NOT NULL, `account` VARCHAR( 255 ) NULL, `type` INT( 255 ) NOT NULL, `amount` DOUBLE( 255,2 ) NULL, `time` INT( 255 ) NOT NULL);
INSERT INTO `banktransactions` VALUES('tiga06','tiga05',1,0,1308189440);
INSERT INTO `banktransactions` VALUES('eXchange178','eXchange',1,0,1308342656);
INSERT INTO `banktransactions` VALUES('eXchange178','eXchange',2,1,1308342656);
INSERT INTO `banktransactions` VALUES('eXchange178','eXchange',2,56,1308342784);
INSERT INTO `banktransactions` VALUES('Darlfire','Darlfire',1,0,1308345216);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',1,0,1308345344);
INSERT INTO `banktransactions` VALUES('Darlfire','Darlfire',2,60,1308345344);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',2,25,1308345344);
INSERT INTO `banktransactions` VALUES('tiga06','tiga06',1,0,1308350720);
INSERT INTO `banktransactions` VALUES('Darlfire','Darlfire',2,50,1308350720);
INSERT INTO `banktransactions` VALUES('tiga06','tiga06',2,40,1308350848);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',2,35,1308352640);
INSERT INTO `banktransactions` VALUES('Mirko','mirko911',1,0,1308356480);
INSERT INTO `banktransactions` VALUES('chemosmartie','chemo',1,0,1308356864);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',2,30,1308403072);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',2,30,1308405248);
INSERT INTO `banktransactions` VALUES('tiga06','tiga06',2,35,1308411648);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',2,20,1308413312);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',2,60,1308416896);
INSERT INTO `banktransactions` VALUES('Eralod','Eralod',1,0,1308418432);
INSERT INTO `banktransactions` VALUES('Eralod','Eralod',2,3,1308418432);
INSERT INTO `banktransactions` VALUES('Eralod','Eralod',2,27,1308418432);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',2,30,1308439680);
INSERT INTO `banktransactions` VALUES('tiga06','tiga06',2,39,1308441472);
INSERT INTO `banktransactions` VALUES('Eralod','Eralod',2,2.5,1308445312);
INSERT INTO `banktransactions` VALUES('Steve1983','Steve1983',1,0,1308460928);
INSERT INTO `banktransactions` VALUES('Steve1983','Steve1983',2,20,1308460928);
INSERT INTO `banktransactions` VALUES('Steve1983','Darlfire',3,50,1308461056);
INSERT INTO `banktransactions` VALUES('Steve1983','Darlfire',2,50,1308461056);
INSERT INTO `banktransactions` VALUES('Darlfire','Darlfire',3,140,1308461184);
INSERT INTO `banktransactions` VALUES('tiga06','tiga06',2,38,1308489856);
INSERT INTO `banktransactions` VALUES('Darlfire','Darlfire',2,200,1308519168);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',2,50,1308519296);
INSERT INTO `banktransactions` VALUES('tiga06','tiga06',2,10.3,1308519296);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',2,30,1308523392);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',2,30,1308600832);
INSERT INTO `banktransactions` VALUES('Nameless','12345',1,0,1308607232);
INSERT INTO `banktransactions` VALUES('Nameless','12345',2,45,1308607360);
INSERT INTO `banktransactions` VALUES('Nameless','12345',2,101,1308620160);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',2,90,1308690048);
INSERT INTO `banktransactions` VALUES('Nameless','12345',2,70,1308702464);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',2,65,1308741120);
INSERT INTO `banktransactions` VALUES('Nameless','12345',9,0,1308782976);
INSERT INTO `banktransactions` VALUES('Nameless','12345',3,56,1308782976);
INSERT INTO `banktransactions` VALUES('Nameless','12345',3,32,1308869248);
INSERT INTO `banktransactions` VALUES('Auspex','Auspex',1,0,1308915712);
INSERT INTO `banktransactions` VALUES('Auspex','Auspex',2,50,1308915712);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',2,70,1308949504);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',2,40,1308955904);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',2,10,1308958208);
INSERT INTO `banktransactions` VALUES('Auspex','Auspex',2,60,1309005184);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',2,40,1309013888);
INSERT INTO `banktransactions` VALUES('tiga06','tiga06',2,156,1309014912);
INSERT INTO `banktransactions` VALUES('Eralod','Eralod',2,79.63,1309019776);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',2,90,1309025920);
INSERT INTO `banktransactions` VALUES('Auspex','Auspex',2,70,1309032064);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',2,45,1309103360);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',2,75,1309111424);
INSERT INTO `banktransactions` VALUES('Auspex','Auspex',2,50,1309166848);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',3,10,1309353600);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',3,20,1309353728);
INSERT INTO `banktransactions` VALUES('chemosmartie','chemo',2,100,1309363584);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',3,20,1309370624);
INSERT INTO `banktransactions` VALUES('Elgert','Elgert',1,0,1309381120);
INSERT INTO `banktransactions` VALUES('Elgert','Elgert',2,11,1309381248);
INSERT INTO `banktransactions` VALUES('chemosmartie','chemo',2,20,1309434496);
INSERT INTO `banktransactions` VALUES('chemosmartie','chemo',3,120,1309434496);
INSERT INTO `banktransactions` VALUES('chemosmartie','chemo',2,125,1309434496);
INSERT INTO `banktransactions` VALUES('Auspex','Auspex',2,100,1309437696);
INSERT INTO `banktransactions` VALUES('Elgert','Elgert',2,43.41,1309447552);
INSERT INTO `banktransactions` VALUES('Mirko','mirko911',2,200,1309447680);
INSERT INTO `banktransactions` VALUES('Elgert','Elgert',2,75,1309458176);
INSERT INTO `banktransactions` VALUES('Mirko','mirko911',2,60,1309458816);
INSERT INTO `banktransactions` VALUES('WeeD','farm',1,0,1309463936);
INSERT INTO `banktransactions` VALUES('WeeD','farm',2,97,1309463936);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',3,40,1309464320);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',3,20,1309467392);
INSERT INTO `banktransactions` VALUES('Sleepwalker','Sleepwalker',1,0,1309470976);
INSERT INTO `banktransactions` VALUES('Sleepwalker','Sleepwalker',2,590.52,1309470976);
INSERT INTO `banktransactions` VALUES('WeeD','farm',2,7,1309472000);
INSERT INTO `banktransactions` VALUES('Elgert','Elgert',2,44,1309515520);
INSERT INTO `banktransactions` VALUES('Elgert','Elgert',3,0.15,1309515520);
INSERT INTO `banktransactions` VALUES('Nameless','12345',2,39,1309516288);
INSERT INTO `banktransactions` VALUES('WeeD','farm',2,20,1309530496);
INSERT INTO `banktransactions` VALUES('Elgert','Elgert',2,30,1309537664);
INSERT INTO `banktransactions` VALUES('WeeD','farm',3,120,1309549568);
INSERT INTO `banktransactions` VALUES('tiga06','tiga06',3,50,1309550592);
INSERT INTO `banktransactions` VALUES('Elgert','Elgert',3,100,1309550720);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',3,40,1309557120);
INSERT INTO `banktransactions` VALUES('Mirko','mirko911',2,64,1309564032);
INSERT INTO `banktransactions` VALUES('WeeD','farm',2,14,1309629056);
INSERT INTO `banktransactions` VALUES('Elgert','Elgert',2,70,1309637248);
INSERT INTO `banktransactions` VALUES('Elgert','Elgert',2,26.81,1309637376);
INSERT INTO `banktransactions` VALUES('Darlfire','Darlfire',2,150,1309637376);
INSERT INTO `banktransactions` VALUES('Mirko','mirko911',2,115,1309703680);
INSERT INTO `banktransactions` VALUES('Auspex','Auspex',2,95,1309704448);
INSERT INTO `banktransactions` VALUES('chemosmartie','chemo',2,17.35,1309712256);
INSERT INTO `banktransactions` VALUES('Mirko','mirko911',2,14,1309712768);
INSERT INTO `banktransactions` VALUES('Elgert','Elgert',2,118,1309713408);
INSERT INTO `banktransactions` VALUES('WeeD','farm',2,13,1309717504);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',3,60,1309737216);
INSERT INTO `banktransactions` VALUES('WeeD','farm',2,46,1309785856);
INSERT INTO `banktransactions` VALUES('Mirko','mirko911',2,47,1309807744);
INSERT INTO `banktransactions` VALUES('Elgert','Elgert',2,122.4,1309808384);
INSERT INTO `banktransactions` VALUES('Nameless','12345',3,150,1309855616);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',3,60,1309859328);
INSERT INTO `banktransactions` VALUES('WeeD','farm',2,22,1309877888);
INSERT INTO `banktransactions` VALUES('WeeD','farm',2,63,1309890688);
INSERT INTO `banktransactions` VALUES('WeeD','farm',2,21,1309898880);
INSERT INTO `banktransactions` VALUES('Elgert','Elgert',2,59.52,1309902976);
INSERT INTO `banktransactions` VALUES('WeeD','farm',2,14,1309912704);
INSERT INTO `banktransactions` VALUES('WeeD','farm',2,98,1309915904);
INSERT INTO `banktransactions` VALUES('WeeD','farm',2,237,1309916416);
INSERT INTO `banktransactions` VALUES('Elgert','Elgert',3,130,1309958400);
INSERT INTO `banktransactions` VALUES('WeeD','farm',2,154,1309958528);
INSERT INTO `banktransactions` VALUES('WeeD','farm',2,201,1309967232);
INSERT INTO `banktransactions` VALUES('WeeD','farm',2,71,1309975552);
INSERT INTO `banktransactions` VALUES('Mirko','mirko911',2,18,1309976448);
INSERT INTO `banktransactions` VALUES('chemosmartie','chemo',2,80,1309986432);
INSERT INTO `banktransactions` VALUES('eXchange178','eXchange',2,90,1309998976);
INSERT INTO `banktransactions` VALUES('WeeD','farm',2,40,1309999232);
INSERT INTO `banktransactions` VALUES('eXchange178','eXchange',3,30,1309999360);
INSERT INTO `banktransactions` VALUES('WeeD','farm',2,30,1309999488);
INSERT INTO `banktransactions` VALUES('eXchange178','eXchange',2,81.6,1310004096);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',3,120,1310031488);
INSERT INTO `banktransactions` VALUES('WeeD','farm',2,30,1310033536);
INSERT INTO `banktransactions` VALUES('WeeD','farm',2,19,1310046208);
INSERT INTO `banktransactions` VALUES('eXchange178','eXchange',2,33.53,1310068224);
INSERT INTO `banktransactions` VALUES('DaveTheBorrow','DaveTheBorrow',1,0,1310068224);
INSERT INTO `banktransactions` VALUES('Mirko','3xp',1,0,1310071680);
INSERT INTO `banktransactions` VALUES('Mirko','mirko911',3,792,1310071808);
INSERT INTO `banktransactions` VALUES('Mirko','3xp',2,792,1310071808);
INSERT INTO `banktransactions` VALUES('Mirko','3xp',9,0,1310071808);
INSERT INTO `banktransactions` VALUES('WeeD','farm',3,50,1310073728);
INSERT INTO `banktransactions` VALUES('Eralod','Eralod',2,35.97,1310073856);
INSERT INTO `banktransactions` VALUES('Sleepwalker','Sleepwalker',2,75.39,1310081792);
INSERT INTO `banktransactions` VALUES('Sleepwalker','Sleepwalker',3,350,1310081920);
INSERT INTO `banktransactions` VALUES('tiga06','tiga06',2,100,1310081920);
INSERT INTO `banktransactions` VALUES('Dance17','dance17',1,0,1310081920);
INSERT INTO `banktransactions` VALUES('Eralod','Eralod',3,402,1310130304);
INSERT INTO `banktransactions` VALUES('Henrik','Henrik',1,0,1310135680);
INSERT INTO `banktransactions` VALUES('Henrik','Henrik',2,72.79,1310135680);
INSERT INTO `banktransactions` VALUES('Eralod','Eralod',2,30,1310142592);
INSERT INTO `banktransactions` VALUES('tiga06','tiga06',2,266,1310142592);
INSERT INTO `banktransactions` VALUES('WeeD','farm',2,10,1310145152);
INSERT INTO `banktransactions` VALUES('Auspex','Auspex',2,41.4,1310145280);
INSERT INTO `banktransactions` VALUES('WeeD','farm',3,50,1310146560);
INSERT INTO `banktransactions` VALUES('Darlfire','Darlfire',2,200,1310157696);
INSERT INTO `banktransactions` VALUES('WeeD','farm',2,26,1310204544);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',3,90,1310210816);
INSERT INTO `banktransactions` VALUES('Mirko','3xp',2,11,1310213888);
INSERT INTO `banktransactions` VALUES('ScrappY','3xp',2,220,1310214016);
INSERT INTO `banktransactions` VALUES('DaveTheBorrow','DaveTheBorrow',2,10,1310235136);
INSERT INTO `banktransactions` VALUES('DaveTheBorrow','DaveTheBorrow',2,8,1310239744);
INSERT INTO `banktransactions` VALUES('WeeD','farm',2,320,1310305664);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',3,90,1310308480);
INSERT INTO `banktransactions` VALUES('Nameless','12345',3,100,1310315136);
INSERT INTO `banktransactions` VALUES('Elgert','Elgert',2,44.07,1310319104);
INSERT INTO `banktransactions` VALUES('Sleepwalker','Sleepwalker',2,41.95,1310322176);
INSERT INTO `banktransactions` VALUES('WeeD','farm',3,20,1310329984);
INSERT INTO `banktransactions` VALUES('chemosmartie','chemo',3,120,1310419200);
INSERT INTO `banktransactions` VALUES('WeeD','farm',2,25,1310578944);
INSERT INTO `banktransactions` VALUES('Elgert','Elgert',2,33,1310578944);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',3,100,1310648320);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',3,80,1310648704);
INSERT INTO `banktransactions` VALUES('Sleepwalker','Sleepwalker',2,28.75,1310868352);
INSERT INTO `banktransactions` VALUES('tiga06','tiga06',2,300,1310868352);
INSERT INTO `banktransactions` VALUES('Mirko','3xp',2,250,1310953216);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',3,150,1311036928);
INSERT INTO `banktransactions` VALUES('Sleepwalker','Sleepwalker',2,141,1311126656);
INSERT INTO `banktransactions` VALUES('Sleepwalker','Sleepwalker',2,3.7,1311126784);
INSERT INTO `banktransactions` VALUES('Nameless','12345',3,50,1311199872);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',3,100,1311199872);
INSERT INTO `banktransactions` VALUES('Mirko','3xp',2,204,1311271424);
INSERT INTO `banktransactions` VALUES('Spectar','spectar',3,165.71,1311282048);
INSERT INTO `banktransactions` VALUES('Spectar','xentrics',1,0,1311282176);
INSERT INTO `banktransactions` VALUES('Spectar','xentrics',2,170,1311282176);
INSERT INTO `banktransactions` VALUES('Darlfire','Darlfire',2,400,1311370880);
INSERT INTO `banktransactions` VALUES('Sleepwalker','Sleepwalker',2,145.1,1311414016);
INSERT INTO `banktransactions` VALUES('Elgert','Elgert',2,115.9,1311441664);
INSERT INTO `banktransactions` VALUES('DaveTheBorrow','DaveTheBorrow',2,20,1311512832);
INSERT INTO `banktransactions` VALUES('Mirko','3xp',2,75.75,1311512832);
INSERT INTO `banktransactions` VALUES('Sleepwalker','Sleepwalker',2,23.47,1311541888);
INSERT INTO `banktransactions` VALUES('Dance17','dance17',2,168.01,1311542016);
INSERT INTO `banktransactions` VALUES('Dance17','dance17',2,40.05,1311565056);
INSERT INTO `banktransactions` VALUES('chemosmartie','chemo',2,130,1311599360);
INSERT INTO `banktransactions` VALUES('tiga06','tiga06',3,10,1311599616);
INSERT INTO `banktransactions` VALUES('tiga06','chemo',9,0,1311599616);
INSERT INTO `banktransactions` VALUES('tiga06','chemo',3,476.9346808218279,1311599872);
INSERT INTO `banktransactions` VALUES('tiga06','chemo',6,0,1311599872);
INSERT INTO `banktransactions` VALUES('chemosmartie','chemosmartie',1,0,1311599872);
INSERT INTO `banktransactions` VALUES('chemosmartie','chemosmartie',2,460,1311600000);
INSERT INTO `banktransactions` VALUES('chemosmartie','chemosmartie',3,10,1311600000);
INSERT INTO `banktransactions` VALUES('chemosmartie','chemosmartie',2,10,1311600000);
INSERT INTO `banktransactions` VALUES('Dance17','dance17',2,160.95,1311706752);
INSERT INTO `banktransactions` VALUES('Elgert','Elgert',2,15,1311711616);
INSERT INTO `banktransactions` VALUES('DaveTheBorrow','DaveTheBorrow',3,20,1311875840);
INSERT INTO `banktransactions` VALUES('DaveTheBorrow','DaveTheBorrow',2,30,1311875968);
INSERT INTO `banktransactions` VALUES('Sleepwalker','Sleepwalker',2,356.33,1311885824);
INSERT INTO `banktransactions` VALUES('Nameless','12345',3,150,1311889280);
INSERT INTO `banktransactions` VALUES('Dance17','dance17',2,100,1311954944);
INSERT INTO `banktransactions` VALUES('Dance17','dance27',1,0,1311954944);
INSERT INTO `banktransactions` VALUES('Dance17','dance17',3,350,1311955200);
 
Dankeschön für eure Hilfe! Es geht!

MfG

tiga05
Ergänzung ()

Mh... ich glaube irgendwas funktioniert immernoch nicht richtig. In der Konsole vom Spiel zeigt er immer folgenden Fehler an:


17:25:27 [WARNING] [BankAccount] Error #01-2: Unknown column 'id' in 'field list'

Deutet also auf einen Syntaxfehler o.ä. hin?
 
Da fehlt das Feld "id" in der Tabelle.

Ohne Garantie:
CREATE TABLE `bankaccounts` (`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY, `accountname` VARCHAR( 255 ) NOT NULL , `owners` LONGTEXT NOT NULL, `users` LONGTEXT NOT NULL, `password` VARCHAR( 255 ) NULL DEFAULT '', `amount` DOUBLE( 255,2 ) NOT NULL DEFAULT '0', `cleanname` LONGTEXT NOT NULL DEFAULT '');
 
Vielen Dank für deine Bemühungen. Hat aber trotzdem nicht funktioniert. Ist aber auch jetzt egal :D.

Ist es eigentlich möglich, auch Datenbankschnipsel wie z.b. sowas hier zu importieren:
Code: 
(1, 'tiga06', 56.96, FALSE),
(2, 'Stadtverwaltung', 6580.33, FALSE),
(3, 'xomE', 537.09, FALSE),
(4, 'eXchange178', 270.00, FALSE),
(5, 'Sleepwalker', 53.67, FALSE),
(6, 'Mirko', 25.29, FALSE),
(7, 'Auspex', 34.73, FALSE),
(8, 'Spectar', 20.67, FALSE),
(9, 'Lacisha', 53.81, FALSE),
(10, 'Darlfire', 183.00, FALSE),
(11, 'SHiK', 148.58, FALSE),
(12, 'Nameless', 4.61, FALSE),
(13, 'Paul', 55.56, FALSE),
(14, '25gee', 45.63, FALSE),
(15, 'ScrappY', 42.53, FALSE),
(16, 'Tobi', 419.37, FALSE),
(17, 'chemosmartie', 217.67, FALSE),

In der mysql Datenbank sind schon Einträge in der Art und Weise vorhanden.
 
Zuletzt bearbeitet:
Du musst dich einloggen oder registrieren, um hier zu antworten.

Ähnliche Themen

M
Wie eine Online-Datenbank erstellen? (SQL + PHP?)
2 3
Antworten
47
Aufrufe
4.175
McMoneysack91
M
M
SQL Datenbank in phpMyAdmin Importieren
2
Antworten
25
Aufrufe
2.130
andy_m4
andy_m4
A
Leserartikel Dell Precision 5540 in 2023, muss es immer das Neueste sein?
2
Antworten
20
Aufrufe
4.789
mifritscher
M
A
Tipps für den Einstieg in ein kleines Projekt
Antworten
9
Aufrufe
1.692
rgrep
R
G
Verbindung in MySQL Workbench zu WD myCloud erstellen
Antworten
3
Aufrufe
4.454
Gizzy3001
G
Zurück
Oben

Willkommen auf ComputerBase!

Mit Werbung weiterlesen

Besuche ComputerBase wie gewohnt mit Werbung und Tracking. Die Zustimmung ist jederzeit widerrufbar.

Details im Privacy Center und in der Liste unserer Partner. Ein Widerruf ist möglich in der Datenschutzerklärung.

… oder ComputerBase Pro bestellen

Nutze ComputerBase ohne Werbebanner, Video-Ads und Werbetracking schon für 4 €/Monat oder 36 €/Jahr.

Mehr zu ComputerBase Pro

Bereits Pro-Nutzer? Hier anmelden.

Tracking: Wir und unsere 165 Partner verarbeiten personenbezogene Daten, indem wir mit auf Ihrem Gerät gespeicherten Informationen (z. B. eindeutige Kennungen in Cookies) ein Nutzungsprofil erstellen, um z. B. Anzeigen zu personalisieren. Verarbeitungszwecke: Genaue Standortdaten und Abfrage von Geräteeigenschaften zur Identifikation, Informationen auf einem Gerät speichern und/oder abrufen, Personalisierte Anzeigen und Inhalte, Anzeigen- und Inhaltsmessungen, Erkenntnisse über Zielgruppen und Produktentwicklungen.

Impressum Kontakt Datenschutz