mysql varchar2_貌似我的mysql建表时候字段设置成varchar2类型就报错

你的位置:

问答吧

-> MySQL

-> 问题详情

貌似我的mysql建表时候字段设置成varchar2类型就报错

本帖最后由 laohuanggua 于 2010-03-25 17:36 编辑

RT!

centos5.4

mysql是yum安装上去的。5.0.77 版本。

mysql> use sql24h;

Database changed

mysql> source /opt/sql24h;

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 'VARCHAR2(9) NOT NULL,

LAST_NAME VARCHAR2(15) NOT NULL,

FIRST_NAME VARCHAR2(15) N' at line 3

mysql> create table test1(id int,name varchar(10));

Query OK, 0 rows affected (0.01 sec)

mysql> create table test2(id int,name varchar2(10));

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to yor MySQL server version for the right syntax to use near 'varchar2(10))' at line 1