This help document is a compilation of videos that take you through all the elements of this system. Click on the links below and videos will open showing you how to use that part of the system. Once the video is open, you can open the video in YouTube as well. It's that simple!
This is an introduction to our MySQL GUI tool suite: Enhanced mySQL Portal. I discuss how using our system, you can easily enforce data validation, custom sorting, filtering, queries, form creation, and overall database management. You don't need to be a MySQL guru to act like one anymore!
Learn basic system navigation in our MySQL GUI tools. I show you how to open specific tools, how to view organization trees, and data, and I also show you how to view large amounts of data and relationships.
Orient yourself on our desktop of our MySQL GUI Tools: Enhanced mySQL Portal (ESP). I show you how to open our different tools, how to change your password, lock your session, change the overall look of the system and other useful information.
The layout and general functionality of the Table Manager tool. You learn how to view all the tables in a database, how to view the data in a specific table, and how to view column properties in a table.
How to link a columns values to another table. This is generally called a foreign key, but we have made some valuable enhancements to this, allowing you to do things like: set select criteria for a drop down, set formatting for the column, and map the relationship between the value and its foreign key.
How to avoid the error when you are trying to upload data into a table and there is a foreign key on a record, and the value does not exist. Our MySQL GUI Table Manager lets you insert values from the uploaded information as well as static values into the parent table as you upload.
Upload data in CSV format into your database using the Table Manager. You learn how to customize the ordering, set behavior restrictions for when there are key violations and duplicate records, as well as many other options.
Create custom forms for entering new records, modifying records and viewing records in your database. You will learn how to easily code a form in html using our robust validation, user privileges and other functions to ensure your data is properly entered.
Use our MySQL GUI Query Browser to execute queries and scripts. You will also learn how to save and organize your queries for future reference as well as copy queries to be used and modified for other purposes