Quello che intendi tu ovvero i simboli (,;:...) scelti per copiare da
calc a csv e poi in Mysql non ci capisco più niente :(
Stufo della situazione mi sono messo a rifare da capo tutto quanto
usando una semplice tabella con Nome Data Numero Decimale, xx e numero
normale
trasformando da calc a csv il sistema che mi si avvicina di più alla
soluzione è questa:
'Nome ','data','numero','TEL'
'ALESSANDRO',12/02/2007,12.76,3486008326
'FRANCA',17/03/2007,19.25,22212222
'PAOLO',12/06/2006,13.25,11111111
Perchè le date e i numeri TEL non sono state inserite tra ''?
Se carico con importa con sql
Importazione eseguita con successo, 0 queries eseguite.
Se importo con CSV
Importazione eseguita con successo, 3 queries eseguite.
la risposta è:
Errore
Contatore di campo non valido nell'input CSV alla linea 1.
Se importo con CSV usando LOAD DATA ed inserendo:
Campo Terminato con ,
Campo Composto da '
ottengo
Testo completo
<http://localhost/phpmyadmin/sql.php?db=PROVA&table=prova&token=ff1b3057603fab3dd5002f345cbc64b5&sql_query=SELECT+%2A+FROM+%60prova%60&session_max_rows=30&pos=0&disp_direction=horizontal&repeat_cells=100&goto=tbl_properties_structure.php&dontlimitchars=1>
nome
<http://localhost/phpmyadmin/sql.php?db=PROVA&table=prova&token=ff1b3057603fab3dd5002f345cbc64b5&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2AFROM+%60prova%60++ORDER+BY+%60nome%60+ASC>
DATA
<http://localhost/phpmyadmin/sql.php?db=PROVA&table=prova&token=ff1b3057603fab3dd5002f345cbc64b5&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2AFROM+%60prova%60++ORDER+BY+%60DATA%60+ASC>
NUMERO
<http://localhost/phpmyadmin/sql.php?db=PROVA&table=prova&token=ff1b3057603fab3dd5002f345cbc64b5&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2AFROM+%60prova%60++ORDER+BY+%60NUMERO%60+ASC>
TELEFONO
<http://localhost/phpmyadmin/sql.php?db=PROVA&table=prova&token=ff1b3057603fab3dd5002f345cbc64b5&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2AFROM+%60prova%60++ORDER+BY+%60TELEFONO%60+ASC>
Modifica
<http://localhost/phpmyadmin/tbl_change.php?db=PROVA&table=prova&token=ff1b3057603fab3dd5002f345cbc64b5&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&primary_key=+CONVERT%28%60nome%60+USING+utf8%29+%3D+%27ALESSANDRO%27+AND+%60DATA%60+%3D+%270000-00-00%27+AND+CONCAT%28%60NUMERO%60%29+%3D+12.76+AND+CONCAT%28%60TELEFONO%60%29+%3D+3486008326&sql_query=SELECT+%2A+FROM+%60prova%60&goto=sql.php>
Cancella
<http://localhost/phpmyadmin/sql.php?db=PROVA&table=prova&token=ff1b3057603fab3dd5002f345cbc64b5&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=DELETE+FROM+%60prova%60+WHERE+CONVERT%28%60nome%60+USING+utf8%29+%3D+%27ALESSANDRO%27+AND+%60DATA%60+%3D+%270000-00-00%27+AND+CONCAT%28%60NUMERO%60%29+%3D+12.76+AND+CONCAT%28%60TELEFONO%60%29+%3D+3486008326+LIMIT+1&zero_rows=La+riga+%C3%A8+stata+cancellata&goto=sql.php%3Fdb%3DPROVA%26table%3Dprova%26token%3Dff1b3057603fab3dd5002f345cbc64b5%26pos%3D0%26session_max_rows%3D30%26disp_direction%3Dhorizontal%26repeat_cells%3D100%26dontlimitchars%3D0%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560prova%2560%26zero_rows%3DLa%2Briga%2B%25C3%25A8%2Bstata%2Bcancellata%26goto%3Dtbl_properties_structure.php>
ALESSANDRO 0000-00-00 12.76 3486008326
Modifica
<http://localhost/phpmyadmin/tbl_change.php?db=PROVA&table=prova&token=ff1b3057603fab3dd5002f345cbc64b5&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&primary_key=+CONVERT%28%60nome%60+USING+utf8%29+%3D+%27FRANCA%27+AND+%60DATA%60+%3D+%270000-00-00%27+AND+CONCAT%28%60NUMERO%60%29+%3D+19.25+AND+CONCAT%28%60TELEFONO%60%29+%3D+22212222&sql_query=SELECT+%2A+FROM+%60prova%60&goto=sql.php>
Cancella
<http://localhost/phpmyadmin/sql.php?db=PROVA&table=prova&token=ff1b3057603fab3dd5002f345cbc64b5&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=DELETE+FROM+%60prova%60+WHERE+CONVERT%28%60nome%60+USING+utf8%29+%3D+%27FRANCA%27+AND+%60DATA%60+%3D+%270000-00-00%27+AND+CONCAT%28%60NUMERO%60%29+%3D+19.25+AND+CONCAT%28%60TELEFONO%60%29+%3D+22212222+LIMIT+1&zero_rows=La+riga+%C3%A8+stata+cancellata&goto=sql.php%3Fdb%3DPROVA%26table%3Dprova%26token%3Dff1b3057603fab3dd5002f345cbc64b5%26pos%3D0%26session_max_rows%3D30%26disp_direction%3Dhorizontal%26repeat_cells%3D100%26dontlimitchars%3D0%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560prova%2560%26zero_rows%3DLa%2Briga%2B%25C3%25A8%2Bstata%2Bcancellata%26goto%3Dtbl_properties_structure.php>
FRANCA 0000-00-00 19.25 22212222
Modifica
<http://localhost/phpmyadmin/tbl_change.php?db=PROVA&table=prova&token=ff1b3057603fab3dd5002f345cbc64b5&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&primary_key=+CONVERT%28%60nome%60+USING+utf8%29+%3D+%27PAOLO%27+AND+%60DATA%60+%3D+%270000-00-00%27+AND+CONCAT%28%60NUMERO%60%29+%3D+13.25+AND+CONCAT%28%60TELEFONO%60%29+%3D+11111111&sql_query=SELECT+%2A+FROM+%60prova%60&goto=sql.php>
Cancella
<http://localhost/phpmyadmin/sql.php?db=PROVA&table=prova&token=ff1b3057603fab3dd5002f345cbc64b5&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=DELETE+FROM+%60prova%60+WHERE+CONVERT%28%60nome%60+USING+utf8%29+%3D+%27PAOLO%27+AND+%60DATA%60+%3D+%270000-00-00%27+AND+CONCAT%28%60NUMERO%60%29+%3D+13.25+AND+CONCAT%28%60TELEFONO%60%29+%3D+11111111+LIMIT+1&zero_rows=La+riga+%C3%A8+stata+cancellata&goto=sql.php%3Fdb%3DPROVA%26table%3Dprova%26token%3Dff1b3057603fab3dd5002f345cbc64b5%26pos%3D0%26session_max_rows%3D30%26disp_direction%3Dhorizontal%26repeat_cells%3D100%26dontlimitchars%3D0%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560prova%2560%26zero_rows%3DLa%2Briga%2B%25C3%25A8%2Bstata%2Bcancellata%26goto%3Dtbl_properties_structure.php>
PAOLO 0000-00-00 13.25 11111111
Se importo inserendo manualmente la formula sql seguente:
LOAD DATA INFILE "/home/alex/Desktop/PROVA.csv"
INTO TABLE prova
FIELDS
TERMINATED BY ','
ENCLOSED BY "'"
ESCAPED BY '\\'
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(nome, DATA, NUMERO, TELEFONO)
Mi trovo:
Righe inserite: 3 (La query ha impiegato 0.0054 sec)
query SQL: LOAD DATA INFILE "/home/alex/Desktop/PROVA.csv" INTO TABLE
prova FIELDS TERMINATED BY ',' ENCLOSED BY "'" ESCAPED BY '\\' LINES
TERMINATED BY '\n' IGNORE 1 LINES (
nome, DATA , NUMERO, TELEFONO
)
Testo completo
<http://localhost/phpmyadmin/sql.php?db=PROVA&table=prova&token=ff1b3057603fab3dd5002f345cbc64b5&sql_query=SELECT+%2A+FROM+%60prova%60&session_max_rows=30&pos=0&disp_direction=horizontal&repeat_cells=100&goto=tbl_properties_structure.php&dontlimitchars=1>
nome
<http://localhost/phpmyadmin/sql.php?db=PROVA&table=prova&token=ff1b3057603fab3dd5002f345cbc64b5&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2AFROM+%60prova%60++ORDER+BY+%60nome%60+ASC>
DATA
<http://localhost/phpmyadmin/sql.php?db=PROVA&table=prova&token=ff1b3057603fab3dd5002f345cbc64b5&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2AFROM+%60prova%60++ORDER+BY+%60DATA%60+ASC>
NUMERO
<http://localhost/phpmyadmin/sql.php?db=PROVA&table=prova&token=ff1b3057603fab3dd5002f345cbc64b5&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2AFROM+%60prova%60++ORDER+BY+%60NUMERO%60+ASC>
TELEFONO
<http://localhost/phpmyadmin/sql.php?db=PROVA&table=prova&token=ff1b3057603fab3dd5002f345cbc64b5&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2AFROM+%60prova%60++ORDER+BY+%60TELEFONO%60+ASC>
Modifica
<http://localhost/phpmyadmin/tbl_change.php?db=PROVA&table=prova&token=ff1b3057603fab3dd5002f345cbc64b5&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&primary_key=+CONVERT%28%60nome%60+USING+utf8%29+%3D+%27ALESSANDRO%27+AND+%60DATA%60+%3D+%270000-00-00%27+AND+CONCAT%28%60NUMERO%60%29+%3D+12.76+AND+CONCAT%28%60TELEFONO%60%29+%3D+3486008326&sql_query=SELECT+%2A+FROM+%60prova%60&goto=sql.php>
Cancella
<http://localhost/phpmyadmin/sql.php?db=PROVA&table=prova&token=ff1b3057603fab3dd5002f345cbc64b5&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=DELETE+FROM+%60prova%60+WHERE+CONVERT%28%60nome%60+USING+utf8%29+%3D+%27ALESSANDRO%27+AND+%60DATA%60+%3D+%270000-00-00%27+AND+CONCAT%28%60NUMERO%60%29+%3D+12.76+AND+CONCAT%28%60TELEFONO%60%29+%3D+3486008326+LIMIT+1&zero_rows=La+riga+%C3%A8+stata+cancellata&goto=sql.php%3Fdb%3DPROVA%26table%3Dprova%26token%3Dff1b3057603fab3dd5002f345cbc64b5%26pos%3D0%26session_max_rows%3D30%26disp_direction%3Dhorizontal%26repeat_cells%3D100%26dontlimitchars%3D0%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560prova%2560%26zero_rows%3DLa%2Briga%2B%25C3%25A8%2Bstata%2Bcancellata%26goto%3Dtbl_properties_structure.php>
ALESSANDRO 0000-00-00 12.76 3486008326
Modifica
<http://localhost/phpmyadmin/tbl_change.php?db=PROVA&table=prova&token=ff1b3057603fab3dd5002f345cbc64b5&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&primary_key=+CONVERT%28%60nome%60+USING+utf8%29+%3D+%27FRANCA%27+AND+%60DATA%60+%3D+%270000-00-00%27+AND+CONCAT%28%60NUMERO%60%29+%3D+19.25+AND+CONCAT%28%60TELEFONO%60%29+%3D+22212222&sql_query=SELECT+%2A+FROM+%60prova%60&goto=sql.php>
Cancella
<http://localhost/phpmyadmin/sql.php?db=PROVA&table=prova&token=ff1b3057603fab3dd5002f345cbc64b5&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=DELETE+FROM+%60prova%60+WHERE+CONVERT%28%60nome%60+USING+utf8%29+%3D+%27FRANCA%27+AND+%60DATA%60+%3D+%270000-00-00%27+AND+CONCAT%28%60NUMERO%60%29+%3D+19.25+AND+CONCAT%28%60TELEFONO%60%29+%3D+22212222+LIMIT+1&zero_rows=La+riga+%C3%A8+stata+cancellata&goto=sql.php%3Fdb%3DPROVA%26table%3Dprova%26token%3Dff1b3057603fab3dd5002f345cbc64b5%26pos%3D0%26session_max_rows%3D30%26disp_direction%3Dhorizontal%26repeat_cells%3D100%26dontlimitchars%3D0%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560prova%2560%26zero_rows%3DLa%2Briga%2B%25C3%25A8%2Bstata%2Bcancellata%26goto%3Dtbl_properties_structure.php>
FRANCA 0000-00-00 19.25 22212222
Modifica
<http://localhost/phpmyadmin/tbl_change.php?db=PROVA&table=prova&token=ff1b3057603fab3dd5002f345cbc64b5&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&primary_key=+CONVERT%28%60nome%60+USING+utf8%29+%3D+%27PAOLO%27+AND+%60DATA%60+%3D+%270000-00-00%27+AND+CONCAT%28%60NUMERO%60%29+%3D+13.25+AND+CONCAT%28%60TELEFONO%60%29+%3D+11111111&sql_query=SELECT+%2A+FROM+%60prova%60&goto=sql.php>
Cancella
<http://localhost/phpmyadmin/sql.php?db=PROVA&table=prova&token=ff1b3057603fab3dd5002f345cbc64b5&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=DELETE+FROM+%60prova%60+WHERE+CONVERT%28%60nome%60+USING+utf8%29+%3D+%27PAOLO%27+AND+%60DATA%60+%3D+%270000-00-00%27+AND+CONCAT%28%60NUMERO%60%29+%3D+13.25+AND+CONCAT%28%60TELEFONO%60%29+%3D+11111111+LIMIT+1&zero_rows=La+riga+%C3%A8+stata+cancellata&goto=sql.php%3Fdb%3DPROVA%26table%3Dprova%26token%3Dff1b3057603fab3dd5002f345cbc64b5%26pos%3D0%26session_max_rows%3D30%26disp_direction%3Dhorizontal%26repeat_cells%3D100%26dontlimitchars%3D0%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560prova%2560%26zero_rows%3DLa%2Briga%2B%25C3%25A8%2Bstata%2Bcancellata%26goto%3Dtbl_properties_structure.php>
PAOLO 0000-00-00 13.25 11111111
Perchè si mangia le date :::((((
Ho provato di tutto ;'""\\| e se sbaglio a indicare un campo mi scrive
la data completa perfettamente perchè non me la ved?
Aiuto, ma ne verrò fuori prima o poi.
Grazie per ogni aiuto
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
