Untitled query #83305

SQL

import mysql.connector

conn = mysql.connector.connect(host="your_host", user="your_username", password="your_password", database="tewiki_p")
cursor = conn.cursor(dictionary=True)
cursor.execute("SELECT page_title AS Name, page_id AS Page_id, page_touched AS Publish_date FROM page WHERE page_namespace = 1 ORDER BY page_id DESC LIMIT 10;")
rows = cursor.fetchall()
for row in rows:
    print("Name:", row["Name"])
    print("Page ID:", row["Page_id"])
    print("Publish Date:", row["Publish_date"])
    print("--------------------")
cursor.close()
conn.close()
SQL

Checking query status...
