a php developer weblog

blog Closed!
calin view of the web development world

2006/3/3

upgrading to mysql 5 - FLOAT issue

Tags:
@ 03:19 PM (44 months, 25 days ago)
This is just a small note, to cover FLOAT issues when upgrading from MySQL version 4.0 to 5.0. In MySQL 4.0, the float type is by default 10 digits long, 4 after the decimal point. A create table statement would look like this:

Read the rest of this entry ... (130 words left)

2005/10/25

MySQL 5.0 is Production ready!!

Tags:
@ 04:27 PM (49 months, 4 days ago)
MySQL 5.0 is available for production usage! Some of the enterprise feature list:
  • Stored Procedures and SQL Functions -- to embed business logic in the database and improve performance;
  • Triggers -- to enforce complex business rules at the database level; 
  • Views -- to ensure protection of sensitive information; 
  • Cursors -- to allow easier database development and reference of large datasets;
... and many more. That's perfect timing for Systems 2005 Munich.