mysql数据库

全球车行网 2009-12-28 05:04:38

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));
为什么不行呢？

...全文

99 7 打赏收藏举报

写回复

7 条回复

切换为时间正序

当前发帖距今超过3年，不再开放新的回复

发表回复

yang677888 2010-01-04

打赏
举报

[Quote=引用 4 楼 fengyuanfa 的回复:]
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), 含有空格
[/Quote]恩不错

wibnmo 2010-01-03

打赏
举报

4楼很认真。。好。。

crazylaa 2009-12-29

打赏
举报

fengyuanfa 2009-12-28

打赏
举报



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 DATETIME 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));