mysql搞笑代码？

查询兴趣是books

select my_contacts.*,interests.interest from my_contacts,contact_interest,interests

where interests.interest=’books’ and

contact_interest.interest_id=interests.id and

my_contacts.id=contact_interest.contact_id

–另外一种写法

select my_contacts.id,my_contacts.phone,my_contacts.last_name,my_contacts.first_name,my_contacts.email,my_contacts.birthday,my_contacts.prof_id,my_contacts.status_id,my_contacts.zip_id,interests.interest,profession.profession,status.status,zip_code.city,zip_code.state,zip_code.zip_code from my_contacts

inner join contact_interest

on my_contacts.id=contact_interest.contact_id

inner join interests

on contact_interest.interest_id=interests.id

inner join profession

on my_contacts.prof_id=profession.id

inner join status

on my_contacts.status_id=status.id

inner join zip_code

on my_contacts.zip_id=zip_code.id

where interests.interest=’books’

–创建personbooks表，作为Php查询的视图表。但是表不能一起更新呀？可以插入？怎样插入呀？

–更新，直接通过查询可以更新吗？注意语句方法，不通用。可以呀，就是视图呀。就是查询的代码复制创建的。

create view person_books as

select my_contacts.id,my_contacts.phone,my_contacts.last_name,my_contacts.first_name,my_contacts.email,my_contacts.birthday,my_contacts.prof_id,my_contacts.status_id,my_contacts.zip_id,interests.interest,profession.profession,status.status,zip_code.city,zip_code.state,zip_code.zip_code from my_contacts

inner join contact_interest

on my_contacts.id=contact_interest.contact_id

inner join interests

on contact_interest.interest_id=interests.id

inner join profession

on my_contacts.prof_id=profession.id

inner join status

on my_contacts.status_id=status.id

inner join zip_code

on my_contacts.zip_id=zip_code.id

where interests.interest=’books’

能不能说详细点啊？怎么帮，干什么。

<?php

$lin = mysql_connect("","","") //链接数据库

$shujuku1="create database music" //创造一个数据库

mysql_query($shujuku1)

mysql_select_db('music',$lin) or die(mysql_error) //选择一个数据库

$biao1="create table exomusic(m_name varchar(50),m_zhuanji varchar(50),m_singer varchar(20))" //创造一个数据表

mysql_query($biao1)

$tianjiashuju="insert into exomusic(m_name,m_zhuanji,m_singer) values('paoxiao','xoxo','exo')"//执行 *** 作

mysql_query($tianjiashuju)

echo "数据库初始化成功！"

?>

---