目前,我正在使用服务器版本:5.5.24-0ubuntu0.12.04.1 (Ubuntu) 版本mysql
。不幸的是,关系运算符不适用于时间数据类型,例如日期。
我看到它mysql-6.0.10-alpha
已经发布了:认为错误可能已经修复;虽然找不到在 Ubuntu 12.04 上安装它的方法。
例子:-
mysql> select emp_id, fname, lname, start_date,title from employee ;
+--------+----------+-----------+------------+--------------------+
| emp_id | fname | lname | start_date | title |
+--------+----------+-----------+------------+--------------------+
| 1 | Michael | Smith | 2001-06-22 | President |
| 2 | Susan | Barker | 2002-09-12 | Vice President |
| 3 | Robert | Tyler | 2000-02-09 | Treasurer |
| 4 | Susan | Hawthorne | 2002-04-24 | Operations Manager |
| 5 | John | Gooding | 2003-11-14 | Loan Manager |
| 6 | Helen | Fleming | 2004-03-17 | Head Teller |
| 7 | Chris | Tucker | 2004-09-15 | Teller |
| 8 | Sarah | Parker | 2002-12-02 | Teller |
| 9 | Jane | Grossman | 2002-05-03 | Teller |
| 10 | Paula | Roberts | 2002-07-27 | Head Teller |
| 11 | Thomas | Ziegler | 2000-10-23 | Teller |
| 12 | Samantha | Jameson | 2003-01-08 | Teller |
| 13 | John | Blake | 2000-05-11 | Head Teller |
| 14 | Cindy | Mason | 2002-08-09 | Teller |
| 15 | Frank | Portman | 2003-04-01 | Teller |
| 16 | Theresa | Markham | 2001-03-15 | Head Teller |
| 17 | Beth | Fowler | 2002-06-29 | Teller |
| 18 | Rick | Tulman | 2002-12-12 | Teller |
+--------+----------+-----------+------------+--------------------+
18 rows in set (0.00 sec)
mysql> select emp_id, fname, lname, start_date,title from employee where start_date >= '2006-01-01';
Empty set (0.00 sec)
答案1
这个(mysql dev 下载站点)或者这个(镜像站点)是下载该包的链接mysql-6.0.11-alpha-linux-i686-glibc23.tar.gz
。这里是安装说明。但由于这是预发布版本,因此不推荐使用。
根据说明,您必须完全删除apt-get
Ubuntu 中安装的版本才能从源代码进行新安装。