最初级的程序,就是mysql论坛上的一个例子CREATE TABLE employees (id INT NOT NULL,fname VARCHAR(30),lname VARCHAR(30),hired DATE NOT NULL DEFAULT '1970-01-01',separated DATE NOT NULL DEFAULT '9999-12-31',job_code INT,store_id INT ) PARTITION BY HASH(store_id) PARTITIONS 4;;但是总是在PARTITION BY HASH前报语法错误
错误是
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PARTITION BY HASH(store_id)
那位大虾能帮忙解决阿???
错误是
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PARTITION BY HASH(store_id)
那位大虾能帮忙解决阿???
支持分区的数据库的版本应该是5.1,
那位大虾知道该如何升级???我就把20分给他谢谢。。
2、rpm -ivh或者安装TAR包scripts/mysql_install_db --user=mysql
....