When I want to display some data in the web, the data need makeup, and I don't know how to achieve, here is the code:

from sqlalchemy import create_engine

engine = create_engine('mysql://root:111@localhost/test?charset=utf8')
conn = engine.connect()

articles = conn.execute('SELECT * FROM article')
articles = articles.fetchall()

for r in articles:
    r['Tags'] = r['Keywords']

It tips that: 'RowProxy' object does not support item assignment.

What should I do for that?

The table 'article' contains the column 'Keywords', and not contains the column 'Tags'.

python sqlalchemy
Edit
Report