Tagged Questions
0
votes
1answer
32 views
MySQL Conversion to DATE Type
What is the difference between the return values for these two expressions in MySQL:
date('2011-01-01')
cast('2011-01-01' AS DATE)
4
votes
1answer
207 views
Type safety in WHERE clauses
I've spent the most part of yesterday tracking down a strange bug in our PHP/MySQL application and the culprit seems to be a poor query. We have a table like
...
3
votes
3answers
374 views
Converting CHAR to BIT
I have a column with char(16) data type and it was mistakenly set to char(16) actually it should be bit(1) because it contains only three distinct values as follows:
16 characters long string
10 ...
7
votes
1answer
1k views
Is there such thing as Custom Data Types?
Does MySQL have any support for custom data types? For example, zip codes might be stored in a varchar(10) field, but they could be compacted in to an int, with options for blank, and a flag as to ...
