▶ C'mon over to https://realpars.com
where you can learn PLC programming faster and easier than you ever thought possible!
▶ Check out the full blog post over at https://realpars.com/mysql/
For the subsequent SQL lesson series that we are going to cover, you may want to install MySQL to follow along with the instructor.
MySQL is an open-source software; this means the software is free to most end-users.
MySQL does offer a commercial license for more advanced database requirements.
First, check to see if your computer is compatible to run MySQL.
The MySQL has a very easy to use installer to help the user download and install all the MySQL options.
There are two options, to download the installer file. If you have an online connection while running the MySQL Installer, choose the mysql-installer-web-community file.
If you do NOT have an online connection while running the MySQL Installer, choose the mysql-installer-community file.
This is a larger file and contains most of the options required.
If you have any questions, MySQL installation documentation will help.
After a successful install, we open the MySQL Workbench. In the user interface environment, we import and run a script that has predefined our database.
This is advanced scripting, but don’t worry, the next few steps are easy to follow. Much of the scripting in this schema will be explained in additional lessons.
The query data can be exported to Microsoft Excel by left-clicking and selecting the “Export recordset to an external file” button.
Select the file format you prefer. For Microsoft Excel, choose “Excel Spreadsheet” file type.
Please stay tuned for future SQL lessons, soon to be released.
These lessons will provide basic and in-depth use of the SQL commands using MySQL and additional lessons on how to use this language in automation for analytical reporting, troubleshooting, and process development.
Review the MySQL minimum hardware requirement web page here: https://forums.mysql.com/read.php?11
Download the MySQL Installer: https://dev.mysql.com/downloads/installer/
Download the sample database SQL file from here: https://realpars.com/wp-content/uploads/2019/12/realparssampledatabasev2.zip
Missed our most recent videos? Watch them here:
To stay up to date with our last videos and more lessons, make sure to subscribe to this YouTube channel:
TWEET THIS VIDEO https://ctt.ac/g1laF
Like us on Facebook: https://www.facebook.com/therealpars/
Follow us on Twitter: https://twitter.com/realpars
Follow us on LinkedIn https://www.linkedin.com/company/realpars
Follow us on Instagram https://www.instagram.com/realparsdotcom/
#RealPars #Automation #SQL #MySQL