create file using mysql

Question

I've a problem with this code

    SELECT id_order,lastname,firstname,productName,productPrice
FROM _commandes
WHERE id_order=13
INTO OUTFILE 'C:\Documents and Settings\Stagiaire\Mes documents\Document\bonDeCommandes\No13.txt'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'

When I execute it on phpMyAdmin it doesn't create file but doesn't display error either. I'm in local and I would like to create a file for each order. Could you help me ?

Saroten · Accepted Answer · 2015-06-05 10:12:48Z

2

Need to put "/" instead of "\" in the path.

edited Jun 5, 2015 at 10:12

answered Jun 5, 2015 at 9:58

Saroten

2951 gold badge5 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Avinash Raj Over a year ago

You mean the \ present inside the file path?

Collectives™ on Stack Overflow

create file using mysql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related