如何实现MySQL中查询数据的语句？

import mysql.connector

# 连接配置
config = {
  'user': 'your_username',
  'passWord': 'your_password',
  'host': 'localhost',
  'database': 'your_database_name',
  'raise_on_warnings': True
}

# 建立连接
connection = mysql.connector.connect(**config)

# 创建游标
cursor = connection.cursor()

# 执行查询语句
query = "SELECT * FROM your_table_name"
cursor.execute(query)

# 获取查询结果
results = cursor.fetchall()

# 遍历查询结果
for row in results:
    print(row)

# 关闭游标和连接
cursor.close()
connection.close()

# 创建游标
cursor = connection.cursor()

# 执行带查询条件的语句
query = "SELECT * FROM your_table_name WHERE column_name = %s"
value = ("your_value",)
cursor.execute(query, value)

# 获取查询结果
results = cursor.fetchall()

# 遍历查询结果
for row in results:
    print(row)

# 关闭游标和连接
cursor.close()
connection.close()

# 创建游标
cursor = connection.cursor()

# 执行带排序和限制的语句
query = "SELECT * FROM your_table_name ORDER BY column_name LIMIT 10"
cursor.execute(query)

# 获取查询结果
results = cursor.fetchall()

# 遍历查询结果
for row in results:
    print(row)

# 关闭游标和连接
cursor.close()
connection.close()