I have a CSV file that I need to load into a MySQL table on a scheduled cron (in a .php or .sh file, I think). I need to remove all quotation marks in the table and am having trouble doing so.
I’ve tried the following:
$query = “UPDATE tbl1 SET variable_1 = REPLACE(variable_1,'”‘,”)”;
$result = mysql_query($query);
But I get a parse error: “syntax error, unexpected T_CONSTANT_ENCAPSED_STRING”
I’ve also tried removing the quotes when I load the file:
use $DBNAME;truncate table…
