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 vote288 views1 answer
Check if that inex exisits array c#
TypeScript
1 vote313 views1 answer
What are data points
TypeScript
0 vote256 views1 answer
Why do we use #Email in angular with ngmodel
TypeScript
0 vote296 views1 answer
Bibtex remove brackets in note field
TypeScript
0 vote269 views1 answer
How to send attachments to node mailer file not found
TypeScript
1 vote252 views1 answer
Firefox hsts clear
TypeScript
0 vote255 views1 answer
Typescript named return
TypeScript
1 vote293 views1 answer
Gets ents within range gmod lua
TypeScript
0 vote272 views1 answer
(Html.DevExtreme().FileUploader() dialogtrigger example
TypeScript
3 votes268 views3 answers
Ts enum
TypeScript