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

3 votes195 views2 answers
Write an SQL query to fetch details of employees whose name starts with an alphabet 'A' and contains 10 alphabets.
TypeScript
0 vote237 views1 answer
Use sample weights fit model multiclass
TypeScript
0 vote199 views1 answer
Windows domain add hosts file
TypeScript
0 vote208 views1 answer
Can blue jays tickets still be printed
TypeScript
0 vote189 views1 answer
Reading multiple objects from file in java
TypeScript
0 vote266 views1 answer
How to update firebase document field angular
TypeScript
0 vote213 views1 answer
Jane and the Frost Giants "c++"
TypeScript
0 vote224 views1 answer
From the three types of styling, which one is the most useful in terms of website optimization?
TypeScript
0 vote187 views1 answer
Go build could not read username
TypeScript
0 vote194 views1 answer
How to check if folder already exists in google drive python
TypeScript