mysql建立简单豆瓣影人数据库

CREATE TABLE Artist (

       id INT auto_increment PRIMARY KEY,

       theNAME VARCHAR ( 255 ) NOT NULL,

       birthday date NOT NULL,

       sex VARCHAR ( 255 ) NOT NULL,

       IMDBnumber VARCHAR ( 255 ) NOT NULL,

       introduction VARCHAR ( 100 ) NOT NULL

);

INSERT INTO Artist ( theNAME, birthday, sex, IMDBnumber, introduction )

VALUES

       ( 'Julie Andrews', '1935-10-1', 'female', 'nm0000267', '1965年获得奥斯卡影后' );

INSERT INTO Artist ( theNAME, birthday, sex, IMDBnumber, introduction )

VALUES

       ( '巩俐', '1965-12-31', 'female', 'nm0000084', '26届金像奖最佳女主' );

INSERT INTO Artist ( theNAME, birthday, sex, IMDBnumber, introduction )

VALUES