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 download our MySQL database management tool, and how to install it on your server, your local machine, and on a hosted server.
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 the tables in your database by creating custom names for viewing in the system and putting the tables in folders.
How to create a table in the ESP system. I detail primary key creation as well as location and reference issues.
How to modify a Table's properties. I detail how to change which column is your primary key and other settings.
How to copy a database table using the Table Manager. I show you how to copy a table's properties as well as its data.
How to delete tables from your database as well as organization folders for those tables.
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 create a column with basic properties, including naming, data types, formatting and validation.
How to manage advanced column properties regarding entry of data for the column in forms as well as how the column shows in tables.
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 set whether you will view a column when doing entry in a form, modifying of a form, viewing a record, or viewing a table.
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 to copy a column's properties as well as how to delete a column from your database using the Table Manager.
How to create foreign keys and indexes for your tables using the Table Manager.
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.
How to sort data in your database table, put a variety of filters on your table, and be able to update many records in a row at the same time.
How to export data from your database tables in both CSV and SQL scripting language using the Table Manager.
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.
How you can export a table and its data to another database using the Table Manager: .
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