Have a look at the sections "Dependencies" and "Connection strings" in the book chapter "The database abstraction layer"
You will need a db driver for your system (check if it's already installed): pymysql or MySQLdb Replace the uri string in DAL(...) with something like this mysql://username:password@localhost/test Then you can use the common web2py query commands as described in the same chapter. On Mar 5, 12:55 pm, Vijeenrosh PW Vijeen <[email protected]> wrote: > Hello , > greetings to all, > > Iam an new web2py user . Iam picking up the basics from the documetation > provided there . In those only SQLite in conjuction with the DAL is > explained . > Unfortunately I have to use MySQL as the database. > > could somebody point out how to use mysql in conjuction with DAL and how to > execute basic queries . > > Iam using Ubuntu 10.10 and have installed MySQL and the daemon(mysqld) is > running . > > what should I do to make an connection with DAL ? > > --------------------------- > Vijeenrosh PWwww.BlackJackVijeen.blogspot.com > Computer Science and Engineering , GEC Thrissur > kerala, India
