SQLite में parameterized query क्यों उपयोग करनी चाहिए?

Other Published Updated 0 Views Verified
SQLite में parameterized query क्यों उपयोग करनी चाहिए?
Looking for the latest Sarkari Result 2026 updates? Check the latest government exam results, merit lists and result updates on Sarkari Resultess.
Sarkari Resultess
Questions & Answers

Answer & Explanation

4 Answers
Verified

cursor.execute('SELECT * FROM users WHERE id=' + str(user_id))

cursor.execute('SELECT * FROM users WHERE id=' + str(user_id))
Additional Explanation
यह विकल्प सही समाधान नहीं है।
Sarkari Resultess
Editorial Answer 1
Verified Correct Answer

cursor.execute('SELECT * FROM users WHERE id = ?', (user_id,))

cursor.execute('SELECT * FROM users WHERE id = ?', (user_id,))
Additional Explanation
Parameterized queries SQL injection risk और quoting issues कम करती हैं।
Sarkari Resultess
Editorial Answer 2
Verified

replace SQL with string concatenation

replace SQL with string concatenation
Additional Explanation
यह विकल्प सही समाधान नहीं है।
Sarkari Resultess
Editorial Answer 3
Verified

f"SELECT * FROM users WHERE id = {user_id}"

f"SELECT * FROM users WHERE id = {user_id}"
Additional Explanation
यह विकल्प सही समाधान नहीं है।
Sarkari Resultess
Editorial Answer 4