Monthly Archives: January 2011

Inconsistency in view column data type

When we crate views in MySQL, the data types of the view columns should be derived from the base tables. However MySQL sometimes goes “extra miles”. USE test; DROP TABLE IF EXISTS property; CREATE TABLE property (user_id int not null, … Continue reading

Posted in MySQL | Leave a comment