Sometimes you would like to have a result set with something like a rownum. You can do this at least in the following two ways:

According to The IND-Network Cluster we are still in a race to deliver the first 2.6 SSI style cluster .. Hmm.. maybe I'd better try to catch up then .. I didn't know there was a race .. what can we win ? Please don't tell me it's yet another iPod that everyone promises but noone delivers .. or is it just eternal f(l)ame(s) ? :)

Our web team informed me that we received a few comments from users about MySQL AB supposedly shutting down the development of the MySQLFront utility. I?d just like to clarify that this was not the case at all ? we merely asked the developers to stop violating our trade mark as outlined in our Trade Mark Policy. As I wrote some time ago, our trade marks are a very important asset to us as a company and we need to take action, if our marks are being violated.

We did not ask or force them to stop the development or to remove the program from the market completely ? this was their very own decision. In fact, we actually encouraged them from the beginning of our discussion to continue the development of the product under a …

Our web team informed me that we received a few comments from users about MySQL AB supposedly shutting down the development of the MySQLFront utility. I?d just like to clarify that this was not the case at all ? we merely asked the developers to stop violating our trade mark as outlined in our Trade Mark Policy. As I wrote some time ago, our trade marks are a very important asset to us as a company and we need to take action, if our marks are being violated.

We did not ask or force them to stop the development or to remove the program from the market completely ? this was their very own decision. In fact, we actually encouraged them from the beginning of our discussion to continue the development of the product under a …

The T-SQL to MySQL procedure converter is of course developed based on what I needed when I made it. I have made it as a window's executable because we run the system on windows (guess that is common with SQL Server installations...). There is no fancy user interface (in fact no user interface at all) because I didn't need it etc.

T-SQL constructs not handled:

• String concatenation: since + is used in T-SQL both for concatenation strings and for addition you need to know the datatype of the arguments to know if it should be converted. The tool does no attempt to do this, even if some cases (text constants, declared variables or parameters) would be quite easy.
• GOTO's and labels: The code I converted contains a lot of GOTO's. A very common construction is: SELECT /UPDATE/DELETE/INSERT
  ....
  SELECT @p_err_num = @@ERROR
  IF (@p_err_num 0) GOTO OnError
  COMMIT TRANSACTION …

Despite Strong Demand, Survey Uncovers Significant Barriers to Adoption of Open Source Databases, Solid (Press Release)

Teradata Delivers Linux for Enterprise-Class Data Warehouses, Teradata (Press Release)

CollabNet Announces Enterprise Commercial Support, Training and Services for Subversion 1.4, CollabNet (Press Release)

Linux lab: GPL clarification needed ASAP, News.com, Stephen Shankland (Article)

…

I’ve bought plane tickets to the upcoming MySQL Camp in November. This is looking like a very fun time, with lots of community members, MySQL employees, and Google developers attending. It’s an “un-conference,” which means there is no set schedule, and it’s up to us to make out of the event whatever we wish it to be. If you’ve been reading my articles or using my tools, is there anything you’d like me to present on?

This key should give you a guide how to best tune you MySQL database systematically... It should also work similar for other RDBMS.

Maybe not breaking news, but I think it’s interesting enough of a point, and I didn’t really find anything about the topic when I googled it. If you do any addition, subtraction, multiplication, or division (and probably a lot more mathematical functions for that matter) and NULL is one of your values, the entire expression will evaluate to NULL.

For example, this statement returns NULL:

select 4 + NULL;

+———-+
| 4 + NULL |
+———-+
| NULL |
+———-+

Normally you wouldn’t do the above in such a simple way, for instance, you might do some addition in a subquery. For example,

select 4 + (select val from table1 WHERE id < 3 LIMIT 1);

+---------------------------------------------------+
| 4 + (select val from table1 WHERE id < 3 LIMIT 1) |
+---------------------------------------------------+
| NULL |
…