I'm using 5.0.9 beta standard. I'll try to upgrade and will re-post if I
still get erroneous results.
s.m.
Am Mon, 15 Aug 2005 18:53:40 +0200 hat Gleb Paharenko
<[EMAIL PROTECTED]> geschrieben:
Hello.
What version of MySQL do you use? On my 5.0.11 I have a correct result:
mysql> show c
Hello.
What version of MySQL do you use? On my 5.0.11 I have a correct result:
mysql> show create table dateTest\G;
*** 1. row ***
View: dateTest
Create View: CREATE ALGORITHM=UNDEFINED VIEW
`test`.`dateTest`
I have a table with date values:
++
| theDate|
++
| 2005-08-15 |
| 2005-08-16 |
| 2005-08-14 |
++
I can execute this select statement on it:
select * from tDay where theDate > date_sub( now(), interval 1 day);
And I can create a view from it:
create