【正文】 a,image) values(39。周華健39。,39。男39。,39。內(nèi)地39。,39。../singer/39。)。create table Category( c_id bigint(10) auto_increment, name char(20) , primary key(c_id))。insert into Category(name) values(39。經(jīng)典老歌39。)。insert into Category(name) values(39。流行音樂(lè)39。)。insert into Category(name) values(39。日韓音樂(lè)39。)。insert into Category(name) values(39。歐美音樂(lè)39。)。create table Member( m_id bigint(10) auto_increment, login_name char(20) , login_password char(20), mname char(20), sex char(4), tel char(20), char(20), primary key(m_id))。insert into Member(login_name,login_password,mname,sex,tel,) values(39。305070222439。,39。12345639。,39。汪俊39。,39。男39。,39。1585596531339。,39。wangjunahaq@39。)。create table Message( me_id bigint(10) auto_increment, m_id bigint(10), time char(20), content char(100), primary key(me_id) )。 insert into Message(m_id,time,content) values(1,39。200941839。,39。這里的音樂(lè)很不錯(cuò)，希望有更多更新更好的音樂(lè)奉獻(xiàn)給我們……39。)。 create table Song( so_id bigint(10) auto_increment, soname char(20), linkpath char(40), c_id bigint(10), s_id bigint(10), primary key(so_id) )。 insert into Song(soname,linkpath,c_id,s_id) values(39。擦肩而過(guò)39。,39。../music/39。,2,1)。drop table Admin。drop table Singer。drop table Category。drop table Member。drop table Message。drop table Song。create table Admin( admin_id number(10) identity, login_name varchar2(20) constraint Admin_login_name_nn not null, login_password varchar2(20), admin_name varchar2(20), admin_tel varchar2(20), admin_ varchar2(20), constraint Admin_id_pk primary key(admin_id))。 insert into Admin(login_name,login_password,admin_name,admin_tel,admin_)values(39。admin39。,39。12345639。,39。夏虹39。,39。1386635828539。,39。xiahong@39。)。create table Singer( s_id number(10) identity, sname varchar2(20) constraint Singer_sname_nn not null, sex varchar2(4), area varchar2(20), image varchar2(40), constraint Singer_id_pk primary key(s_id))。insert into Singer(sname,sex,area,image) values(39。劉德華39。,39。男39。,39。港臺(tái)39。,39。singer/39。)。insert into Singer(sname,sex,area,image) values(39。田一龍39。,39。男39。,39。大陸39。,39。singer/39。)。insert into Singer(sname,sex,area,image) values(39。謝霆鋒39。,39。男39。,39。港臺(tái)39。,39。singer/39。)。insert into Singer(sname,sex,area,image) values(39。王菲39。,39。女39。,39。大陸39。,39。singer/39。)。insert into Singer(sname,sex,area,image) values(39。林俊杰39。,39。男39。,39。港臺(tái)39。,39。singer/39。)。insert into Singer(sname,sex,area,image) values(39。葉麗儀39。,39。女39。,39。港臺(tái)39。,39。singer/39。)。insert into Singer(sname,sex,area,image) values(39。任賢齊39。,39。男39。,39。大陸39。,39。singer/39。)。insert into Singer(sname,sex,area,image) values(39。蔡依林39。,39。女39。,39。港臺(tái)39。,39。singer/39。)。insert into Singer(sname,sex,area,image) values(39。F439。,39。男39。,39。港臺(tái)39。,39。singer/39。)。insert into Singer(sname,sex,area,image) values(39。宇桐非39。,39。男39。,39。大陸39。,39。singer/39。)。insert into Singer(sname,sex,area,image) values(39。張雨生39。,39。男39。,39。大陸39。,39。singer/39。)。insert into Singer(sname,sex,area,image) values(39。羽泉39。,39。男39。,39。大陸39。,39。singer/39。)。insert into Singer(sname,sex,area,image) values(39。鄭智化39。,39。男39。,39。港臺(tái)39。,39。singer/39。)。insert into Singer(sname,sex,area,image) values(39。張學(xué)友39。,39。男39。,39。港臺(tái)39。,39。singer/39。)。insert into Singer(sname,sex,area,image) values(39。羅大佑39。,39。男39。,39。港臺(tái)39。,39。singer/39。)。insert into Singer(sname,sex,area,image) values(39。高勝美39。,39。女39。,39。港臺(tái)39。,39。singer/39。)。insert into Singer(sname,sex,area,image) values(39。徐小鳳39。,39。女39。,39。大陸39。,39。singer/39。)。insert into Singer(sname,sex,area,image) values(39。宋祖英39。,39。女39。,39。港臺(tái)39。,39。singer/39。)。insert into Singer(sname,sex,area,image) values(39。刀郎39。,39。男39。,39。大陸39。,39。singer/39。)。insert into Singer(sname,sex,area,image) values(39。李娜39。,39。女39。,39。港臺(tái)39。,39。singer/39。)。create table Category( c_id number(10) identity, name varchar2(20) constraint Category_name_nn not null, constraint Category_id_pk primary key(c_id))。insert into Category(name) values(39。經(jīng)典老歌39。)。insert into Category(name) values(39。華語(yǔ)流行39。)。insert into Category(name) values(39。日韓流行39。)。insert into Category(name) values(39。歐美流行39。)。insert into Category(name) values(39。民族歌曲39。)。insert into Category(name) values(39。流行搖滾39。)。create table Member( m_id number identity, login_name varchar2(20) constraint Member_login_name_nn not null, login_password varchar2(20), mname varchar2(20), sex varchar2(4), tel varchar2(20), varchar2(20), constraint Member_id_pk primary key(m_id))。insert into Member(login_name,login_password,mname,sex,tel,) values(39。305070222439。,39。12345639。,39。汪俊39。,39。男39。,39。1585596531339。,39。wangjunahaq@39。)。create table Message( me_id number(10) identity, m_id number(10), time varchar2(20), content varchar2(100), constraint Message_id_pk primary key(me_id) )。 insert into Message(m_id,time,content) values(1,39。200941839。,39。這里的音樂(lè)很不錯(cuò)，希望有更多更新更好的音樂(lè)奉獻(xiàn)給我們……39。)。 create table Song( so_id number(10) identity, soname varchar2(20) , songname varchar2(20), linkpath varchar2(40), c_id number(10), s_id number(10), sword varchar2(4000), constraint Song_id_pk primary key(so_id) )