MySQL

Using Five Types of JOIN in MYSQL

• by Additional Articles

• Database Journal

• MySQL

• Article

Learn how to use the different types of joins available in a MySQL database.

2019-11-05

Configuring a MySQL Database on Amazon RDS

• by Additional Articles

• Database Journal

• MySQL

• Article

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

• by Additional Articles

• Database Journal

• MySQL

• Article

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

• by Additional Articles

• Database Journal

• MySQL

• Article

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

Calculating MySQL Database, Table, and Column Sizes

• by Additional Articles

• Database Journal

• MySQL

• Article

Rob Gravelle demonstrates a sure-fire way to calculate how much disk space your MySQL data entities are taking up.

2016-07-12

2,667 reads

New MySQL Engine Supports T-SQL

• by Press Release

• SQLServerCentral.com

• MySQL

• Article

MySQL has a new query processor that will run your T-SQL code.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

3.89 (9)

Log in or register to rate

2016-04-01

1,308 reads

• Discuss

Top 10 MySQL Reporting Tools

• by Additional Articles

• Database Journal

• MySQL

• Article

Both management and various departments rely on data reports to help guide their business decisions. Rob Gravelle presents ten open source and commercial report generation tools for MySQL and other relational databases.

2016-01-11

4,964 reads

MySQL Pattern Matching using Regular Expressions

• by Additional Articles

• Database Journal

• MySQL

• Article

In this follow-up to Beyond the LIKE Operator: Advanced Pattern Matching with MySQL, Rob Gravelle shows how to use the REGEXP operator to match alphanumeric characters, explores the role of meta-characters, and compares standard regular expression syntax to that of MySQL.

2015-12-02

3,785 reads

Common MySQL Insert and Update Tasks and Their Solutions

• by Additional Articles

• Database Journal

• MySQL

• Article

Inserting and updating table contents with data from other tables and/or views within the same database need not be a nail-biting ordeal. Rob Gravelle shares some common Insert and Update tasks to help avoid any problems.

2015-09-25

2,820 reads

MySQL Error Handling using the Signal and Resignal Statements

• by Additional Articles

• Database Journal

• MySQL

• Article

MySQL introduced the SIGNAL and RESIGNAL statements in version 5.5 to allow you to raise your own error conditions from stored procedures, triggers, and events. Rob Gravelle demonstrates how to utilize both.

2015-08-17

2,032 reads