How can I connect MySQL database with Onecity?

To connect your MySQL DB to Onecity, follow below mentioned steps:

Step 1: Add DB page in your Onecity App

Step 2: Delete existing records and fields from your Onecity DB page

Step 3: Goto My Apps>>DB>>Manage Table and create the same fields with the same name as in your MySQL database table

Step 4: Mark all the mandatory fields, whichever field's value is NOTNULL

Step 5: Mark all the fields that you want to show in the app, you can show upto 4 fields in your DB page

Step 6: Now export your MySQL table data in CSV format with field's name

Step 7: Goto My Apps>>DB>>Manage Record>>Import(CSV) and upload your CSV file