<?php$link = Mysql_connect(“localhost”,”root”,”123”) or die(“数据库连接失败!”);Mysql_select_db(“db_test”,$link) or die(“选择数据库失败!”);$sql = “select id,name,age,gender,phone,email from friend where age>20”;$result = mysql_query($sql);$count = mysql_num_rows($result);While($row = mysql_fetch_assoc($result)){Echo $row[‘id’];….}

以下有两个表
user表 字段id (int)，name (varchar)
score表 字段uid (int)，subject (varchar) ，score (int)
score表的uid字段与user表的id字段关联
要求写出以下的sql语句

在user表里新插入一条记录，在score表里插入与新加入的记录关联的两条记录
2）获取score表里uid为2的用户score最高的5条记录
3）使用联合查询获取name为“张三”的用户的总分数
4）删除name为“李四”的用户，包括分数记
5）清空score表
6）删除user表

1). mysql_query(“insert into user(name) values(‘test’)”);$id = mysql_insert_id();Mysql_query(“insert into score(uid,subjext,score) values(“.$id.”,’english’,’99’)”);2).$sql = select uid,sunjext,score from score where uid=2 order by score desc limit 0,5;3).select s.score from score s RIGHT JOIN user u ON u.id=s.uid where u.name=’张三;4).delete from score where uid in(select id from user where name=’李四’);Delete from user where name=’李四’;5).delete from score;6).drop table user;