blocks|key|709252|text|如果你想要循环，你可以使用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|709253|for+i+in+($<file.csv)
do
++echo+-n+"$i+"
done|code-block|syntax|javascript|709254|echo的-n选项会取消换行符。|offset|length|style|CODE|709255|709256|您可以使用echo+$(<file.csv)在一行中打印整个文件。|709257|但这可能更适合您的需求：|709258|awk+'{+printf+$0+"+"+}+NR%251000+==+0+{+print+""+}'+file|709259|这将打印每一行，后跟一个空格。只要行号可以被1000整除，它就会打印一个换行符；也就是说，在每1000行之后。|709260|709261|添加:要打印括号中的每一行，您可以使用|709262|awk+'{+printf+$0+"+"+}+NR%251000+==+0+{+print+""+}'+file+%7C+sed+'s/.*/(&)/'|709263|sed命令搜索任何字符(.*)，并将它们替换为open-paren、找到的字符(即整行)和close-paren。|709264|entityMap^0|0|0|0|4|5|2|0|0|5|H|0|0|0|0|0|0|0|0|3|C|2|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|16|8|@$I|17|J|18|K|L]|$I|19|J|1A|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1C|8|@$I|1D|J|1E|K|L]]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1F|8|@]|9|@]|A|$]]|$1|R|3|S|5|D|7|1G|8|@]|9|@]|A|$E|F]]|$1|T|3|U|5|6|7|1H|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|1J|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|D|7|1K|8|@]|9|@]|A|$E|F]]|$1|10|3|11|5|6|7|1L|8|@$I|1M|J|1N|K|L]|$I|1O|J|1P|K|L]]|9|@]|A|$]]|$1|12|3|-4|5|6|7|1Q|8|@]|9|@]|A|$]]]|13|$]]

If you want the loop, you can use

<pre><code>for i in ($&lt;file.csv)
do
 echo -n "$i "
done
</code></pre>

The <code>-n</code> option to <code>echo</code> suppresses the newline.

<hr>

You can print the entire file in a single line with <code>echo $(&lt;file.csv)</code>.

But this may suit your needs better:

<pre><code>awk '{ printf $0 " " } NR%1000 == 0 { print "" }' file
</code></pre>

This will print each line followed by a space. It will print a newline whenever the line number is divisible by 1000; that is, after every 1000th line.

<hr>

Added: To print each line within parentheses, you can use

<pre><code>awk '{ printf $0 " " } NR%1000 == 0 { print "" }' file | sed 's/.*/(&amp;)/'
</code></pre>

The <code>sed</code> command searches for any characters (<code>.*</code>) and replaces them with an open-paren, the characters it found (that is, the entire line), and a close-paren.

blocks|key|709266|text|您可以执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|709267|echo+$(cat+file.csv)|code-block|syntax|javascript|709268|或|709269|cat+file.csv+%7C+xargs|709270|或者最后：|709271|$+cat+/tmp/l.csv
1;2;3;4;5;6
7;8;9;10;11
$+echo+$(<+/tmp/l.csv)
1;2;3;4;5;6+7;8;9;10;11
$+echo+$(cat+/tmp/l.csv)+%7C+perl+-pe+'s@(;%7C\n)@,@g'
1,2,3,4,5,6,7,8,9,10,11,
$+|709272|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

You can do :

<pre><code>echo $(cat file.csv)
</code></pre>

or 

<pre><code>cat file.csv | xargs
</code></pre>

or finally :

<pre><code>$ cat /tmp/l.csv
1;2;3;4;5;6
7;8;9;10;11
$ echo $(&lt; /tmp/l.csv)
1;2;3;4;5;6 7;8;9;10;11
$ echo $(cat /tmp/l.csv) | perl -pe 's@(;|\n)@,@g'
1,2,3,4,5,6,7,8,9,10,11,
$ 
</code></pre>

blocks|key|709921|text|看起来file.csv在单个列中包含了DataID。如果这是真的，您可以像这样生成查询，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|709922|echo+delete+FROM+Recordtable+WHERE+DataID+IN+$0$(cat+file.csv+%7C+tr+-cs+'[:digit:]'+',')0$\;|code-block|syntax|javascript|709923|因为文件只包含整数(DataID看起来是整数)，所以没有必要用单引号将它括起来。|709924|$+cat+data
123
241114
43243
35745
656
346+++456


$echo+delete+FROM+Recordtable+WHERE+DataID+IN+$0$(cat+data+%7C+tr+-cs+'[:digit:]'+',')0$\;
delete+FROM+Recordtable+WHERE+DataID+IN+(0,123,241114,43243,35745,656,346,456,0);|709925|在这里，0处理领先和落后的,。|offset|length|style|CODE|709926|entityMap^0|0|0|0|0|4|1|D|1|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|W|8|@$M|X|N|Y|O|P]|$M|Z|N|10|O|P]]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|R|$]]

It seems file.csv contains DataID in a single column. If thats true, you can generate the query like this,

<pre><code>echo delete FROM Recordtable WHERE DataID IN $0$(cat file.csv | tr -cs '[:digit:]' ',')0$\;
</code></pre>

As the file contains only integers (DataID seems int) so there is no need to enclose it by single quote.

<pre><code>$ cat data
123
241114
43243
35745
656
346 456


$echo delete FROM Recordtable WHERE DataID IN $0$(cat data | tr -cs '[:digit:]' ',')0$\;
delete FROM Recordtable WHERE DataID IN (0,123,241114,43243,35745,656,346,456,0);
</code></pre>

Here <code>0</code> deals with leading and trailing <code>,</code>s.

blocks|key|709934|text|BULK_DELETE_SQL=/tmp/bulkdelete.sql
rm+-f+${BULK_DELETE_SQL}
COMMIT_COUNT=0
COMMIT_LIMIT=1000
NUMLIST=""
COMMA=""
for+NUM+in+`cat+file.csv`+
do
++++NUMLIST="${NUMLIST}${COMMA}${NUM}"
++++COMMA=","
++++((+COMMIT_COUNT%2B%2B+))
++++if+[+${COMMIT_COUNT}+-eq+${COMMIT_LIMIT}+]
++++then
++++++++SQLSTMT="delete+FROM+Recordtable+WHERE+DataID+IN+(${NUMLIST});"
++++++++echo+${SQLSTMT}+>>+${BULK_DELETE_SQL}
++++++++NUMLIST=""
++++++++COMMA=""
++++++++COMMIT_COUNT=0
++++fi
done
if+[+${COMMIT_COUNT}+-gt+0+]
then
++++SQLSTMT="delete+FROM+Recordtable+WHERE+DataID+IN+(${NUMLIST});"
++++echo+${SQLSTMT}+>>+${BULK_DELETE_SQL}
fi
mysql+-u...+-p...+<+${BULK_DELETE_SQL}
rm+-f+${BULK_DELETE_SQL}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|709935|这将编写一个SQL脚本，该脚本将为每个DELETE语句创建1000个DataID。|unstyled|709936|它将只连接到mysql一次，并执行所有删除，一次1000个DataID。|709937|如果file.csv中有6247个DataID，那么最后一行应该有247个DataID|709938|如果file.csv中有247个DataID，那么唯一的一行应该有247个DataID|709939|试一试吧！|709940|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|R|8|@]|9|@]|A|$]]|$1|G|3|H|5|F|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|F|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|F|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|F|7|W|8|@]|9|@]|A|$]]]|P|$]]

<pre><code>BULK_DELETE_SQL=/tmp/bulkdelete.sql
rm -f ${BULK_DELETE_SQL}
COMMIT_COUNT=0
COMMIT_LIMIT=1000
NUMLIST=""
COMMA=""
for NUM in `cat file.csv` 
do
 NUMLIST="${NUMLIST}${COMMA}${NUM}"
 COMMA=","
 (( COMMIT_COUNT++ ))
 if [ ${COMMIT_COUNT} -eq ${COMMIT_LIMIT} ]
 then
 SQLSTMT="delete FROM Recordtable WHERE DataID IN (${NUMLIST});"
 echo ${SQLSTMT} &gt;&gt; ${BULK_DELETE_SQL}
 NUMLIST=""
 COMMA=""
 COMMIT_COUNT=0
 fi
done
if [ ${COMMIT_COUNT} -gt 0 ]
then
 SQLSTMT="delete FROM Recordtable WHERE DataID IN (${NUMLIST});"
 echo ${SQLSTMT} &gt;&gt; ${BULK_DELETE_SQL}
fi
mysql -u... -p... &lt; ${BULK_DELETE_SQL}
rm -f ${BULK_DELETE_SQL}
</code></pre>

This will write one SQL script that will create 1000 DataIDs per DELETE Statement.

It will only connect to mysql once and perform all the DELETEs, 1000 DataIDs at a time.

If there are 6247 DataIDs in file.csv, then the last line should have 247 DataIDs

If there are 247 DataIDs in file.csv, then the only line should have 247 DataIDs

Give it a Try !!!

blocks|key|4993638|text|您可以使用perl。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4993639|perl+-lne+'$a+.=+$_+}{+print+$a'+file.csv|code-block|syntax|javascript|4993640|-l将删除换行符，并将在print中添加一个换行符。-n将读取参数文件内容。请注意，如果文件中不存在添加的空格，您可以使用添加空格，例如$a+.=+"+$_"。|offset|length|style|CODE|4993641|我假设您将通过管道将此输入传送到某个位置，以执行SQL查询。我情不自禁地认为这可以用DBI做得更好。|4993642|entityMap|0|LINK|mutability|MUTABLE|url|http://search.cpan.org/perldoc?DBI^0|0|0|0|2|C|5|Q|2|1W|B|0|16|3|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@$I|Z|J|10|K|L]|$I|11|J|12|K|L]|$I|13|J|14|K|L]|$I|15|J|16|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|17|8|@]|9|@$I|18|J|19|1|1A]]|A|$]]|$1|O|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

You can use perl. 

<pre><code>perl -lne '$a .= $_ }{ print $a' file.csv
</code></pre>

<code>-l</code> will remove newlines, and will add a newline to the <code>print</code>. <code>-n</code> will read argument file contents. Be aware that if no added whitespace exists in the file, you may with to add it, e.g. <code>$a .= " $_"</code>.

I assume you are going to pipe this input somewhere to perform the SQL query. I can't help but think this could be better done with <a href="http://search.cpan.org/perldoc?DBI" rel="nofollow">DBI</a>.

blocks|key|709345|text|来自“仅仅因为”的回答学派：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|709346|tr+$'\n'+'+'+<+file.csv|code-block|syntax|javascript|709347|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

From the "just because" school of answering:

<pre><code>tr $'\n' ' ' &lt; file.csv
</code></pre>

I wish if someone can help me with this,

how can I print the output of for loop into single line? 

<pre><code>for i in `cat file.csv`
do
echo $i 
done
</code></pre>

what I'm trying to achieve here is to get a list of numbers from file.csv to generate a mysql bulk delete statement. 

<pre><code>delete FROM Recordtable WHERE DataID IN ('93041', '93031' ...etc);
</code></pre>

and the goal here is to load every 1000 records into one single delete statement 

Your help is highly appreciated

bash how to print for loop output into one line?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我希望如果有人能帮我，如何将for循环的输出打印到单行？for i in `cat file.csv`doecho $i done我在这里尝试实现的是从file.csv获取一个数字列表，以生成一条mysql批量删除语句。delete FROM Recordtable WHERE DataID IN ('93041', ...

问bash如何将循环输出打印到一行？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问bash如何将循环输出打印到一行？EN