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 vote328 views1 answer
Sql insert tuple
SQL
0 vote309 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
2 votes349 views2 answers
Postgres trigger insert into another table
SQL
5 votes358 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
0 vote347 views1 answer
Sql column contains special character
SQL
1 vote334 views1 answer
Blob datatype in mysql
SQL
1 vote334 views3 answers
SELECT * FROM
SQL
1 vote322 views1 answer
Sql list all procedures
SQL
4 votes336 views1 answer
Search column by name mysql
SQL
2 votes373 views2 answers
Mysql compare datetime to another datetime
SQL