31.05.2014, 19:12
If you edited this by yourself, you sure didn't did it right. Check if you didn't skipped value. You can do something like.
pawn Код:
--
-- Structura de tabel pentru tabelul `BarziniFamilyCars`
--
CREATE TABLE IF NOT EXISTS `BarziniFamilyCars` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`Model` int(3) NOT NULL,
`PosX` float NOT NULL,
`PosY` float NOT NULL,
`PosZ` float NOT NULL,
`Angle` float NOT NULL,
`Color1` int(3) NOT NULL,
`Color2` int(3) NOT NULL,
`TRespawn` int(11) NOT NULL,
`Rank` int(1) NOT NULL,
`Plate` text NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
//11 columns
--
-- Salvarea datelor din tabel `BarziniFamilyCars`
--
INSERT INTO `BarziniFamilyCars` (`ID`, `Model`, `PosX`, `PosY`, `PosZ`, `Angle`, `Color1`, `Color2`, `TRespawn`, `Rank`, `Plate`) VALUES
(1, 463, 1094.52, -1186.97, 17.8647, 178.745, 245, 245, 4000, 1, 'LS 1 BRZ'), //11 values, 10 commas
(2, 521, 1098.14, -1186.86, 17.9114, 185.248, 245, 245, 4000, 1, 'LS 2 BRZ'), //11 values, 10 commas
(3, 445, 1109.17, -1193.22, 17.9794, 87.4464, 245, 245, 4000, 1, 'LS 3 BRZ'), //11 values, 10 commas
(4, 421, 1087.74, -1192.35, 18.069, 270.91, 245, 245, 4000, 1, 'LS 4 BRZ'), //11 values, 10 commas
(5, 567, 1093.85, -1227.3, 15.6866, 180.149, 245, 245, 4000, 1, 'LS 5 BRZ'), //11 values, 10 commas
(6, 482, 1098.86, -1227.58, 15.9397, 177.744, 245, 245, 4000, 1, 'LS 6 BRZ'), //11 values, 10 commas
(7, 419, 1089.92, -1219.59, 17.739, 269.26, 245, 245, 4000, 1, 'LS 7 BRZ'), //11 values, 10 commas
(8, 409, 1102.02, -1219.91, 17.6047, 89.7216, 245, 245, 4000, 1, 'LS 8 BRZ'), //11 values, 10 commas
(9, 535, 1105.28, -1227.15, 15.5913, 181.31, 245, 245, 4000, 1, 'LS 9 BRZ'), //11 values, 10 commas
(10, 567, 1086.87, -1226.37, 15.6908, 181.161, 245, 245, 4000, 1, 'LS 10 BRZ'); //11 values, 10 commas