Re: [web2py] MySQL and web2py

[Vasile Ermicioi]

you need to define your models before using dal expressions

or you can execute raw sql

db = DAL('mysql://username:password@localhost/test')
list_of_dicts = db.executesql("SELECT * FROM mytable", as_dict=True)