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Â¥ºÜÈÏÕæ¡£¡£ºÃ¡£¡£