Untitled

sigint-ignore                     FALSE
port                              0
prompt                            mysql>
quick                             FALSE
raw                               FALSE
reconnect                         TRUE
shared-memory-base-name           (No default value)
socket                            (No default value)
ssl                               FALSE
ssl-ca                            (No default value)
ssl-capath                        (No default value)
ssl-cert                          (No default value)
ssl-cipher                        (No default value)
ssl-key                           (No default value)
ssl-verify-server-cert            FALSE
table                             FALSE
user                              root
safe-updates                      FALSE
i-am-a-dummy                      FALSE
connect_timeout                   0
max_allowed_packet                16777216
net_buffer_length                 16384
select_limit                      1000
max_join_size                     1000000
secure-auth                       FALSE
show-warnings                     FALSE

C:\xampp\mysql\bin>mysql --user=root --password=Hoornbeeck12 --database=test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 72
Server version: 5.1.41 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>
mysql>  LOAD DATA INFILE 'C:\xampp\htdocs\testScript\text.txt' INTO TABLE testta
ble FIELDS TERMINATED BY ',' ( ID, voornaam, tussenvoegsel, achternaam, geb_datu
m, straat, nummer, postcode, woonplaats );
ERROR 29 (HY000): File 'C:xampphtdocs   estScript       ext.txt' not found (Errc
ode: 22)
mysql>  LOAD DATA INFILE 'C:\xampp\htdocs\testScript\text.txt' INTO TABLE testta
ble FIELDS TERMINATED BY ',' ( ID, voornaam, tussenvoegsel, achternaam, geb_datu
m, straat, nummer, postcode, woonplaats );
ERROR 29 (HY000): File 'C:xampphtdocs   estScript       ext.txt' not found (Errc
ode: 22)
mysql> LOAD DATA INFILE 'C:\xampp\htdocs\testScript\text.txt' INTO TABLE testtab
le FIELDS TERMINATED BY ',' ( ID, voornaam, tussenvoegsel, achternaam, geb_datum
, straat, nummer, postcode, woonplaats );
ERROR 29 (HY000): File 'C:xampphtdocs   estScript       ext.txt' not found (Errc
ode: 22)
mysql> LOAD DATA INFILE 'C:\xampp\htdocs\testScript\text.txt' INTO TABLE testtab
le FIELDS TERMINATED BY ',' (ID, voornaam, tussenvoegsel, achternaam, geb_datum,
 straat, nummer, nummer, postcode, woonplaats);
ERROR 29 (HY000): File 'C:xampphtdocs   estScript       ext.txt' not found (Errc
ode: 22)
mysql> LOAD DATA INFILE 'C:\xampp\htdocs\testScript\test.txt' INTO TABLE testtab
le FIELDS TERMINATED BY ',' ( ID, voornaam, tussenvoegsel, achternaam, geb_datum
, straat, nummer, postcode, woonplaats );
ERROR 29 (HY000): File 'C:xampphtdocs   estScript       est.txt' not found (Errc
ode: 22)
mysql> LOAD DATA INFILE 'test.txt' INTO TABLE testtable FIELDS TERMINATED BY ','
 ( ID, voornaam, tussenvoegsel, achternaam, geb_datum, straat, nummer, postcode,
 woonplaats );
ERROR 29 (HY000): File 'C:\xampp\mysql\data\test\test.txt' not found (Errcode: 2
)
mysql> LOAD DATA INFILE './test.txt' INTO TABLE testtable FIELDS TERMINATED BY '
,' ( ID, voornaam, tussenvoegsel, achternaam, geb_datum, straat, nummer, postcod
e, woonplaats );
Query OK, 215 rows affected, 1935 warnings (0.00 sec)
Records: 215  Deleted: 0  Skipped: 0  Warnings: 1720

mysql> SHOW WARNINGS
    -> SHOW WARNINGS;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'SHOW
WARNINGS' at line 2
mysql> SHOW WARNINGS;
+-------+------+----------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------+
| Level | Code | Message

                 |
+-------+------+----------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------+
| Error | 1064 | You have an error in your SQL syntax; check the manual that cor
responds to your MySQL server version for the right syntax to use near 'SHOW WAR
NINGS' at line 2 |
+-------+------+----------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------+
1 row in set (0.00 sec)

mysql> LOAD DATA INFILE './test.txt' INTO TABLE testtable FIELDS TERMINATED BY '
,' ( ID, voornaam, tussenvoegsel, achternaam, geb_datum, straat, nummer, postcod
e, woonplaats );
Query OK, 215 rows affected, 1935 warnings (0.00 sec)
Records: 215  Deleted: 0  Skipped: 0  Warnings: 1720

mysql> SHOW WARNINGS;
+---------+------+--------------------------------------------------------------
--------------------------------------------------------------------------------
--------+
| Level   | Code | Message

        |
+---------+------+--------------------------------------------------------------
--------------------------------------------------------------------------------
--------+
| Warning | 1366 | Incorrect integer value: 'ID;Voornaam;Tussenvoegsel;Achternaa
' for column 'ID' at row 1               |ats;
| 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 | 1366 | Incorrect integer value: 'ADA01191962;T.J.;;ADAMSE;01-19-1962
' 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 | 1366 | Incorrect integer value: 'Alb09291920;Anna Willems;van;Alblas
' 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 | 1366 | Incorrect integer value: 'Ann08241921;Vincent;;Annocque;08-24
' 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 | 1366 | Incorrect integer value: 'Arc08101922;Jan Claesz;;Arckenbout;
' for column 'ID' at row 5   |traat;86;3791 AL;ACHTERVELD;
| 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 | 1366 | Incorrect integer value: 'Asp02011924;Jacomina Gijsberts;van;
' for column 'ID' at row 6 |aunstraat;29;3791 VX;ACHTERVELD;
| 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 | 1366 | Incorrect integer value: 'BAC11021962;M.;;BACKX;11-02-1962;H.
' 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

        |
| 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

        |
| Warning | 1261 | Row 7 doesn't contain data for all columns

        |
| Warning | 1261 | Row 7 doesn't contain data for all columns

        |
| Warning | 1366 | Incorrect integer value: 'Bag07251926;Johannes;;Bagelaar;07-2
' for column 'ID' at row 8         |1 VM;ACHTERVELD;
+---------+------+--------------------------------------------------------------
--------------------------------------------------------------------------------
--------+
64 rows in set (0.00 sec)

mysql>