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 应该如何设置呢?
解决方案 »
- 为什么数据类型不正确,MYSQL也不会提示?
- ADO连接数据库mysql5.1Error:msado15.dll access violation
- MySQL无法级联
- 数据库导入问题请教
- 关于MySQL的几个问题
- 请教一个和postgresql相关的问题
- 我用"select * from subject order by ID DESC"来列出所有的记录(subject表中大概有10000条左右的记录) 请问我需要为ID来建立索引吗?我
- MySQL4.1.0 for windows中文字符集问题?急!!!
- mysql关于临时表的联查问题
- mysql,update多个字段,如何忽略其中几个字段的错误?
- 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