插入数据库名称的循环

import pymysql

# 假设有一个数据库名称列表
database_names = ['db1', 'db2', 'db3']

# 连接数据库
conn = pymysql.connect(host='localhost', user='root', password='password')

# 创建游标对象
cursor = conn.cursor()

# 循环插入数据库名称
for name in database_names:
    # 构造插入数据库名称的SQL语句
    sql = "INSERT INTO database_table (name) VALUES ('{}')".format(name)
    
    # 执行SQL语句
    cursor.execute(sql)

# 提交事务
conn.commit()

# 关闭游标和连接
cursor.close()
conn.close()

-- 假设有一个数据库名称列表
DECLARE @database_names TABLE (name VARCHAR(50))
INSERT INTO @database_names VALUES ('db1'), ('db2'), ('db3')

-- 循环插入数据库名称
DECLARE @name VARCHAR(50)
DECLARE @sql VARCHAR(MAX)

DECLARE db_cursor CURSOR FOR
SELECT name FROM @database_names

OPEN db_cursor
FETCH NEXT FROM db_cursor INTO @name

WHILE @@FETCH_STATUS = 0
BEGIN
    -- 构造插入数据库名称的SQL语句
    SET @sql = 'INSERT INTO database_table (name) VALUES (''' + @name + ''')'
    
    -- 执行SQL语句
    EXEC(@sql)
    
    FETCH NEXT FROM db_cursor INTO @name
END

CLOSE db_cursor
DEALLOCATE db_cursor