How to check if an entry already exists inside a table (SQL using Python)

Question

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!

bgusach · Accepted Answer · 2014-03-18 20:23:55Z

1

I really recommend you to take a look at the basics of SQL...

SELECT * FROM "student" WHERE "student_number" = 6

answered Mar 18, 2014 at 20:23

bgusach

15.4k15 gold badges59 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3353391 Over a year ago

How do I do this in Python though?

Collectives™ on Stack Overflow

How to check if an entry already exists inside a table (SQL using Python)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related