Recipes

Select random records

fetch random rows in MySQL

Export a MySQL table / database

how to export a MySQL database or table using mysqldump

How to split InnoDB file

Manage your InnoDB files

Cloning a MySQL table with data and indexes

Copy a MySQL table including its data and indexes

Find duplicate table records

get a list of records with duplicates using a MySQL SQL query

Select today's MySQL records

get a list of records creating today

Get list of tables in MySQL database


Display result of command line query vertically

vertical output of your MySQL query when executing it from the console

Concatenate multiple rows into a single field

use MySQL aggregation to combine multiple rows into a single cell

Show MySQL table columns

get a list of table columns using a MySQL query

Batch insert rows into MySQL table

use batch queries for faster insert's in your MySQL system

Compressing MySQL database dump

easily compress MySQL backup dumps using the linux shell

Import a compressed database dump

how to import a compressed MySQL dump with a single command

Create database dump without locking any tables

avoid table locks when creating a database dump file

Find last day and length of month

get last day of month using a SQL query

Monitoring active MySQL queries

what queries is your MySQL database currently working on

MySQL table maintenance

how to keep your MySQL tables in a good condition

Group by and strict ONLY_FULL_GROUP_BY mode

potential problem caused by MySQL strict mode ONLY_FULL_GROUP_BY

Querying table with a date range

common mistake when querying MySQL table using a date range

Find the database with the biggest size

find the biggest mysql database in your system with a simple query

Reset Auto Increment Value

how to reset the auto increment value of a table in MySQL

Saving a query result in a new table

save query result in a table

Creating views to get easy access to frequent queries

creating views to simplify access to query results

Concatenating strings

combining strings in a mysql query

Automated MySQL Backups

automated mysql backups using mysqldump


Comments

Display list of MySQL User Accounts

This table contains...
by Remo

9 months ago