Home arrow MySQL arrow Page 6 - Views and More in MySQL 5.0

Change in User Variable Behavior - MySQL

MySQL 5.0 supports a range of features that earlier versions of MySQL do not support. This article, the fourth in a series, explains views and other new features. It is excerpted from chapter eight of Beginning MySQL Database Design and Optimization: From Novice to Professional, written by Jon Stephens and Chad Russell (Apress, ISBN: 1590593324).

  1. Views and More in MySQL 5.0
  2. Syntax--Creating, Altering, and Dropping Views
  3. Examples
  4. Benefits
  5. Other Improvements in MySQL 5.0
  6. Change in User Variable Behavior
By: Apress Publishing
Rating: starstarstarstarstar / 25
May 11, 2006

print this article



Beginning in MySQL 5.0.0, user variable names are case insensitive. This means that @myvar , @MyVar , and @MYVAR will all be regarded as the same variable, as shown here (using MySQL 5.0.1-alpha):

If you’ve been relying on case sensitivity in user variables for any of your MySQL-related work, we recommend highly that you abandon this practice immediately.

New Values for DATE_ADD() and DATE_SUB() Functions

Two new values, WEEK and QUARTER , have been added for use with the DATE_ADD() and DATE_SUB() functions in MySQL 5.0. You can see how these are used and what sorts of results you can expect from them here:

Change in the VARCHAR Type

The VARCHAR type is expected to be altered so that it will be possible to store values with more than 255 characters. That hasn’t happened yet as of MySQL 5.0.1—if you attempt to define a VARCHAR column with a size of greater than 255 characters, MySQL will simply convert the column to the TEXT datatype. (See Chapter 2 of this book for a discussion of how MySQL “silently” changes column types.) However, we look for a change to take place by the time that MySQL 5.0 appears in a production release.

>>> More MySQL Articles          >>> More By Apress Publishing

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Oracle Unveils MySQL 5.6
- MySQL Vulnerabilities Threaten Databases
- MySQL Cloud Options Expand with Google Cloud...
- MySQL 5.6 Prepped to Handle Demanding Web Use
- ScaleBase Service Virtualizes MySQL Databases
- Oracle Unveils MySQL Conversion Tools
- Akiban Opens Database Software for MySQL Use...
- Oracle Fixes MySQL Bug
- MySQL Databases Vulnerable to Password Hack
- MySQL: Overview of the ALTER TABLE Statement
- MySQL: How to Use the GRANT Statement
- MySQL: Creating, Listing, and Removing Datab...
- MySQL: Create, Show, and Describe Database T...
- MySQL Data and Table Types
- McAfee Releases Audit Plugin for MySQL Users

Developer Shed Affiliates


Dev Shed Tutorial Topics: