MySQL Tips

Home

Products

Community

Experts

Knowledge

Downloads

Hello, you are not logged in. Login or sign up

Knowledge >> Database Knowledge >> Database Tips >> MySQL Tips


		Tip Categories

MySQL Tips


		MySQL Tips

	The MySQL tips below have been submitted by users and Quest Experts. An original posting date denotes a tip that was previously published on the Quest Pipelines site. Do you have a tip you want to submit? Send it to us today!

MySQL Tips
All of the MySQL tips are displayed below...

Queries - Group the Resultset with GROUP BY
The most common use of GROUP BY is in conjunction with aggregating functions. These perform some operation on the values retrieved within each group (even though the individual values do not appear in the resultset). SUM() and COUNT() are commonly used aggregating functions, which add up items by group and count the number of items in each group, respectively. Read More...

Query Tuning - Slow Query Log
The slow query log records queries that run longer than some defined threshold value. It should never run in production as a rule. Rather, turn it on to diagnose a problem then turn it off. Read More...

Formatting Output in MySQL
MySQL can format data in two formats, the normal table format used when calling SQL statements from the MySQL command line, but also a vertical format. Read More...

MySQL Backup Script
This MySQL database shell script can be used to backup databases file /backup dir and later pick up w.ith your script Read More...

Upserting Records in MySQL
When using a database there are often times when we need to insert data into the database tables from external files or scripts. But what happens if the table you’re inserting to has its own unique updates or insert? Read More...

Enforcing NOT NULL in MySQL
When a column is defined as NOT NULL in the database, inserting a NULL value doesn't produce an error as you would expect. So, how do you enforce the NOT NULL constraint? Read More...

Case Sensitivity in MySQL
By default searches in MySQL are case insensitive. There are a couple of solutions you can use to enforce case sensitivity in MySQL. Read More...