Documentation and SupportV5 User Manual Creating Tables Using ConnectorsHow do I create a table using a MySQL Database Connector?

How do I create a table using a MySQL Database Connector?

1. Navigate to the Table(s) Tools.

If you have already created a table, the Table(s) icon will be available.

Navigate to the Table(s) Tools.

2. Click the 'Add New' bubble.

Click the 'Add New' bubble.

3. If this is your first table, you must navigate to the System Tools.

If this is your first table, you must navigate to the System Tools.

4. Navigate to the Table System Tools.

Navigate to the Table System Tools.

5. Click the 'Add New' bubble.

6. Enter the Table Data.

Enter the Table Data.

6.1. Name

Name of the Table (Max length is 44 characters and can not include a back tick [ ` ])

6.2. Description

Any information to help identify the use of this table can be typed here.

6.3. Disk

The Disk this table will be stored on. For most cases, this will be Default.

6.4. Folder

The folder the table will be under. You can use the [+] button to add a new folder.

6.5. Type

What type of table this will be. For MySQL, you'll want to choose 'From Connection'.

7. Enter the Schedule Details.

Enter the Schedule Details.

7.1. Connection

The connection used to create the table. We'll pick the MySQL Db Connection we created earlier.

7.2. Table Update Frequency

How often the table will pull new data. An option of 'Once' runs only the first time.

7.3. Table

Select which table you're pulling across from MySQL.

8. Select the Fields you wish to import.

Select the Fields you wish to import.

9. Add any necessary filters.

Add any necessary filters.

10. Verify the MySQL Statement.

If it is correct, click Save. If not, use the Back button to navigate to the appropriate screen and make any changes.

Verify the MySQL Statement.