$post = mysql_query("LOAD DATA LOCAL INFILE
'/home/hostname/database/category.txt' INTO
TABLE products_to_categories FIELDS TERMINATED BY '|'
(products_id,categories_id)";
Is there any way I can use this query for a file that has fields terminated by a tab rather than '|'?
Does anyone know the character used for tab delimited fields?
Much Thanks!