If exits python sql

for name in ('bar','foo'): 
    cursor.execute("SELECT rowid FROM components WHERE name = ?", (name,))
    data=cursor.fetchall()
    if len(data)==0:
        print('There is no component named %s'%name)
    else:
        print('Component %s found with rowids %s'%(name,','.join(map(str, next(zip(*data))))))

Source: stackoverflow.com

Similar codes

0 vote200 views2 answers
Typescript to c# converter
TypeScript
3 votes196 views3 answers
How to clear known_hosts in ssh
TypeScript
0 vote198 views1 answer
How to specify output directory in TypeScript?
TypeScript
0 vote203 views1 answer
When to stop testing
TypeScript
0 vote281 views10 answers
Eval)free robux 2000
TypeScript
0 vote215 views1 answer
Using chai in typescript
TypeScript
13 votes220 views4 answers
Change checkbox jquery alert
TypeScript
0 vote203 views2 answers
Typescript encode url
TypeScript
1 vote214 views1 answer
Type 'CameraOriginal' is not assignable to type 'Provider'.
TypeScript
3 votes212 views1 answer
Mysql insert exists update
TypeScript