Re: FN-FORUM mysql client

date posted 28th June 2001 10:47

Quoting Rob Garbutt [EMAIL REMOVED]

> has anyone used mysql client?

Always.

> does anyone know how to import a comma delimited file into a mysql
> databse using this tool?

From the client you can do something like :

load data infile 'myfile.csv' into table tablename fields terminated by ',';

assuming you have "file" privileges on the server. If the server isn't the
local machine, you need to use

load data local infile ...

and you don't need file privileges to do that.

Alternatively, you can use mysqlimport.

James