Witam
Mam przykładowo baze:
mysql> select database();
+------------+
| database() |
+------------+
| dzis |
+------------+
1 row in set (0.00 sec)
------------------------------------------------------------------------
mysql> show tables;
+----------------+
| Tables_in_dzis |
+----------------+
| dane2 |
+----------------+
1 row in set (0.00 sec)
------------------------------------------------------------------------
mysql> describe dane2;
+----------+-------------+------+-----+------------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+------------+-------+
| imie | varchar(50) | NO | | NULL | |
| nazwisko | varchar(50) | NO | | NULL | |
| email | varchar(50) | YES | | NULL | |
| ulica | varchar(30) | YES | | NULL | |
| miasto | varchar(40) | YES | | NULL | |
| data_ur | date | YES | | 0000-00-00 | |
+----------+-------------+------+-----+------------+-------+
6 rows in set (0.02 sec)
mam tez plik dane.txt (znajduje sie ogolenei na dysku c:\danetxt)
zawartosc tego pliku to:
Stefan Kawa k@op.pl Polna Warszawa 1999-02-02
Marek Edza e@o.pl Sienna Warszawa 1958-03-05
Ewa Knaz e@op.pl Marszalka Warszawa 1948-02-07
-----------------------------------------------------------------------------------
Chiałbym dane z tego pliku zassac do dane2
co robie zle bo wpisuje komende {load data local infile ”c:\dane.txt” into table dane2;}
i otrzymuje
ERROR 2 (HY000): File 'c:dane.txt' not found (Errcode: 2)