MySQL Newsletter September 2002

Introduction

• MySQL Affiliate Program Started
  MySQL AB has started an affiliate program. Now you can earn money by selling MySQL Products. Read more at
  http://www.mysql.com/affiliate/ (http://www.mysql.com/affiliate/)
   

Products

• MySQL Connector/J 3.0.1 Beta
  MySQL Connector/J 3.0.1 Beta, the JDBC driver for MySQL has been released today. You can find detailed information, and downloads at:
  http://www.mysql.com/downloads/api-jdbc-dev.html (http://www.mysql.com/downloads/api-jdbc-dev.html)
   
• New MySQL Product Naming with 4.0
  MySQL Server Product naming will change a bit with 4.0. The standard product will be called MySQL Pro, and it will include InnoDB table handler. Other products will be MySQL Classic (no transactions), and MySQL Max, which includes early versions of new features and will be available only under the GPL license.
   
• New Consulting Services launched by MySQL AB
  Company specific MySQL Compact Seminars as well as MySQL Deployment Planning Services are added to help you get the most out of MySQL in your organisation.
   

Features

• Optimizing OR queries with MySQL 4.0
  Many users note MySQL often slows down, executing queries which contain OR between where clauses for different columns, for example "SELECT * from articles where author="Monty" or rating=5" How to make these queries to run with excelent performance ?
   
• MySQL BLOB columns and Visual Basic 6
  In his article Mike Hillyer, a MyODBC user, shows how to handle BLOB/Binary Data from MySQL using MyODBC through Visual Basic. The article includes also sample code. You can read the article at
  http://www.dynamergy.com/mike/articles/blobaccessvb.html
   
• The power of UNION LIMITed
  You probably know about UNION support in MySQL 4.0. For sure you know about LIMIT x,y feature.
  
  Do you know you can combine both in various ways?
   

Events

• German Five Cities Tour booked out
  Over 300 participants came to visit the MySQL GmbH roadshow in September, where we visited Hamburg, Köln, Offenbach, Stuttgart and München.
   
• MySQL Compact Seminar in D.A.CH.
  After our successful Five Cities tour through Germany in September, we have added Bremen 21.10, Berlin 22.10, Zürich 24.10 and Wien 25.10 as venues for our MySQL Compact Seminars.
   
• MySQL Users Conference & Expo
  The first MySQL Users Conference & Expo will be held in April 10-12 2003 in San Jose, California.
  
  Sign up now to receive more information as it becomes available. http://www.mysql.com/events/uc2003/ (http://www.mysql.com/events/uc2003/)
   

Training

• Upcoming MySQL Training Courses
  MySQL AB is holding training courses in the following countries: USA, Germany, France, UK, Australia and New Zealand. Check out dates and locations at http://www.mysql.com/training/ (http://www.mysql.com/training/)
   
• MySQL GmbH offers Compact Training in München
  The five day "Using and Managing MySQL" course will be compacted to a three day course without trainee PCs at a test session in München 15.-17.10.2002 during the Systems Fair week.
   

Partner Corner

• MySQL AB new partner Emic Networks ships clustering solution for MySQL
  Emic Application Cluster (EAC) for MySQL enables multiple physical databases act as a one virtual and transparent database entity.
  
   

Latest News

• Latest MySQL News
  MySQL Compact Seminars in D.A.CH
  http://www.mysql.com/news/article_115.html (http://www.mysql.com/news/article_115.html)
  
  MySQL GmbH offers Compact Training in München
  http://www.mysql.com/news/article_114.html (http://www.mysql.com/news/article_114.html)
  
  MySQL Database Now Provides Full Transaction Support
  http://www.mysql.com/press/release_2002_11.html (http://www.mysql.com/press/release_2002_11.html)
  
  Announcing the MySQL Users Conference & Expo 2003
  http://www.mysql.com/events/uc2003/ (http://www.mysql.com/events/uc2003/)
  
  MySQL AB Supports Multiple .NET Interfaces
  http://www.mysql.com/press/release_2002_10.html (http://www.mysql.com/press/release_2002_10.html)
  
  MySQL wins Prestigious Linux Journal's Editors' Choice Award
  http://www.mysql.com/news/article_109.html (http://www.mysql.com/news/article_109.html)
  
  MySQL's New Product Levels Give Users More Choices
  http://www.mysql.com/news/article_111.html (http://www.mysql.com/news/article_111.html)