How to Write a Loop in TiDB

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: tidb循环要怎么写

| username: Jjjjayson_zeng

【TiDB Usage Environment】Production Environment
【TiDB Version】
【Reproduction Path】
【Encountered Problem: Problem Phenomenon and Impact】Don’t know how to write a TiDB loop, hoping for an example from experts
【Resource Configuration】
【Attachments: Screenshots/Logs/Monitoring】

2
| username: tidb菜鸟一只 | Original post link

Write a loop from the host level, like this:

for i in `seq 10000`; do 
  mysql -uroot -h 10.10.10.16 -P4000 -pxxxxxx -e "insert into test.t1 values($i, floor(rand()*10000000))"; 
done;

Use backticks for seq 10000.

3
| username: Jjjjayson_zeng | Original post link

How to write loop data results?

4
| username: xingzhenxiang | Original post link

for i in seq 10; do echo “insert into test.t1 values($i,floor(rand()*10000000))”; done;

1688626943533
16886269435331234×215 20 KB

5
| username: xingzhenxiang | Original post link 
for i in `seq 10`; do
  exec_sql="insert into test.t1 values($i,floor(rand()*10000000))"
  mysql -uroot -h 10.10.10.16 -P4000 -pxxxxxx --comments -e "${exec_sql}"
done;
6
| username: cassblanca | Original post link

Currently, it can only be supported through external scripts.

7
| username: tidb菜鸟一只 | Original post link

More complex requirements can be written using shell scripts.

8
| username: Jjjjayson_zeng | Original post link

What I mean is whether there is something similar to MySQL while or stored procedures.

9
| username: Jjjjayson_zeng | Original post link

I want to write an SQL right now.

10
| username: 有猫万事足 | Original post link

Currently, stored procedures are not supported.
Use shell or python instead.

11
| username: tidb菜鸟一只 | Original post link

TiDB does not support stored procedures. Currently, this can only be achieved through shell, or Java, Python, etc. It cannot be done purely with SQL.

12
| username: cassblanca | Original post link

TiDB currently does not support Procedures, UDF functions, etc. You can achieve your needs through scripting languages like Shell, Perl, Python. I believe that in the future, the stored procedure and function features will be improved, and Ti/SQL (similar to Oracle PL/SQL) might be introduced as well. :smiley:

13
| username: zhanggame1 | Original post link

Awesome, I really don’t know how to do this. How about using Python to write it?

14
| username: redgame | Original post link

Use external scripts.

15
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.