MySQL 4.1 Boosts SQL Compatibility | eWeek

MySQL 4.1 Boosts SQL Compatibility

Verfasst von
Timothy Dyck
Timothy Dyck
Feb 10, 2003
1 minute read
eWeek Inhalte und Produktempfehlungen sind redaktionell unabhängig. Wir können Geld verdienen, wenn Sie auf Links zu unseren Partnern klicken. Mehr erfahren

Last month MySQL rolled out preview versions of the next release of its namesake database, as well as its upcoming MySQL Control Center, a Linux and Windows graphical administration tool.

MySQL 4.1, now in alpha (only source code is downloadable), gains subselect and subquery support. In so doing, it removes a major source of SQL incompatibility.

Version 4.1 also supports protocol encryption using SSL and gains Unicode data type support and makes a first attempt at handling special geospatial data types.

MySQL still has three major SQL limitations (lack of views, triggers and stored procedures) that the company hopes to address in a 5.0 release by years end. MySQL already supports transactions and foreign keys (its a common misconception that it doesnt).

There are third-party graphical MySQL administration tools, but MySQL Control Center is the first from MySQL itself and is already one of the best ones available. As with MySQL, it is free.

A few MySQL Control Center commands werent functioning in the current beta that I tried, but most features worked.

MySQL Control Center provides a query editor and results viewer; table and table data editor; and overall server administration features.

eWeek Logo

eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site's focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

Eigentum von TechnologyAdvice. © 2026 TechnologyAdvice. Alle Rechte vorbehalten

Werbetreibenden-Offenlegung: Einige der auf dieser Website erscheinenden Produkte stammen von Unternehmen, von denen TechnologyAdvice eine Vergütung erhält. Diese Vergütung kann beeinflussen, wie und wo Produkte auf dieser Website erscheinen, einschließlich beispielsweise der Reihenfolge, in der sie erscheinen. TechnologyAdvice schließt nicht alle Unternehmen oder alle auf dem Marktplatz verfügbaren Produkttypen ein.