如何安装 mysql-6.0.10-alpha?

如何安装 mysql-6.0.10-alpha?

目前,我正在使用服务器版本: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-getUbuntu 中安装的版本才能从源代码进行新安装。

相关内容