I am unable to produce your errors...
Code: Select all
# ---------- MdbToMySQL XP 0.9 MySQL IMPORT FROM `C:\Documents and Settings\Owner\Desktop\Punten.mdb` ----------
# ---------- DROP TABLE `Table1` BEFORE (RE)CREATION ----------
DROP TABLE IF EXISTS `Table1`;
# ---------- CREATE TABLE `Table1` ----------
CREATE TABLE `Table1` (
`ID` INT NOT NULL AUTO_INCREMENT,
`Naam` VARCHAR(255) NULL,
`Toets_Hsft_1` VARCHAR(255) NULL,
`Toets_Hsft_2` INT NULL,
`Toets_Hsft_3` INT NULL,
`HSFT_4` INT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM;
# ---------- EMPTY TABLE `Table1` ----------
DELETE FROM `Table1`;
# ---------- POPUPLATE TABLE `Table1` ----------
INSERT INTO `Table1` (`ID`, `Naam`, `Toets_Hsft_1`, `Toets_Hsft_2`, `Toets_Hsft_3`, `HSFT_4`) VALUES (2, 'Calvin', '6', 8, 5, 5);
INSERT INTO `Table1` (`ID`, `Naam`, `Toets_Hsft_1`, `Toets_Hsft_2`, `Toets_Hsft_3`, `HSFT_4`) VALUES (3, 'Jenna', '6', 4, 4, 2);
INSERT INTO `Table1` (`ID`, `Naam`, `Toets_Hsft_1`, `Toets_Hsft_2`, `Toets_Hsft_3`, `HSFT_4`) VALUES (4, 'Puri', '4', 8, 6, 8);
INSERT INTO `Table1` (`ID`, `Naam`, `Toets_Hsft_1`, `Toets_Hsft_2`, `Toets_Hsft_3`, `HSFT_4`) VALUES (5, 'Wakamoli', '8', 9, 8, 6);
INSERT INTO `Table1` (`ID`, `Naam`, `Toets_Hsft_1`, `Toets_Hsft_2`, `Toets_Hsft_3`, `HSFT_4`) VALUES (6, 'yakuma', '9', 4, 5, 4);
INSERT INTO `Table1` (`ID`, `Naam`, `Toets_Hsft_1`, `Toets_Hsft_2`, `Toets_Hsft_3`, `HSFT_4`) VALUES (7, 'Gizaki', '2', 5, 8, 5);
INSERT INTO `Table1` (`ID`, `Naam`, `Toets_Hsft_1`, `Toets_Hsft_2`, `Toets_Hsft_3`, `HSFT_4`) VALUES (8, 'Mankala', '3', 6, 10, 2);
# ---------- END OF IMPORT FROM `C:\Documents and Settings\Owner\Desktop\Punten.mdb` ----------
Code: Select all
Array
(
[0] => Array
(
[0] => DROP TABLE IF EXISTS `Table1`;
[1] => CREATE TABLE `Table1` (
`ID` INT NOT NULL AUTO_INCREMENT,
`Naam` VARCHAR(255) NULL,
`Toets_Hsft_1` VARCHAR(255) NULL,
`Toets_Hsft_2` INT NULL,
`Toets_Hsft_3` INT NULL,
`HSFT_4` INT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM;
[2] => DELETE FROM `Table1`;
[3] => INSERT INTO `Table1` (`ID`, `Naam`, `Toets_Hsft_1`, `Toets_Hsft_2`, `Toets_Hsft_3`, `HSFT_4`) VALUES (2, 'Calvin', '6', 8, 5, 5);
[4] => INSERT INTO `Table1` (`ID`, `Naam`, `Toets_Hsft_1`, `Toets_Hsft_2`, `Toets_Hsft_3`, `HSFT_4`) VALUES (3, 'Jenna', '6', 4, 4, 2);
[5] => INSERT INTO `Table1` (`ID`, `Naam`, `Toets_Hsft_1`, `Toets_Hsft_2`, `Toets_Hsft_3`, `HSFT_4`) VALUES (4, 'Puri', '4', 8, 6, 8);
[6] => INSERT INTO `Table1` (`ID`, `Naam`, `Toets_Hsft_1`, `Toets_Hsft_2`, `Toets_Hsft_3`, `HSFT_4`) VALUES (5, 'Wakamoli', '8', 9, 8, 6);
[7] => INSERT INTO `Table1` (`ID`, `Naam`, `Toets_Hsft_1`, `Toets_Hsft_2`, `Toets_Hsft_3`, `HSFT_4`) VALUES (6, 'yakuma', '9', 4, 5, 4);
[8] => INSERT INTO `Table1` (`ID`, `Naam`, `Toets_Hsft_1`, `Toets_Hsft_2`, `Toets_Hsft_3`, `HSFT_4`) VALUES (7, 'Gizaki', '2', 5, 8, 5);
[9] => INSERT INTO `Table1` (`ID`, `Naam`, `Toets_Hsft_1`, `Toets_Hsft_2`, `Toets_Hsft_3`, `HSFT_4`) VALUES (8, 'Mankala', '3', 6, 10, 2);
)
[1] => Array
(
[0] => DROP TABLE IF EXISTS `Table1`
[1] => CREATE TABLE `Table1` (
`ID` INT NOT NULL AUTO_INCREMENT,
`Naam` VARCHAR(255) NULL,
`Toets_Hsft_1` VARCHAR(255) NULL,
`Toets_Hsft_2` INT NULL,
`Toets_Hsft_3` INT NULL,
`HSFT_4` INT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM
[2] => DELETE FROM `Table1`
[3] => INSERT INTO `Table1` (`ID`, `Naam`, `Toets_Hsft_1`, `Toets_Hsft_2`, `Toets_Hsft_3`, `HSFT_4`) VALUES (2, 'Calvin', '6', 8, 5, 5)
[4] => INSERT INTO `Table1` (`ID`, `Naam`, `Toets_Hsft_1`, `Toets_Hsft_2`, `Toets_Hsft_3`, `HSFT_4`) VALUES (3, 'Jenna', '6', 4, 4, 2)
[5] => INSERT INTO `Table1` (`ID`, `Naam`, `Toets_Hsft_1`, `Toets_Hsft_2`, `Toets_Hsft_3`, `HSFT_4`) VALUES (4, 'Puri', '4', 8, 6, 8)
[6] => INSERT INTO `Table1` (`ID`, `Naam`, `Toets_Hsft_1`, `Toets_Hsft_2`, `Toets_Hsft_3`, `HSFT_4`) VALUES (5, 'Wakamoli', '8', 9, 8, 6)
[7] => INSERT INTO `Table1` (`ID`, `Naam`, `Toets_Hsft_1`, `Toets_Hsft_2`, `Toets_Hsft_3`, `HSFT_4`) VALUES (6, 'yakuma', '9', 4, 5, 4)
[8] => INSERT INTO `Table1` (`ID`, `Naam`, `Toets_Hsft_1`, `Toets_Hsft_2`, `Toets_Hsft_3`, `HSFT_4`) VALUES (7, 'Gizaki', '2', 5, 8, 5)
[9] => INSERT INTO `Table1` (`ID`, `Naam`, `Toets_Hsft_1`, `Toets_Hsft_2`, `Toets_Hsft_3`, `HSFT_4`) VALUES (8, 'Mankala', '3', 6, 10, 2)
)
)