50,639
社区成员
![](https://csdnimg.cn/release/cmsfe/public/img/topic.427195d5.png)
![](https://csdnimg.cn/release/cmsfe/public/img/me.40a70ab0.png)
![](https://csdnimg.cn/release/cmsfe/public/img/task.87b52881.png)
![](https://csdnimg.cn/release/cmsfe/public/img/share-circle.3e0b7822.png)
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));