user3353391
Reputation: 139
How to check if an entry already exists inside a table (SQL using Python)
I am new to this. I've established a connection to my Oracle database using cx_Oracle. Say that I have a table named "student" with the following infos: "name","age","student_number","adress". Now i'm looking into inserting another row to the table. How do I check if student_number 6 already exist? Thanks in advance!
Upvotes: 0
Views: 435
Answers (1)
bgusach
Reputation: 15165
I really recommend you to take a look at the basics of SQL...
SELECT * FROM "student" WHERE "student_number" = 6
Upvotes: 1
Related Questions
- SQLAlchemy: Check if object is already present in table
- check if duplicate value is being added to mysql table
- MySQLdb - Check if row exists Python
- Python - SQLAlchemy using exists() to check if data already in table?
- SQLite3 Python - Checking if an entry exists
- sqlite python if already exist?
- Python: How to check if an entry already exists in a sql database?
- How to check if record exists with Python MySQdb
- check if row exist in the table before adding it in SQL
- Trying to check if value already in MySQL DB