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.
How to log in to your MySQL databases, find out the IP address for a database server if it is different from your webserver and how to use this information to log in successfully.
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 organize data in your database tables through reordering your columns, renaming your columns and saving custom views of the columns in your 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.
How the Table Manager maps column foreign keys and linked tables. Using this powerful tool, you can easily find every place in the database where a foreign key's value exists.
How our MySQL GUI Table Manager allows you to edit your data inline with advanced features like referential integrity through drop downs, and validation of data through our advanced column management.
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