This article provides an introduction to MySQL along with a guide on creating a MySQL data output using Upsolver.
What is MySQL?
MySQL is an open-source relational database management system based on SQL (Structured Query Language).
A relational database organizes data into one or more data tables in which data types may be related to each other, and these relations help structure the data.
SQL is then used to create, modify and extract data from the relational database, as well as control user access to the database.
In addition to relational databases and SQL, MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups.
Create a MySQL data output
1. Go to the Outputs page and click New.
2. Select MySQL as your output type.
3. Name your output and select your Data Sources.
4. Select New to create a new table or Existing to output to an existing table. Then click Next.
If outputting to an existing table, complete the database options as prompted before clicking Next again.
If necessary, create a new MySQL connection.
10. Through the Filters tab, add a filter like WHERE in SQL to the data source.
11. Click Make Aggregated to turn the output into an aggregated output.
Read the warning before clicking OK and then add the required aggregation.
This aggregation field will then be added to the Schema tab.
12. In the Aggregation Calculated Fields area under the Calculated Fields tab, add any required calculated fields on aggregations.
See:Functions, Aggregation functions
Click Preview at any time to view a preview of your current output.