python
import mycli
conn = mycli.connect(
host='localhost',
user='root',
password='password',
database='mydatabase'
)
cursor = conn.cursor()
cursor.execute("SELECT * FROM mytable WHERE column = 'value'")
results = cursor.fetchall()
for row in results:
print(row)
cursor.execute("SELECT * FROM mytable WHERE column = 'value' LIMIT 10")
results = cursor.fetchall()
for row in results:
print(row)
cursor.close()
conn.close()
