Python tool - create mysql query

https://www.online-python.com/

# Online Python - IDE, Editor, Compiler, Interpreter
a = ['L','M','S','XL','XXL','XXXL']
print ('insert into material (materialsubgroup_id,name,description,param,order_no) values ')
for i in range(355,370):
    k=0
    for j in range(len(a)):
        print("("+str(i)+",'"+a[j]+"','Dámská mikina Urban "+a[j]+"'"+",'"+a[j]+"',"+str(k) +"),")
        k=k+1

Rate this FAQ

0 (0 Votes)