参数化 SQL 脚本 [英] Parametrizing SQL script

问题描述

我必须做

SELECT column1,column2
INTO OUTFILE 'out_1.csv'
FROM table1
WHERE column1.name = '1'

SELECT column1,column2
INTO OUTFILE 'out_2.csv'
FROM table1
WHERE column1.name = '2'

SELECT column1,column2
INTO OUTFILE 'out_3.csv'
FROM table1
WHERE column1.name = '3'

等等...我认为这样做是个好主意:

and so on... I thought it was a good idea to do something like:

SELECT column1,column2
INTO OUTFILE 'out_$1.csv'
FROM table1
WHERE column1.name = $1

并通过 UNIX shell 脚本传递参数 $1.但也许有更好的方法.有一种 SQL本机"方式可以遍历 1 到 40 的范围?

and pass the parrameter $1 through a UNIX shell script. But maybe there's a better way. There is a SQL "native" way to iterate through a range from 1 to 40?

推荐答案

好的.您可以创建一个存储过程并使用 LOOP 或 WHILE.

Sure. You can create a stored procedure and use LOOP or WHILE.

这篇关于参数化 SQL 脚本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！