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

15 votes147 views2 answers
Open postgress in terminal mac
SQL
0 vote149 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
0 vote151 views1 answer
Create table in dbms cmds
SQL
0 vote139 views1 answer
Oracle index hint
SQL
0 vote144 views1 answer
Delete record by id sql
SQL
13 votes155 views5 answers
Sql default
SQL
0 vote177 views1 answer
Copy row from db to db mysql
SQL
0 vote133 views1 answer
Stuff in sql server
SQL
1 vote147 views2 answers
Get table column names sql laravel
SQL
0 vote142 views1 answer
Eliminar ultimo carcacter mysql
SQL