Py sqlite if entry exists

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

Py sqlite if entry exists

-- Count entries in database
SELECT count(*);

-- Count rows in table
SELECT count(*) FROM peoples;
-- returns the number of rows in this table

-- Count rows with filter
SELECT count(*) FROM peoples WHERE age = 20;
-- returns the number of rows/peoples with an age of 20

-- If none (matching) row is in the specified
-- table it will return 0. So you can
-- check for "if (SQL_return >= 1)"

Source: stackoverflow.com

Similar codes

2 votes223 views2 answers
Sql percentage
SQL
0 vote234 views1 answer
How to set up an anonymous function to variable in swift
SQL
4 votes224 views1 answer
Is there any command to change postgres password
SQL
3 votes253 views1 answer
Mysql group_concat distinct
SQL
20 votes206 views2 answers
Counting in sql
SQL
12 votes213 views6 answers
Between in sql
SQL
0 vote214 views1 answer
Compression of dabatase mysqldumo
SQL
0 vote208 views1 answer
How to retrive the today date sql
SQL
1 vote213 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
2 votes211 views1 answer
Date conversion in mysql column
SQL