Ufdjrw

false 'Security alert' from Google - every login generates mails from 'no-reply@accounts.google.com'

How was Lagrange appointed professor of mathematics so early?

What is the evidence that custom checks in Northern Ireland are going to result in violence?

How to make an animal which can only breed for a certain number of generations?

A journey... into the MIND

Does traveling In The United States require a passport or can I use my green card if not a US citizen?

What kind of equipment or other technology is necessary to photograph sprites (atmospheric phenomenon)

Can a Knight grant Knighthood to another?

Why does BitLocker not use RSA?

2 sample t test for sample sizes - 30,000 and 150,000

Weaponising the Grasp-at-a-Distance spell

Does Prince Arnaud cause someone holding the Princess to lose?

Trying to enter the Fox's den

Why do C and C++ allow the expression (int) + 4*5?

Assertions In A Mock Callout Test

Can gravitational waves pass through a black hole?

"Destructive force" carried by a B-52?

Im stuck and having trouble with ￢P ∨ Q Prove: P → Q

What could prevent concentrated local exploration?

Why aren't these two solutions equivalent? Combinatorics problem

How to leave only the following strings?

Can I take recommendation from someone I met at a conference?

Compiling and throwing simple dynamic exceptions at runtime for JVM

What is the ongoing value of the Kanban board to the developers as opposed to management

How to prepare a procedure stored in MySQL to export tables with a 'dynamic path'?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

1

I am creating a procedure stored in MySQL to export tables with a dynamic route, but when I execute "CALL export_data ('data2018', 'e: Datos.csv')" I get an error, it seems that the path must be between 'quotes' but I have no idea how to put those quotes to the '?' so that it does not stop being variable, hopefully someone can help me solve this problem, thanks

DELIMITER $$
CREATE PROCEDURE export_data (name VARCHAR(25), path VARCHAR(50))
BEGIN
 SET @tableName = name;
 SET @pathName = path;
 SET @q = CONCAT('SELECT AP,AM,Nom,DNI,Direc INTO OUTFILE ? FIELDS 
 TERMINATED BY "," LINES TERMINATED BY "n" FROM `',@tableName,'` 
 ORDER BY AP ASC');
 PREPARE stmt FROM @q;
 EXECUTE stmt USING @pathName;
 DEALLOCATE PREPARE stmt;
END $$
DELIMITER;

mysql

share|improve this question

asked Mar 9 at 2:49

Freddy Limachi OrtegaFreddy Limachi Ortega

63

add a comment | 

1

I am creating a procedure stored in MySQL to export tables with a dynamic route, but when I execute "CALL export_data ('data2018', 'e: Datos.csv')" I get an error, it seems that the path must be between 'quotes' but I have no idea how to put those quotes to the '?' so that it does not stop being variable, hopefully someone can help me solve this problem, thanks

DELIMITER $$
CREATE PROCEDURE export_data (name VARCHAR(25), path VARCHAR(50))
BEGIN
 SET @tableName = name;
 SET @pathName = path;
 SET @q = CONCAT('SELECT AP,AM,Nom,DNI,Direc INTO OUTFILE ? FIELDS 
 TERMINATED BY "," LINES TERMINATED BY "n" FROM `',@tableName,'` 
 ORDER BY AP ASC');
 PREPARE stmt FROM @q;
 EXECUTE stmt USING @pathName;
 DEALLOCATE PREPARE stmt;
END $$
DELIMITER;

mysql

share|improve this question

asked Mar 9 at 2:49

Freddy Limachi OrtegaFreddy Limachi Ortega

63

add a comment | 

I am creating a procedure stored in MySQL to export tables with a dynamic route, but when I execute "CALL export_data ('data2018', 'e: Datos.csv')" I get an error, it seems that the path must be between 'quotes' but I have no idea how to put those quotes to the '?' so that it does not stop being variable, hopefully someone can help me solve this problem, thanks

DELIMITER $$
CREATE PROCEDURE export_data (name VARCHAR(25), path VARCHAR(50))
BEGIN
 SET @tableName = name;
 SET @pathName = path;
 SET @q = CONCAT('SELECT AP,AM,Nom,DNI,Direc INTO OUTFILE ? FIELDS 
 TERMINATED BY "," LINES TERMINATED BY "n" FROM `',@tableName,'` 
 ORDER BY AP ASC');
 PREPARE stmt FROM @q;
 EXECUTE stmt USING @pathName;
 DEALLOCATE PREPARE stmt;
END $$
DELIMITER;

mysql

share|improve this question

asked Mar 9 at 2:49

Freddy Limachi OrtegaFreddy Limachi Ortega

63

DELIMITER $$
CREATE PROCEDURE export_data (name VARCHAR(25), path VARCHAR(50))
BEGIN
 SET @tableName = name;
 SET @pathName = path;
 SET @q = CONCAT('SELECT AP,AM,Nom,DNI,Direc INTO OUTFILE ? FIELDS 
 TERMINATED BY "," LINES TERMINATED BY "n" FROM `',@tableName,'` 
 ORDER BY AP ASC');
 PREPARE stmt FROM @q;
 EXECUTE stmt USING @pathName;
 DEALLOCATE PREPARE stmt;
END $$
DELIMITER;

share|improve this question

asked Mar 9 at 2:49

Freddy Limachi OrtegaFreddy Limachi Ortega

63

share|improve this question

asked Mar 9 at 2:49

Freddy Limachi OrtegaFreddy Limachi Ortega

63

asked Mar 9 at 2:49

Freddy Limachi OrtegaFreddy Limachi Ortega

63

asked Mar 9 at 2:49

Freddy Limachi OrtegaFreddy Limachi Ortega

63

1 Answer
1

active

oldest

votes

0

I prefer to use ascii character 39 where single quotes are needed. And I don't see the need for user defined variables.

drop procedure if exists p;

DELIMITER $$
CREATE PROCEDURE p (name VARCHAR(25), path VARCHAR(50))
BEGIN
 SET @q = CONCAT('SELECT AP,AM,Nom,DNI,Direc INTO OUTFILE ',char(39),path,char(39),' FIELDS 
 TERMINATED BY "," LINES TERMINATED BY "n" FROM ' ,char(39),name,char(39),
 ' ORDER BY AP ASC');
 select @q;

 # PREPARE stmt from @q;
 # EXECUTE stmt ;
 # DEALLOCATE PREPARE stmt;
END $$
DELIMITER ;

share|improve this answer

answered Mar 9 at 9:01

P.SalmonP.Salmon

8,2382515

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55073540%2fhow-to-prepare-a-procedure-stored-in-mysql-to-export-tables-with-a-dynamic-path%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

I prefer to use ascii character 39 where single quotes are needed. And I don't see the need for user defined variables.

drop procedure if exists p;

DELIMITER $$
CREATE PROCEDURE p (name VARCHAR(25), path VARCHAR(50))
BEGIN
 SET @q = CONCAT('SELECT AP,AM,Nom,DNI,Direc INTO OUTFILE ',char(39),path,char(39),' FIELDS 
 TERMINATED BY "," LINES TERMINATED BY "n" FROM ' ,char(39),name,char(39),
 ' ORDER BY AP ASC');
 select @q;

 # PREPARE stmt from @q;
 # EXECUTE stmt ;
 # DEALLOCATE PREPARE stmt;
END $$
DELIMITER ;

share|improve this answer

answered Mar 9 at 9:01

P.SalmonP.Salmon

8,2382515

add a comment | 

0

I prefer to use ascii character 39 where single quotes are needed. And I don't see the need for user defined variables.

drop procedure if exists p;

DELIMITER $$
CREATE PROCEDURE p (name VARCHAR(25), path VARCHAR(50))
BEGIN
 SET @q = CONCAT('SELECT AP,AM,Nom,DNI,Direc INTO OUTFILE ',char(39),path,char(39),' FIELDS 
 TERMINATED BY "," LINES TERMINATED BY "n" FROM ' ,char(39),name,char(39),
 ' ORDER BY AP ASC');
 select @q;

 # PREPARE stmt from @q;
 # EXECUTE stmt ;
 # DEALLOCATE PREPARE stmt;
END $$
DELIMITER ;

share|improve this answer

answered Mar 9 at 9:01

P.SalmonP.Salmon

8,2382515

add a comment | 

I prefer to use ascii character 39 where single quotes are needed. And I don't see the need for user defined variables.

drop procedure if exists p;

DELIMITER $$
CREATE PROCEDURE p (name VARCHAR(25), path VARCHAR(50))
BEGIN
 SET @q = CONCAT('SELECT AP,AM,Nom,DNI,Direc INTO OUTFILE ',char(39),path,char(39),' FIELDS 
 TERMINATED BY "," LINES TERMINATED BY "n" FROM ' ,char(39),name,char(39),
 ' ORDER BY AP ASC');
 select @q;

 # PREPARE stmt from @q;
 # EXECUTE stmt ;
 # DEALLOCATE PREPARE stmt;
END $$
DELIMITER ;

share|improve this answer

answered Mar 9 at 9:01

P.SalmonP.Salmon

8,2382515

drop procedure if exists p;

DELIMITER $$
CREATE PROCEDURE p (name VARCHAR(25), path VARCHAR(50))
BEGIN
 SET @q = CONCAT('SELECT AP,AM,Nom,DNI,Direc INTO OUTFILE ',char(39),path,char(39),' FIELDS 
 TERMINATED BY "," LINES TERMINATED BY "n" FROM ' ,char(39),name,char(39),
 ' ORDER BY AP ASC');
 select @q;

 # PREPARE stmt from @q;
 # EXECUTE stmt ;
 # DEALLOCATE PREPARE stmt;
END $$
DELIMITER ;

share|improve this answer

answered Mar 9 at 9:01

P.SalmonP.Salmon

8,2382515

answered Mar 9 at 9:01

P.SalmonP.Salmon

8,2382515

answered Mar 9 at 9:01

P.SalmonP.Salmon

8,2382515