Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

Database News

Posted Oct 10, 2002

MySQL for Windows 4.0 Beta 4 Now Available

By DatabaseJournal.com Staff

Long promised by MySQL AB and long awaited by users, MySQL 4.0 is now available in beta version for download from http://www.mysql.com.

The main new features of MySQL 4.0 are geared towards existing business and community users, enhancing MySQL as a solution for mission-critical, heavy-load database systems. Other new features target the users of embedded databases.

MySQL 4.0 supports secure traffic between the client and the server, greatly increasing security against malicious intrusion and unauthorised access. The table handler InnoDB is now offered as a feature of the standard MySQL server, including full support for transactions, row-level locking and foreign key constraints. Additionally, multi-table DELETE statements and symbolic linking to MyISAM on the table level are supported in MySQL 4.0.

Features to simplify migration from other database systems to MySQL include support for TRUNCATE TABLE (as in Oracle) and IDENTITY as a synonym for automatically incremented keys (like in Sybase). Many users will also be happy to learn that MySQL now supports the UNION statement, a long awaited standard SQL feature.

MySQL 4.0 also further increases the speed of MySQL in a number of areas, such as bulk INSERTs, searching on packed indices, creation of FULLTEXT indices as well as COUNT(DISTINCT).

A complete list of new additions in v4.0 can be found at http://www.mysql.com/products/mysql-4.0/index.html.

A list of bug fixes in the latest beta release can be accessed at http://www.mysql.com/doc/N/e/News-4.0.x.html.

Finally, additional information for MySQL 4.0 (as well as download links) is available at http://www.mysql.com/.

Back to Database Journal Home

Database News Archives

Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM