ich habe eine "Hausaufgabe" bekommen doch kann die irgendwie nicht an MEINEM PC lösen. In der Schule hatte es ganz normal funktioniert
Also wir benutzen XAMPP (aktuellste Ver.) und hosten halt APACHE und MySQL.
Bei SQL (SCHULE) gebe ich diesen Befehl ein und dieser Funktioniert:
Quote:
CREATE TABLE wmtitel
(
saison INTEGER NOT NULL,
fahrerwm VARCHAR(50),
konstrukteurswm VARCHAR(50),
fahrerpunkte INTEGER,
teampunkte INTEGER,
anzahlrennen INTEGER,
CONSTRAINT pk_wmtitel PRIMARY KEY (saison)
);
INSERT INTO wmtitel VALUES (1958,'Mike Hawthorn','Vanwall/Vanwall',42,48,11);
INSERT INTO wmtitel VALUES (1959,'Jack Brabham','Cooper/Climax',31,40,9);
INSERT INTO wmtitel VALUES (1960,'Jack Brabham','Cooper/Climax',43,48,11);
INSERT INTO wmtitel VALUES (1961,'Phil Hill','Ferrari/Ferrari',34,45,8);
INSERT INTO wmtitel VALUES (1962,'Graham Hill','BRM/BRM',42,42,9);
INSERT INTO wmtitel VALUES (1963,'Jim Clark','Lotus/Climax',54,54,10);
INSERT INTO wmtitel VALUES (1964,'John Surtees','Ferrari/Ferrari',40,45,10);
INSERT INTO wmtitel VALUES (1965,'Jim Clark','Lotus/Climax',54,54,10);
INSERT INTO wmtitel VALUES (1966,'Jack Brabham','Brabham/Repco',42,42,9);
INSERT INTO wmtitel VALUES (1967,'Denny Hulme','Brabham/Repco',51,63,11);
INSERT INTO wmtitel VALUES (1968,'Graham Hill','Lotus/Ford',48,62,12);
INSERT INTO wmtitel VALUES (1969,'Jackie Stewart','Matra/Ford',63,66,11);
INSERT INTO wmtitel VALUES (1970,'Jochen Rindt','Lotus/Ford',45,59,13);
INSERT INTO wmtitel VALUES (1971,'Jackie Stewart','Tyrrell/Ford',62,73,11);
INSERT INTO wmtitel VALUES (1972,'Emerson Fittipaldi','Lotus/Ford',61,61,12);
INSERT INTO wmtitel VALUES (1973,'Jackie Stewart','Lotus/Ford',71,92,15);
INSERT INTO wmtitel VALUES (1974,'Emerson Fittipaldi','McLaren/Ford',55,73,15);
INSERT INTO wmtitel VALUES (1975,'Niki Lauda','Ferrari/Ferrari',64.5,72.5,14);
INSERT INTO wmtitel VALUES (1976,'James Hunt','Ferrari/Ferrari',69,83,16);
INSERT INTO wmtitel VALUES (1977,'Niki Lauda','Ferrari/Ferrari',72,95,17);
INSERT INTO wmtitel VALUES (1978,'Mario Andretti','Lotus/Ford',64,86,16);
INSERT INTO wmtitel VALUES (1979,'Jody Scheckter','Ferrari/Ferrari',51,113,15);
INSERT INTO wmtitel VALUES (1980,'Alan Jones','Williams/Ford',67,120,14);
INSERT INTO wmtitel VALUES (1981,'Nelson Piquet','Williams/Ford',50,95,15);
INSERT INTO wmtitel VALUES (1982,'Keke Rosberg','Ferrari/Ferrari',44,74,16);
INSERT INTO wmtitel VALUES (1983,'Nelson Piquet','Ferrari/Ferrari',59,89,15);
INSERT INTO wmtitel VALUES (1984,'Niki Lauda','McLaren/TAG',72,143.5,16);
INSERT INTO wmtitel VALUES (1985,'Alain Prost','McLaren/TAG',73,90,16);
INSERT INTO wmtitel VALUES (1986,'Alain Prost','Williams/Honda',72,141,16);
INSERT INTO wmtitel VALUES (1987,'Nelson Piquet','Williams/Honda',73,137,16);
INSERT INTO wmtitel VALUES (1988,'Ayrton Senna','McLaren/Honda',90,199,16);
INSERT INTO wmtitel VALUES (1989,'Alain Prost','McLaren/Honda',76,141,16);
INSERT INTO wmtitel VALUES (1990,'Ayrton Senna','McLaren/Honda',78,121,16);
INSERT INTO wmtitel VALUES (1991,'Ayrton Senna','McLaren/Honda',96,139,16);
INSERT INTO wmtitel VALUES (1992,'Nigel Mansell','Williams/Renault',108,164,16);
INSERT INTO wmtitel VALUES (1993,'Alain Prost','Williams/Renault',99,168,16);
INSERT INTO wmtitel VALUES (1994,'Michael Schumacher','Williams/Renault',92,118,16);
INSERT INTO wmtitel VALUES (1995,'Michael Schumacher','Benetton/Renault',102,137,17);
INSERT INTO wmtitel VALUES (1996,'Damon Hill','Williams/Renault',97,175,16);
INSERT INTO wmtitel VALUES (1997,'Jaques Villeneuve','Williams/Renault',81,123,17);
INSERT INTO wmtitel VALUES (1998,'Mika Häkkinen','McLaren/Mercedes-Benz',100,156,16);
INSERT INTO wmtitel VALUES (1999,'Mika Häkkinen','McLaren/Mercedes-Benz',76, 128, 16);
INSERT INTO wmtitel VALUES (2000,'Michael Schumacher','Ferrari/Ferrari',108,170,17);
INSERT INTO wmtitel VALUES (2001,'Michael Schumacher','Ferrari/Ferrari',123,179,17);
INSERT INTO wmtitel VALUES (2002,'Michael Schumacher','Ferrari/Ferrari',144,221,17);
INSERT INTO wmtitel VALUES (2003,'Michael Schumacher','Ferrari/Ferrari',93,158,16);
INSERT INTO wmtitel VALUES (2004,'Michael Schumacher','Ferrari/Ferrari',148,262,18);
INSERT INTO wmtitel VALUES (2005,'Fernando Alonso','Renault/Renault',133,191,19);
INSERT INTO wmtitel VALUES (2006,'Fernando Alonso','Renault/Renault',134,206,18);
INSERT INTO wmtitel VALUES (2007,'Kimi Räikkönen','Ferrari/Ferrari',110,204,17);
INSERT INTO wmtitel VALUES (2008,'Lewis Hamilton','McLaren/Mercedes',98,172,18);
INSERT INTO wmtitel VALUES (2009,'Jenson Button','Brawn/Mercedes-Benz',95,172,17);
INSERT INTO wmtitel VALUES (2010,'Sebastian Vettel','Red Bull Racing/Renault',256,498,19);
INSERT INTO wmtitel VALUES (2011,'Sebastian Vettel','Red Bull Racing/Renault',392,650,19);
INSERT INTO wmtitel VALUES (2012,'Sebastian Vettel','Red Bull Racing/Renault',281,460,20);
Quote:
Fehler
SQL-Befehl:
CREATE TABLE wmtitel(
saison INTEGER NOT NULL ,
fahrerwm VARCHAR( 50 ) ,
konstrukteurswm VARCHAR( 50 ) ,
fahrerpunkte INTEGER,
teampunkte INTEGER,
anzahlrennen INTEGER,
CONSTRAINT pk_wmtitel PRIMARY KEY ( saison )
);
MySQL meldet: Dokumentation
#1046 - No database selected
woran könnte das liegen? hab auch nichts besonderes bei Google gefunden, was mir ansatzweise helfen könnte.