Today, the current issue of iX has published my article on transactions in MySQL. It’s a comprehensive and brief introduction to the topic. The text is written in German. To obtain it, you buy iX at a kiosk or in a fiew weeks online in the virtual kiosk.
Category MySQL
LinuxTag 2003: Kaj on MySQL and SAP DB
Just attended Kaj Arnö’s talk MySQL, SAP and the Enterprise. Kay explained the development process of merging SAP DB and MySQL. For the mediate future, a proxy will be integrated in the SAP DB client, which allows MySQL users to manage SAP DB via the MySQL clients like mysql, mysqldump, mysqlimport. In the long run, functionality will be added to MySQL that covers the functionality already provided by SAP DB (e.g. stored procedures, triggers, standardized error behaviour, …). At the end of this process, the “MySQL Enterprise” edition (this is not the official, but the working name) will incorporate the best from both worlds: MySQL robustness, ease of use, and SAP DB enterprise functionality.
It’s also good news that all the nice DB management GUIs available for SAP DB will then also work with MySQL.
UPDATE: MySQL has branded SAP DB MaxDB
MySQL: INSERT … SELECT with Same Table
The latest release MySQL 4.0.14 introduced a neat new feature:
[snip]
Enabled `INSERT’ from `SELECT’ when the table into which the records are inserted is also a table listed in the `SELECT’.
[/snip]
This means you can now issue a statement like
INSERT INTO table ( field ) SELECT field FROM table WHERE field = “data”;
which copies all records meeting the specified criteria to the same table.
The MySQL manual only states the behaviour previous to 4.0.14:
[snip]
The target table of the INSERT statement cannot appear in the FROM clause of the SELECT part of the query. (The problem is that the SELECT possibly would find records that were inserted earlier during the same run. When using subquery clauses, the situation could easily be very confusing.)
[/snip]
GIS Demo code available
The code and data for demonstrating MySQL 4.1’s new OpenGIS (geographic data) functionality is now available for download [1]. This demo has been demonstrated by Bar at the MySQL Users Conference [2].
[1] gd.tar.gz
[2] GIS session
Linux-Magazin Publishes MySQL Con Report
The German Linux Magazin published Sandro’s report from the first MySQL User Conference, which is also available online [1].
[1] http://www.linux-magazin.de/Artikel/ausgabe/2003/06/mysql/mysql.html
myxml User Defined Functions
Brian Aker from Slashdot announced [1] his new myxml User Defined Functions (UDF) for MySQL in the MySQL general mailinglist.
[1] http://marc.theaimsgroup.com/?l=mysql&m=104993600306514&w=2
Session at MySQL Conference, April 12
CEO Sandro Zic will talk about “MySQL in Peer-to-Peer Content Networks” at the MySQL Users Conference 2003 in San Jose/USA. The preliminary schedule of the conference is now online. Sandro will introduce CONESYS and have a close look at how MySQL handles high volumes of aggregated data.
Sandro Groganz 