Guten Abend Breadfish.
Diese Codes machen mir heute zu schaffen.
format(query2,sizeof(query2),"CREATE TABEL IF NOT EXISTS `extdaten`(`Id` int(11) AUTO_INCREMENT,`Name` varchar(30),`email` varchar(70),`TSIdentität` varchar(40),PRIMARY KEY (`Id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;");
mysql_query(query2);
new query3[500];
format(query3,sizeof(query3),"CREATE TABEL IF NOT EXISTS `auto`(`Id` int(11) AUTO_INCREMENT,`Besitzer` varchar(30),`Model` int(4),`PosX` float(10),`PosY` float(10),`PosZ` float(10),`PosA` float(10),`Color1` int(3),`Color` int(3),`Preis` int(7),PRIMARY KEY(`ID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;");
mysql_query(query3);
Sie werden zwar ausgeführt, aber errors im MySQL-Debug entstehen und es werden keine Tabellen erstellt.
Errors:
[20:48:31] >> mysql_query( Connection handle: 1 )
[20:48:31] CMySQLHandler::Query(CREATE TABEL IF NOT EXISTS `extdaten`(`ID` int(11) AUTO_INCREMENT,`Name` varchar(30),`eMail` varchar(70),`TS-Identität` varchar(40),PRIMARY KEY (`ID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;) - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABEL IF NOT EXISTS `extdaten`(`ID` int(11) AUTO_INCREMENT,`Name` varchar(30),`e' at line 1)
[20:48:31] >> mysql_query( Connection handle: 1 )
[20:48:31] CMySQLHandler::Query(CREATE TABEL IF NOT EXISTS `auto`(`ID` int(11) AUTO_INCREMENT,`Besitzer` varchar(30),`Model` int(4),`PosX` float(10),`PosY` float(10),`PosZ` float(10),`PosA` float(10),`Color1` int(3),`Color` int(3),`Preis` int(7),PRIMARY KEY(`ID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;) - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABEL IF NOT EXISTS `auto`(`ID` int(11) AUTO_INCREMENT,`Besitzer` varchar(30),`M' at line 1)