mysql数据库 - Java / Java相关

CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
  (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT NULL,
FRIEND_SEX CHAR(2) NOT NULL,
FRIEND_BIRTHDAY DATATIME NOT NULL,
FRIEND_WORKUNIT VARCHAR(100),
FRIEND_HOMEADD VARCHAR(200),
FRIEND_PHONECODE VARCHAR(40),
FRIEND_MOBILE VARCHAR(20) NOT NULL,
FRIEND_QQ VARCHAR(20) NOT NULL,
FRIEND_EMAILE VARCHAR(40),
FRIEND_ MAILINGADD VARCHAR(200),
FRIEND_POSTCODE VARCHAR(10));
为什么不行呢？

---

最后加上commit;试试

---

语句看不出错来，贴出错误信息

---

看不出来错啊

---

引用

SQL codeCREATEDATABASE ADDRESSLIST;USE ADDRESSLIST;DROPTABLEIFEXISTS FRIEND;CREATETABLE FRIEND
(FRIEND_IDINTEGERNOTNULL AUTO_INCREMENTPRIMARYKEY ,
FRIEND_NAMEVARCHAR(20)NOTNULL,
FRIEND_SEXCHAR(2)NOTNULL,
FRIEND_BIRTHDAYDATETIMENOTNULL,
FRIEND_WORKUNITVARCHAR(100),
FRIEND_HOMEADDVARCHAR(200),
FRIEND_PHONECODEVARCHAR(40),
FRIEND_MOBILEVARCHAR(20)NOTNULL,
FRIEND_QQVARCHAR(20)NOTNULL,
FRIEND_EMAILEVARCHAR(40),
FRIEND_MAILINGADDVARCHAR(200),
FRIEND_POSTCODEVARCHAR(10));
错误两处：
FRIEND_BIRTHDAYDATATIMENOT NULL,⇒DATATIME 错误，正确是DATETIME
FRIEND_ MAILINGADD VARCHAR(200), 含有空格

真细心，赞

---

4楼很认真。。好。。