How to connect appication to MySql Database

Classic Servoy
1

Hi,

How can use MySql table for my application? I am a beginner and want to start working with Servoy but i want to use MySql as my database.

Please let me know.

Thanks,
Sejal

2

If I understand your question correctly you are asking how to work with MySQL.
I.e. how to create a database, tables, columns (fields).

I would suggest you take a look at some MySQL tools.
Although Servoy can create tables and columns it’s recommended you use the tools of the database to do your major database designing.

http://www.mysql.com/products/administrator/
and
http://www.mysql.com/products/query-browser/

Or maybe your question how to connect Servoy to MySQL.
Then you should already have a database created in MySQL.
After that you go to the Servoy preferences and the DB Servers tab-panel.
Here you can use the Auto Setup Server popup/combobox.
Select MySQL and Servoy will popup a new dialog with a template settings for you to edit.

Just change the Servername, Username, password and edit the Database Server URL. Then press OK and you are set.

Hope this helps.