Working with MySQL Stored Procedures
MySQL stored procedures are objects containing one or more SQL statements for reuse. They often contain business logic. Robert Sheldon demonstrates how to create and call stored procedures.
2022-05-04
MySQL
Working with MySQL Views
Views in MySQL allow you to save a predefined SQL query. Robert Sheldon explains the benefits of views and how to create and query them.
2022-04-04
Working with MySQL tables
After getting a new database in place, the next step is to create tables. In this article, Robert Sheldon walks you through creating tables with SQL Workbench and with scripts.
2022-03-21
Getting started with MySQL
The first step when getting started with MySQL is to get it installed and running. In this article, Robert Sheldon explains how to install it on Windows and create the first database and table.
2022-02-23
Using ADF to Upload Disparate CSV Files into Azure MySQL
In this article our objective is to showcase how to leverage Azure Data Factory (ADF) and a custom script to upload data in Azure MySQL database when we have CSV files with different schemas. As there is no straightforward way to upload data directly using ADF for this given scenario, it will actually help to […]
2021-03-04
2,575 reads
Transfer data from SQL Server to MySQL
In this article we look at how to use PowerShell to transfer data from SQL Server to MySQL.
2020-09-04
Using Five Types of JOIN in MYSQL
Learn how to use the different types of joins available in a MySQL database.
2019-11-05
Configuring a MySQL Database on Amazon RDS
Although concerns about ownership and security persist, many companies have embraced cloud services and are reaping substantial financial rewards as a result. Rob Gravelle describes the different cloud database categories, and shows us how to configure an Amazon RDS MySQL database.
2018-10-16
2,171 reads
Top 6 MySQL DBA Mistakes
To err is human, or so the saying goes. Unfortunately, in the world of IT, innocuous mistakes made early on can lead to really daunting problems down the road. In this article, Rob Gravelle goes over a few of the most common DBA mistakes to avoid. Some of these relate specifically to MySQL, while others may be applicable to any RDBMS.
2016-11-14
4,315 reads
Querying Multiple MySQL Tables
It’s been said that one of the drawbacks to normalization to the third form (3NF) is more cumbersome data extraction due to the greater number of tables. These require careful linking via JOIN clauses. Improper table joining can easily result in erroneous results or even in the dreaded Cartesian Product. In today’s article, Rob Gravelle explores how table joins are achieved in MySQL.
2016-09-23
3,720 reads
Blogs
Is Cataloging Your Data Important?
By Chris Yates
Data continues to be the lifeline for companies across the globe. As maturity levels...
Daily Coping 20 Mar 2023
By Steve Jones
Today’s coping tip is to get outside and notice how the weather feels. This...
Tales From The Field Weekly Wrap Up for the Week of 03-13-2023 & SQLBits 2023
By SQLBalls
Hello Dear Reader! What an incredible week we had. I started off traveling on...
Forums
Azure SQL - Restore to lower enviornment
Hello! Backups are automated for Azure SQL Prod environment, we can do point-in-time recovery...
Bcp queryout issue
Hi all, I am running the following query in SQL, trying to export some...
SQL Server RLS Database Users and Login User Permission
Please suggest practice on SQL Server RLS On the database level, defined users with...
Ask SSC