Category: mysql

Changing MySQL clients default prompt

Changing MySQL clients default prompt

Although graphical clients are preferred when accessing MySQL databases, for many users the mysql command line client is the first choice when connecting to the MySQL server. And many times this is the only...

Sequence gaps in MySQL

Sequence gaps in MySQL

Auto-increment sequences are a common way to define a primary key in MySQL. This types of artificial keys, known as surrogate keys are commonly used by developers to quickly construct a database table. A...

Multi column sequences in MySQL

Multi column sequences in MySQL

One of the most common used attributes in MySQL is definitely AUTO_INCREMENT. This is quite helpful when one needs to generate unique identities for the table rows. By default when a AUTO_INCREMENT column is...

Generating test data for MySQL

Generating test data for MySQL

The most common type of web application a developer encounters are database related. But rarely is the case when you have the required data in your database during testing, making it a frequent source...