Welcome to collectivesolver - Programming & Software Q&A. A website you can trust. All programs tested and works. Contact: aviboots(AT)netvision.net.il
Bonsai Trees

Liquid Web Managed Dedicated Server: RAID 1 SSD with 16GB of RAM minimum! 24/7 On-Site Heroic Support! Industry-Leading SLA!

BlueHost Web Hosting

Ecommerce Software - Best Ecommerce Platform Made for You - Free Trial

Ecommerce Software - Best Ecommerce Platform Made for You - Free Trial

getflywheel wordpress hosting


Liquid Web Cloud VPS Hosting

8,956 questions

12,358 answers

573 users

How to get limited number of records start from position N with SQL in MySQL database using Python

1 Answer

0 votes
# c:\Users\user_nm\AppData\Local\Programs\Python\Python35-32\Scripts\pip install mysql-connector
    
import mysql.connector
    
db = mysql.connector.connect(
    host="localhost",
    user="root",
    passwd="",
    database="python_database"
)
   
db_cursor = db.cursor()

db_cursor.execute("SELECT * FROM workers LIMIT 3 OFFSET 1")

result = db_cursor.fetchall()

for row in result:
    print(row)

db.close()

 
'''
run:

(2, 'Aurora', 'C++ Programming')
(3, 'Amy', 'Python Programmer')
(4, 'Arthur', 'Java Programmer')

'''

 




answered 4 days ago by avibootz
...