I sometimes get asked by our customers what's a good way to find someone with skills in open source in general or MySQL in particular.  Often they're looking for a DBA or a developer to help out on a particular project.  Sometimes I get asked by our users what's a good way to get a job using MySQL.  Luckily, we have a solution for both these problems: the MySQL Job Forum.  Our forums cover a lot of technical topics, but there's also one section focused on jobs.  If you're trying to hire someone or if you're looking for a new opportunity using MySQL, this is a good place to post some information.  I've also seen a lot of postings on Craigslist, Monster and Hotjobs. 

And if you're interested in working at MySQL, we have a couple of dozen openings on our web site at …

I was getting bombarded with fake porno trackbacks, and I couldn’t find a way to get WordPress to shove them in my moderation queue, so I turned them off.

Let me know if you have any problems. I don’t know how to bulk edit existing posts to do this inside WordPress, so I fired up MySQL and manually disabled them via a SQL query. Hopefully, I didn’t break anything.

Hands up who's had an error message when they have issued an SQL statement with ; delimiter straight after they created a procedure, or had an error when they tried to create a procedure without first setting the delimiter. 1..2..3.."is that a hand or are you trying to swat a fly".. I imagine it's a fair few of you, in fact I know it's a fair few because over the past year or so it's one of the biggest things people have asked me about or have had when trying to create procedures. Not why have they made a mistake but why MySQL needs you to change the delimiter when creating stored routines (SQL/PSM).

When you think about it it's rather obvious, because lines are terminated with a semi-colon in SQL/PSM the MySQL command line client gets confused about what your trying to do. The delimiter needs to be changed so MySQL can tell the difference between straight SQL and SQL/PSM.

So what's the problem? Well there are two …

I've just come home visiting one of my Inter Access co-workers.

Barbara is a very capable Oracle Developer, Information Analyst and BI Consultant. She enjoys the craftmanship so much that she still finds time to help out friends managing their little IT solutions.

For example, one of her friends owns a sports clothing store. She built them an order entry system in that popular little Database by Microsoft known as Access.

As you might expect, the system has grown over time, and has had too little administrative attention. Now, it's about 30Mb of data. This may not seem much, until you try to run a query. Size really is a relative measure.

What's worse, the number of users has grown too. Again, it may not seem much, but five users that are …

In one of my previous blog posts I showed you the difference between the functions CURRENT_USER() and SESSION_USER() and promised to show you how to use them for auditing with triggers and what you have to watch out for when updating to MySQL 5.0.17. With this release now being just a few hours old, let's finally do that and set up a log that stores all the changes your users apply to a given table.

I'll use a pretty simple base table for the purpose of this article and will set up all the tables and triggers as user root@localhost.

CREATE TABLE t (
    t_id INT PRIMARY KEY AUTO_INCREMENT,
    v VARCHAR(32)
);

Now we need to create the table for auditing. In addition to all the columns from the base table it will usually contain additional columns for a time stamp, the operation performed on the base table …

Apart from corrupted data files and variations on that I don't remember being able to (repeatedly) having been able to crash MySQL for years. But today I could. Darn, I was looking forward to changing my production MyISAM tables using spatial keys to InnoDB. Not today I guess. :-)

update So that bug hasn't been fixed yet, but the busy bees at MySQL did fix another bug I submitted a while ago. Whee.

Comments

On a recent visit to O'Reilly I noticed a list of up coming books. There were the usual second edition of this and third edition of that, but among those was a book that looks like it will become a classic. MySQL Stored Procedure Programming is being written by Steven Feuerstein and Guy Harrison, I'll admit to not knowing much about Guy but I'm fully aware of Steven. For those that don't know Steven he's possible the worlds number one expert on Oracle's PL/SQL, having written a number of books which are seen as the standard by which we should all aim for.

I have all of Steven's Oracle books and if this MySQL book is even half as good as those it's going to be a great book. But it's not due for release until March 2006 and as we all know these things tend to have a habit of slipping a bit. But at $39.99 that at least gives us the time to save up the pocket money.

Today I needed to dump a table containing GIS data and I could not find a quick way of exporting such data into a WKT format. Since I had also some more small problem with my data, I called MySQL technical support (I have a MySQL Network account) and I got the small problem solved, but the dump seems to be still a pending issue.
If you are used to dump data often, you may know that mysqldump has two useful options: --hex-blob, which will dump binary data in hexadecimal format, and --compatible=target, which will adjust the dump format to the requested target. However, none of these options has any effect on GIS data. It is always dumped in binary format, hardly compatible with any other DBMS.

So I cooked up an alternative way of dumping such data.
First, I created a stored …

At the upcoming MySQL Users Conference, we will have a lot more exhibition space compared to last year. We also want to show off the extensive community activity with MySQL, so this is a neat opportunity.

We are looking for open source projects that use or extend MySQL, who want to present their project in the exhibition area of the conference. There may also be some presentation opportunity (like "lightning talks" perhaps), but that will depend on scheduling.

Primarily, we would like to hear from projects which are not backed/run by a company, because companies of course already have the opportunity to become a sponsor/exhibitor.

Also, note that the conference is in Santa Clara, California - while we can provide space, we are unable to fund everybody's …

At the upcoming MySQL Users Conference, we will have a lot more exhibition space compared to last year. We also want to show off the extensive community activity with MySQL, so this is a neat opportunity.

We are looking for open source projects that use or extend MySQL, who want to present their project in the exhibition area of the conference. There may also be some presentation opportunity (like "lightning talks" perhaps), but that will depend on scheduling.

Primarily, we would like to hear from projects which are not backed/run by a company, because companies of course already have the opportunity to become a sponsor/exhibitor.

Also, note that the conference is in Santa Clara, California - while we can provide space, we are unable to fund everybody's …