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

0 vote302 views1 answer
Difference between min and max date sql
SQL
0 vote304 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote285 views1 answer
Display first three characters sql
SQL
1 vote314 views1 answer
Sqlite update from another table
SQL
12 votes295 views1 answer
Script to add new column in table sql
SQL
1 vote306 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
0 vote278 views1 answer
Systemverilog unique constraint unique values
SQL
24 votes303 views4 answers
Delete db postgres
SQL
0 vote314 views1 answer
Stored procedures example
SQL
0 vote279 views1 answer
Implicit inner join table alias with id values
SQL