Vim & Vision

You searched for articles tagged with MySQL.

[ #144 ] Random Rows from MySQL Permalink

MySQL Added less than a year ago

Here is a way to get some random rows from MySQL:

mysql> SELECT id FROM record ORDER BY RAND() LIMIT 5;

It is apparently slow, but works fine for one-offs.

[ #130 ] MySQL Case Insensitivity Permalink

MySQL, SQL Added less than a year ago

From the MySQL docs:

The default character set and collation are latin1 and latin1_swedish_ci, so nonbinary string comparisons are case insensitive by default.

... so if you were trying to do something like this:

SELECT * FROM thetable WHERE colname REGEXP '^[A-Z]';

... and you were wondering why you were getting back results where colname started with lowercase letters too, this is why! Try this instead:

SELECT * FROM thetable WHERE colname COLLATE latin1_bin REGEXP '^[A-Z]';

[ #95 ] MySQL Tuner Permalink

MySQL, Perl Added a year and a bit ago

I don't like MySQL, I would recommend PostGreSQL over it any day. However we are often forced to use things we don't like (for example at our workplaces!) so here is some info to help tune MySQL for speed:

MySQL Tuner is a Perl script that gives you a list of recommendations on settings to change. It seems easy and sensible! Just run it and it asks for user/pass settings and then gives you a little report.

(Nothing Older) ... (Nothing Newer)