CREATE TABLE T_B(id INT, name VARCHAR(30), adate DATE)
PARTITION BY LIST(YEAR(adate))
(
PARTITION p1999 VALUES IN (1995, 1999, 2003) DATA DIRECTORY = '/D/Program Files/MySQL/MySQL Server 5.2/data/test/var/appdata/95/data' ,
PARTITION p2000 VALUES IN (1996, 2000, 2004) DATA DIRECTORY = '/D/Program Files/MySQL/MySQL Server 5.2/data/test/var/appdata/96/data' ,
PARTITION p2001 VALUES IN (1997, 2001, 2005) DATA DIRECTORY = '/D/Program Files/MySQL/MySQL Server 5.2/data/test/var/appdata/97/data' ,
PARTITION p2002 VALUES IN (1998, 2002, 2006) DATA DIRECTORY = '/D/Program Files/MySQL/MySQL Server 5.2/data/test/var/appdata/98/data'
);运行不了,会关闭MYSQL的服务;请问是为什么?
我想是路径写错了,不知 DATA DIRECTORY 应该如何设置呢?
PARTITION BY LIST(YEAR(adate))
(
PARTITION p1999 VALUES IN (1995, 1999, 2003) DATA DIRECTORY = '/D/Program Files/MySQL/MySQL Server 5.2/data/test/var/appdata/95/data' ,
PARTITION p2000 VALUES IN (1996, 2000, 2004) DATA DIRECTORY = '/D/Program Files/MySQL/MySQL Server 5.2/data/test/var/appdata/96/data' ,
PARTITION p2001 VALUES IN (1997, 2001, 2005) DATA DIRECTORY = '/D/Program Files/MySQL/MySQL Server 5.2/data/test/var/appdata/97/data' ,
PARTITION p2002 VALUES IN (1998, 2002, 2006) DATA DIRECTORY = '/D/Program Files/MySQL/MySQL Server 5.2/data/test/var/appdata/98/data'
);运行不了,会关闭MYSQL的服务;请问是为什么?
我想是路径写错了,不知 DATA DIRECTORY 应该如何设置呢?
解决方案 »
- 触发器操作
- 选出表中某个属性的最大最小值
- mysqlgroup效率问题
- 级联cascade消失了
- 数据库出现异常,大家看看,谢谢
- 关于交叉表的问题,并算平均值是怎么写的SQL语句
- 问一个弱弱的问题,postgress中的存储过程怎么运行?
- $$$给分请教:我把Linux上的一个网站下到win2000上,并且配置好了环境,但大量出现Warning: Failed opening '/home/www/include/global/c
- 问一个连接查询的问题
- 请问,像这种多条件查询的该怎么建立索引?
- mysql 乱码的问题
- 用Navicat 恢复 导入 mysql备份 出现out of memory错误
DATA DIRECTORY = '/D/Program Files/MySQL/MySQL Server 5.2/data/test/var/appdata/95/data' ,
应该怎么写?
http://bugs.mysql.com/bug.php?id=29322