I try to save excel file as csv and import to phpMyAdmin: but excel says there will be some changes de to special char ...I save anyway .
well what is the FIELDS ENCLOSED BY value in the excel file ? How change this ? what is the default ?

Default FIELDS ENCLOSED BY  is "

this is syntax

SELECT fields INTO OUTFILE '/path/result.txt'
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
  LINES TERMINATED BY '\n'
  FROM test_table;


_________________
Thanks,
Muthukumar Selvarasu,
Project Manager,
Webmasters Ltd.

excel can export (configured) FIELDS ENCLOSED BY  ' or not, only " ?

Excel, CSV support both ' and "

but depends on your character settings and data.

if in case you have data like { ahh! father's achivement } ; now ' will give problem in excel, so better use "


_________________
Thanks,
Muthukumar Selvarasu,
Project Manager,
Webmasters Ltd.