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 vote250 views1 answer
Concat column value of same user in mysql
SQL
0 vote216 views1 answer
How to increase the width of the screen in oracle
SQL
7 votes213 views2 answers
Create mysql user
SQL
12 votes348 views2 answers
Find duplicates mysql column
SQL
1 vote212 views2 answers
T sql get foreign key
SQL
1 vote217 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
0 vote213 views1 answer
Implicit inner join table alias
SQL
0 vote202 views1 answer
Power query datetime to date
SQL
0 vote206 views1 answer
Not equal to blank in mysql
SQL
0 vote191 views1 answer
The local psql command could not be located
SQL