Latest articles under MySQL category

Emulating nextval() function to get sequence in MySQL

There are times when auto increment is not sufficient. And there are times when what you need is actually a sequence. Unfortunately MySQL doesn’t have support for sequence. Having been working on PostgreSQL database as well, I found that it’s nextval() function is pretty nice. So in this article, I’d like to emulate (or implement) […]

Posted on February 8th, 2009 under MySQL  •  23 Comments

MySQL : Too many connection errors.

I was trying to connect to a MySQL server at work and I got connection fail “Too many connections”. Here’s the screen shot that I took using Navicat Lite client and Sequel Pro. I did Googling a bit and I found that most common problem is because MySQL has too many open client being connected […]

Posted on January 23rd, 2009 under MySQL  •  13 Comments

Querying database structure.

There are times when we want to query a database structure for a particular table name. Or you want to find which tables a particular column name is defined. Or in my case, I wanted to find all tables that has column A and column B defined … how do I do it? If you […]

Posted on January 15th, 2009 under MySQL  •  No Comments

MySQL Error Code 150

Error can’t create table … I was trying to add new table and alter another table to add new column and foreign key to the new table. Here’s basically what I had When I execute the code, I got an error message something like Error can’t create table … (errno: 150). It turned out that […]

Posted on January 8th, 2009 under MySQL  •  1 Comment

Page 2 of 212