Invalid column count in CSV input on line 1.

Hi Experts,

I am trying to do a CSV import through phpMyAdmin, as I have done many times before, but I am getting the following error:

 Invalid column count in CSV input on line 1.

The difference between this table and the others is that this table has a date field.

My table structure is

CREATE TABLE `niagara_trips` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `date` date NOT NULL,
 `run` char(1) NOT NULL,
 `capacity` smallint(6) NOT NULL DEFAULT '0',
 `vehicle_id` int(11) NOT NULL DEFAULT '0',
 `driver_id` int(11) NOT NULL DEFAULT '0',
 `guide_type` char(2) NOT NULL COMMENT 'PR=Payer, PE=Payee, DR=Driver',
 `guide_id` int(11) NOT NULL DEFAULT '0',
 `comments` varchar(4000) NOT NULL,
 `archived` tinyint(4) NOT NULL DEFAULT '0',
 PRIMARY KEY (`id`),
 KEY `date` (`date`),
 KEY `run` (`run`),
 KEY `driver_id` (`driver_id`),
 KEY `capacity` (`capacity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
Open new phpMyAdmin window

Open in new window


My CSV file contain only 1 row just for test, which is
1,2011-07-16,A,48,0,0,,0,,0

Open in new window


It is the correct column count, I am not sure why I am getting the above.

Thank you
APD TorontoAsked:
Who is Participating?
 
Mark BullockQA Engineer IIICommented:
Try adding an empty line at the end of your csv file.
0
 
Mark BullockQA Engineer IIICommented:
I don't know if this is related, but you should use 0 for the values of the id field because it is an auto_increment field.
0
 
APD TorontoAuthor Commented:
I added the blank line at the end.

I also tried the following

0,2011-07-16,A,48,0,0,,0,,0

,2011-07-16,A,48,0,0,,0,,0

2011-07-16,A,48,0,0,,0,,0

Nothing works. Can you try on your end?
0
 
APD TorontoAuthor Commented:
I tried to load the same CSV through command prompt, and I got the following warnings

| 1178 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1179 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1180 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1181 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1182 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1183 | 0000-00-00 | A   |       48 |         15 |        31 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1184 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1185 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1186 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1187 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1188 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1189 | 0000-00-00 | A   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1190 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1191 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1192 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1193 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1194 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1195 | 0000-00-00 | A   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1196 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1197 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1198 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1199 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1200 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1201 | 0000-00-00 | A   |       48 |         15 |        39 | DR         |       48 |                                                                                                                                                                                                           |        0 |
| 1202 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1203 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1204 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1205 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1206 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1207 | 0000-00-00 | A   |       56 |         37 |        37 | DR         |       37 |                                                                                                                                                                                                           |        0 |
| 1208 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1209 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1210 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1211 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1212 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1213 | 0000-00-00 | A   |       50 |         28 |        68 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1214 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1215 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1216 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1217 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1218 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1219 | 0000-00-00 | A   |       48 |         17 |        11 |            |        0 | May not have been 4782 but according to payroll it was a coach and not a mini as was entered.  And that makes more sense                                                                                  |        0 |
| 1220 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1221 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1222 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1223 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1224 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1225 | 0000-00-00 | A   |       24 |         18 |        39 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1226 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1227 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1228 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1229 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1230 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1231 | 0000-00-00 | A   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1232 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1233 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1234 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1235 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1236 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1237 | 0000-00-00 | A   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1238 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1239 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1240 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1241 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1242 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1243 | 0000-00-00 | A   |       58 |          9 |        39 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1244 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1245 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1246 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1247 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1248 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1249 | 0000-00-00 | A   |       24 |         18 |        39 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1250 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1251 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1252 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1253 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1254 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1255 | 0000-00-00 | A   |       24 |         18 |        11 |            |        0 | may not have been 33 but was a mini according to payroll and not a coach as was entered                                                                                                                   |        0 |
| 1256 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1257 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1258 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1259 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1260 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1261 | 0000-00-00 | A   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1262 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1263 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1264 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1265 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1266 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1267 | 0000-00-00 | A   |       24 |         18 |        39 |            |        0 | mini according to payroll                                                                                                                                                                                 |        0 |
| 1268 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1269 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1270 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1271 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1272 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1273 | 0000-00-00 | A   |       24 |         18 |         0 |            |        0 | may not have been 33 but was a mini according to payroll and not a coach as was entered                                                                                                                   |        0 |
| 1274 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1275 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1276 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1277 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1278 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1279 | 0000-00-00 | A   |       24 |         18 |        11 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1280 | 0000-00-00 | B   |        0 |         35 |        53 |            |        0 | we gave 2 to King from the Bond today                                                                                                                                                                     |        0 |
| 1281 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1282 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1283 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1284 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1285 | 0000-00-00 | A   |       24 |         18 |        39 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1286 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1287 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1288 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1289 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1290 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1291 | 0000-00-00 | A   |       24 |         18 |         0 |            |        0 | may not have been 33 but was a mini according to payroll and not a coach as was entered                                                                                                                   |        0 |
| 1292 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1293 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1294 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1295 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1296 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1297 | 0000-00-00 | A   |       24 |         18 |        11 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1298 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1299 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1300 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1301 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1302 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1303 | 0000-00-00 | A   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1304 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1305 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1306 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1307 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1308 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1309 | 0000-00-00 | A   |       24 |         18 |        39 |            |        0 | may not have been 33 but was a mini according to payroll and not a coach as was entered                                                                                                                   |        0 |
| 1310 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1311 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1312 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1313 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1314 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1315 | 0000-00-00 | A   |       24 |         18 |        51 |            |        0 | may not have been 33 but was a mini according to payroll and not a coach as was entered                                                                                                                   |        0 |
| 1316 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1317 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1318 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1319 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1320 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1321 | 0000-00-00 | A   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1322 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1323 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1324 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1325 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1326 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1327 | 0000-00-00 | A   |       24 |         18 |        11 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1328 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1329 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1330 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1331 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1332 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1333 | 0000-00-00 | A   |       24 |         18 |        39 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1334 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1335 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1336 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1337 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1338 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1339 | 0000-00-00 | A   |       24 |         18 |        39 | DR         |       39 |                                                                                                                                                                                                           |        0 |
| 1340 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1341 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1342 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1343 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1344 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1345 | 0000-00-00 | A   |       24 |         18 |        11 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1346 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1347 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1348 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1349 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1350 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1351 | 0000-00-00 | A   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1352 | 0000-00-00 | B   |        0 |         35 |        53 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1353 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1354 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1355 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1356 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1357 | 0000-00-00 | A   |       24 |         18 |        39 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1358 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1359 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1360 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1361 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1362 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1363 | 0000-00-00 | A   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1364 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1365 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1366 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1367 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1368 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1369 | 0000-00-00 | A   |       24 |         18 |        39 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1370 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1371 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1372 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1373 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1374 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1375 | 0000-00-00 | A   |       24 |         18 |         0 |            |        0 | may not have been 33 but was a mini according to payroll and not a coach as was entered                                                                                                                   |        0 |
| 1376 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1377 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1378 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1379 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1380 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1381 | 0000-00-00 | A   |       24 |         18 |        11 |            |        0 | may not have been 33 but was a mini according to payroll and not a coach as was entered                                                                                                                   |        0 |
| 1382 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1383 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1384 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1385 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1386 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1387 | 0000-00-00 | A   |       58 |          9 |        37 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1388 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1389 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1390 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1391 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1392 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1393 | 0000-00-00 | A   |       24 |         18 |        11 |            |        0 | may not have been 33 but was a mini according to payroll and not a coach as was entered                                                                                                                   |        0 |
| 1394 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1395 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1396 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1397 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1398 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1399 | 0000-00-00 | A   |       24 |         18 |        39 |            |        0 | may not have been 33 but was a mini according to payroll and not a coach as was entered                                                                                                                   |        0 |
| 1400 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1401 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1402 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1403 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1404 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1405 | 0000-00-00 | A   |       24 |         18 |        39 |            |        0 | may not have been 33 but was a mini according to payroll and not a coach as was entered                                                                                                                   |        0 |
| 1406 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1407 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1408 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1409 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1410 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1411 | 0000-00-00 | A   |       24 |         18 |         0 |            |        0 | may not have been 33 but was a mini according to payroll and not a coach as was entered                                                                                                                   |        0 |
| 1412 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1413 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1414 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1415 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1416 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1417 | 0000-00-00 | A   |       24 |         18 |         0 |            |        0 | may not have been 33 but was a mini according to payroll and not a coach as was entered                                                                                                                   |        0 |
| 1418 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1419 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1420 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1421 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1422 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1423 | 0000-00-00 | A   |       48 |         15 |        11 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1424 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1425 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1426 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1427 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1428 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1429 | 0000-00-00 | A   |       48 |         15 |        11 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1430 | 0000-00-00 | B   |       24 |         18 |        51 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1431 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1432 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1433 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1434 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1435 | 0000-00-00 | A   |       24 |         18 |        39 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1436 | 0000-00-00 | B   |        0 |         35 |        53 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1437 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1438 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1439 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1440 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1441 | 0000-00-00 | A   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1442 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1443 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1444 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1445 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1446 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1447 | 0000-00-00 | A   |       24 |         18 |         0 |            |        0 | may not have been 33 but was a mini according to payroll and not a coach as was entered                                                                                                                   |        0 |
| 1448 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1449 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1450 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1451 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1452 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1453 | 0000-00-00 | A   |       58 |          9 |        39 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1454 | 0000-00-00 | B   |       48 |         17 |        58 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1455 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1456 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1457 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1458 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1459 | 0000-00-00 | A   |       58 |          9 |        11 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1460 | 0000-00-00 | B   |        0 |         35 |        53 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1461 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1462 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1463 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1464 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1465 | 0000-00-00 | A   |       48 |         17 |        51 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1466 | 0000-00-00 | B   |       24 |         18 |        58 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1467 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1468 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1469 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1470 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1471 | 0000-00-00 | A   |       24 |         18 |        51 |            |        0 | may not have been 33 but was a mini according to payroll and not a coach as was entered                                                                                                                   |        0 |
| 1472 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1473 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1474 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1475 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1476 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1477 | 0000-00-00 | A   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1478 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1479 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1480 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1481 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1482 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1483 | 0000-00-00 | A   |       24 |         18 |         0 |            |        0 | may not have been 33 but was a mini according to payroll and not a coach as was entered                                                                                                                   |        0 |
| 1484 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1485 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1486 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1487 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1488 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1489 | 0000-00-00 | A   |       24 |         18 |        11 |            |        0 | may not have been 33 but was a mini according to payroll and not a coach as was entered                                                                                                                   |        0 |
| 1490 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1491 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1492 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1493 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1494 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1495 | 0000-00-00 | A   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1496 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1497 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1498 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1499 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1500 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1501 | 0000-00-00 | A   |       11 |          1 |         0 |            |        0 | may not have been 1551 but was a mini according to payroll and not a coach as was entered                                                                                                                 |        0 |
| 1502 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1503 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1504 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1505 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1506 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1507 | 0000-00-00 | A   |       24 |         19 |        39 | DR         |       39 |                                                                                                                                                                                                           |        0 |
| 1508 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1509 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1510 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1511 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1512 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1513 | 0000-00-00 | A   |       24 |         18 |         0 |            |        0 | may not have been 33 but was a mini according to payroll and not a coach as was entered                                                                                                                   |        0 |
| 1514 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1515 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1516 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1517 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1518 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1519 | 0000-00-00 | A   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1520 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1521 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1522 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1523 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1524 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1525 | 0000-00-00 | A   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1526 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1527 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1528 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1529 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1530 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1531 | 0000-00-00 | A   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1532 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1533 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1534 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1535 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1536 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1537 | 0000-00-00 | A   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1538 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1539 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1540 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1541 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1542 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1543 | 0000-00-00 | A   |       24 |         18 |        39 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1544 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1545 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1546 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1547 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1548 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1549 | 0000-00-00 | A   |       48 |         17 |        39 | DR         |       39 |                                                                                                                                                                                                           |        0 |
| 1550 | 0000-00-00 | B   |       24 |         18 |        37 | DR         |       37 |                                                                                                                                                                                                           |        0 |
| 1551 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1552 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1553 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1554 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1555 | 0000-00-00 | A   |       24 |         18 |         0 |            |        0 | mini according to payroll                                                                                                                                                                                 |        0 |
| 1556 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1557 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1558 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1559 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1560 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1561 | 0000-00-00 | A   |       24 |         19 |        39 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1562 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1563 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1564 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1565 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1566 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1567 | 0000-00-00 | A   |       24 |         18 |        39 |            |        0 | May not have been 33 but was left blank so changed later                                                                                                                                                  |        0 |
| 1568 | 0000-00-00 | B   |        0 |         35 |        53 |            |        0 | Additional trip added because 4 passengers went with King tours                                                                                                                                           |        0 |
| 1569 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1570 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1571 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1572 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1573 | 0000-00-00 | A   |       24 |         19 |        39 | DR         |       39 |                                                                                                                                                                                                           |        0 |
| 1574 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1575 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1576 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1577 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1578 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1579 | 0000-00-00 | A   |       24 |         18 |         0 |            |        0 | may not have been 33 but was a mini according to payroll and not a coach as was entered                                                                                                                   |        0 |
| 1580 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1581 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1582 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1583 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1584 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1585 | 0000-00-00 | A   |       48 |         17 |        39 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1586 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1587 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1588 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1589 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1590 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1591 | 0000-00-00 | A   |       24 |         18 |        51 |            |        0 | May not have been 33 but was left blank so changed later                                                                                                                                                  |        0 |
| 1592 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1593 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1594 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1595 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1596 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1597 | 0000-00-00 | A   |       48 |         17 |        39 | DR         |       39 |                                                                                                                                                                                                           |        0 |
| 1598 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1599 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1600 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1601 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1602 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1603 | 0000-00-00 | A   |       24 |         19 |        39 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1604 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1605 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1606 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1607 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1608 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1609 | 0000-00-00 | A   |       24 |         19 |        51 | DR         |       51 |                                                                                                                                                                                                           |        0 |
| 1610 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1611 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1612 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1613 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1614 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1615 | 0000-00-00 | A   |       48 |         17 |        37 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1616 | 0000-00-00 | B   |       24 |         18 |        39 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1617 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1618 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1619 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1620 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1621 | 0000-00-00 | A   |       24 |         19 |        51 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1622 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1623 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1624 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1625 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1626 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1627 | 0000-00-00 | A   |       24 |         19 |        11 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1628 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1629 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1630 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1631 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1632 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1633 | 0000-00-00 | A   |       24 |         19 |        39 | DR         |       39 |                                                                                                                                                                                                           |        0 |
| 1634 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1635 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1636 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1637 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1638 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1639 | 0000-00-00 | A   |       50 |         28 |        39 | DR         |       39 | 66 pax to start, ended with 74. Taking 5083 and 4782 Weather: sunny, windy but nice                                                                                                                       |        0 |
| 1640 | 0000-00-00 | B   |       48 |         17 |        68 | DR         |       68 |                                                                                                                                                                                                           |        0 |
| 1641 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1642 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1643 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1644 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1645 | 0000-00-00 | A   |       48 |         17 |        39 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1646 | 0000-00-00 | B   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1647 | 0000-00-00 | C   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1648 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1649 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1650 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1651 | 0000-00-00 | A   |       58 |          9 |        51 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1652 | 0000-00-00 | B   |       48 |         17 |        39 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1653 | 0000-00-00 | C   |        0 |         35 |        54 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1654 | 0000-00-00 | D   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1655 | 0000-00-00 | E   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1656 | 0000-00-00 | F   |       48 |          0 |         0 |            |        0 |                                                                                                                                                                                                           |        0 |
| 1657 | 0000-00-00 | A   |       48 |         15 |        11 | DR         |       11 | Syed in the Yellow Trolley is helping with his pick ups                                                                                                                                                   |        0 |
| 1658 | 0000-00-00 | B   |        0 |         35 |        54 |            |        0 | Took 2 passengersCtrl-C -- sending "KILL QUERY 4" to server ...
, chargedCtrl-C -- query aborted.
 $45.00 each                                                                                                                                                                    |        0 |
+------+------------+-----+----------+------------+-----------+------------+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+
2662 rows in set (0.09 sec)

mysql> select * from niagara_trips;
ERROR 1317 (70100): Query execution was interrupted
mysql> select * from niagara_trips;
Empty set (0.00 sec)

mysql> LOAD DATA LOCAL INFILE 'D:\niagara_trips.csv' INTO TABLE niagara_trips;
ERROR 22 (HY000): File 'D:
iagara_trips.csv' not found (Errcode: 22 - Invalid argument)
mysql> LOAD DATA LOCAL INFILE 'niagara_trips.csv' INTO TABLE niagara_trips;
Query OK, 8448 rows affected, 65535 warnings (2.33 sec)
Records: 8448  Deleted: 0  Skipped: 0  Warnings: 84480

mysql> LOAD DATA LOCAL INFILE 'niagara_trips.csv' INTO TABLE niagara_trips;
Query OK, 8448 rows affected, 65535 warnings (1.94 sec)
Records: 8448  Deleted: 0  Skipped: 0  Warnings: 84480

mysql> LOAD DATA LOCAL INFILE 'niagara_trips.csv' INTO TABLE niagara_trips;
Query OK, 8448 rows affected, 65535 warnings (1.74 sec)
Records: 8448  Deleted: 0  Skipped: 0  Warnings: 84480

mysql> SHOW WARNINGS;
+---------+------+--------------------------------------------+
| Level   | Code | Message                                    |
+---------+------+--------------------------------------------+
| Warning | 1265 | Data truncated for column 'id' at row 1    |
| Warning | 1261 | Row 1 doesn't contain data for all columns |
| Warning | 1261 | Row 1 doesn't contain data for all columns |
| Warning | 1261 | Row 1 doesn't contain data for all columns |
| Warning | 1261 | Row 1 doesn't contain data for all columns |
| Warning | 1261 | Row 1 doesn't contain data for all columns |
| Warning | 1261 | Row 1 doesn't contain data for all columns |
| Warning | 1261 | Row 1 doesn't contain data for all columns |
| Warning | 1261 | Row 1 doesn't contain data for all columns |
| Warning | 1261 | Row 1 doesn't contain data for all columns |
| Warning | 1265 | Data truncated for column 'id' at row 2    |
| Warning | 1261 | Row 2 doesn't contain data for all columns |
| Warning | 1261 | Row 2 doesn't contain data for all columns |
| Warning | 1261 | Row 2 doesn't contain data for all columns |
| Warning | 1261 | Row 2 doesn't contain data for all columns |
| Warning | 1261 | Row 2 doesn't contain data for all columns |
| Warning | 1261 | Row 2 doesn't contain data for all columns |
| Warning | 1261 | Row 2 doesn't contain data for all columns |
| Warning | 1261 | Row 2 doesn't contain data for all columns |
| Warning | 1261 | Row 2 doesn't contain data for all columns |
| Warning | 1265 | Data truncated for column 'id' at row 3    |
| Warning | 1261 | Row 3 doesn't contain data for all columns |
| Warning | 1261 | Row 3 doesn't contain data for all columns |
| Warning | 1261 | Row 3 doesn't contain data for all columns |
| Warning | 1261 | Row 3 doesn't contain data for all columns |
| Warning | 1261 | Row 3 doesn't contain data for all columns |
| Warning | 1261 | Row 3 doesn't contain data for all columns |
| Warning | 1261 | Row 3 doesn't contain data for all columns |
| Warning | 1261 | Row 3 doesn't contain data for all columns |
| Warning | 1261 | Row 3 doesn't contain data for all columns |
| Warning | 1265 | Data truncated for column 'id' at row 4    |
| Warning | 1261 | Row 4 doesn't contain data for all columns |
| Warning | 1261 | Row 4 doesn't contain data for all columns |
| Warning | 1261 | Row 4 doesn't contain data for all columns |
| Warning | 1261 | Row 4 doesn't contain data for all columns |
| Warning | 1261 | Row 4 doesn't contain data for all columns |
| Warning | 1261 | Row 4 doesn't contain data for all columns |
| Warning | 1261 | Row 4 doesn't contain data for all columns |
| Warning | 1261 | Row 4 doesn't contain data for all columns |
| Warning | 1261 | Row 4 doesn't contain data for all columns |
| Warning | 1265 | Data truncated for column 'id' at row 5    |
| Warning | 1261 | Row 5 doesn't contain data for all columns |
| Warning | 1261 | Row 5 doesn't contain data for all columns |
| Warning | 1261 | Row 5 doesn't contain data for all columns |
| Warning | 1261 | Row 5 doesn't contain data for all columns |
| Warning | 1261 | Row 5 doesn't contain data for all columns |
| Warning | 1261 | Row 5 doesn't contain data for all columns |
| Warning | 1261 | Row 5 doesn't contain data for all columns |
| Warning | 1261 | Row 5 doesn't contain data for all columns |
| Warning | 1261 | Row 5 doesn't contain data for all columns |
| Warning | 1265 | Data truncated for column 'id' at row 6    |
| Warning | 1261 | Row 6 doesn't contain data for all columns |
| Warning | 1261 | Row 6 doesn't contain data for all columns |
| Warning | 1261 | Row 6 doesn't contain data for all columns |
| Warning | 1261 | Row 6 doesn't contain data for all columns |
| Warning | 1261 | Row 6 doesn't contain data for all columns |
| Warning | 1261 | Row 6 doesn't contain data for all columns |
| Warning | 1261 | Row 6 doesn't contain data for all columns |
| Warning | 1261 | Row 6 doesn't contain data for all columns |
| Warning | 1261 | Row 6 doesn't contain data for all columns |
| Warning | 1265 | Data truncated for column 'id' at row 7    |
| Warning | 1261 | Row 7 doesn't contain data for all columns |
| Warning | 1261 | Row 7 doesn't contain data for all columns |
| Warning | 1261 | Row 7 doesn't contain data for all columns |
+---------+------+--------------------------------------------+
64 rows in set (0.00 sec)

mysql>
mysql> LOAD DATA LOCAL INFILE 'niagara_trips.csv' INTO TABLE niagara_trips;
Query OK, 1 row affected, 10 warnings (0.04 sec)
Records: 1  Deleted: 0  Skipped: 0  Warnings: 10

mysql> SHOW WARNINGS;
+---------+------+-----------------------------------------------------------------------------------+
| Level   | Code | Message                                                                           |
+---------+------+-----------------------------------------------------------------------------------+
' for column 'id' at row 1 | integer value: '?1,2011-07-16,A,48,0,0,,0,,0
| Warning | 1261 | Row 1 doesn't contain data for all columns                                        |
| Warning | 1261 | Row 1 doesn't contain data for all columns                                        |
| Warning | 1261 | Row 1 doesn't contain data for all columns                                        |
| Warning | 1261 | Row 1 doesn't contain data for all columns                                        |
| Warning | 1261 | Row 1 doesn't contain data for all columns                                        |
| Warning | 1261 | Row 1 doesn't contain data for all columns                                        |
| Warning | 1261 | Row 1 doesn't contain data for all columns                                        |
| Warning | 1261 | Row 1 doesn't contain data for all columns                                        |
| Warning | 1261 | Row 1 doesn't contain data for all columns                                        |
+---------+------+-----------------------------------------------------------------------------------+
10 rows in set (0.00 sec)

mysql>

Open in new window


Now my question is, why am I getting '? before my 1?
0
 
Emin KrasniqiCommented:
Follow this instruction:

Go to the Import tab
Browse and select your CSV file
Instead of the “CSV” format, select “CSV using LOAD DATA”
In the “Fields terminated by” field, change “;” to “,”
Ensure that “Use LOCAL keyword” is selected
Click on “Go”
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.