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.
2. Click the 'Add New' bubble.
3. If this is your first table, you must navigate to the System Tools.
4. Navigate to the Table System Tools.
5. Click the 'Add New' bubble.
6. 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.
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.
9. 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.
