Tag Archives: mysql

MySQL: Conditional Update

You learn something new every day. Here is a neat little SQL trick that I just learned. As usual, this post is mostly here for my future reference, and of course the overall good of the humankind. I hope someone … Continue reading

Posted in programming | Tagged , | 4 Comments

MySQL: Find Duplicate Entries in a Table

Here is a little background for this issue. The database used to run on ancient copy of MySQL until very recently we upgraded it to 5.0. Not without some headaches of migrating the database, but it worked. Common problem we … Continue reading

Posted in programming | Tagged , | 4 Comments

MySQL Admin 1.0.19: libmysqlx.dll Error

I noticed that on one of the servers the MySQL Admin was behaving weird. When you tried to inspect the schema of some tables by double clicking on it’s icon it would generate the following error: Access violation at address … Continue reading

Posted in sysadmin notes | Tagged , | Leave a comment