Python MySQL Limit

Copy
# import connector class from mysql module.
import mysql.connector as myconn
mydb = myconn.connect(
  host = 'localhost',
  user = 'root',
  password = '',
  database = 'python_db'
)
db_cursor = mydb.cursor()

# select only 2 records.
query = "SELECT * FROM users LIMIT 2"
db_cursor.execute(query)
rows = db_cursor.fetchall()
for row in rows : print(row)

Copy
#delete 5 records.
query = "DELETE FROM users WHERE last_name=%s LIMIT 5"
value = ('Singh', )
db_cursor.execute(query, value)

#update only 3 records.
query = "UPDATE users SET email = %s WHERE id=%s LIMIT 3"
set_value = ('changedEmail@gmail.com', 1)
db_cursor.execute(query, set_value)