mysql4.1版及以上:insert into group values(5,2);
update users set state = (select group_name from user_group where group_id=2) where user_id=5;
update users set state = (select group_name from user_group where group_id=2) where user_id=5;
解决方案 »
- PHP 快速截取指定网页Head标记内容问题
- 请教正则表达式
- 要怎么才能实现定时更新?
- 用php如何获取一个网页的高度和宽度?
- mysql组合查询后,smarty如何调用两个表中相同字段名的值
- 我装了wincvs,它提示我装python,装了后怎么还是不行啊?
- 请教个问题
- 我是新手啊,我现在需要把一个已有的网页直接镶入我的页面中!!怎么写代码啊??
- session的问题!
- 我的mysql一运行mysqld-shareware -install提示Failed to install Service.Why?Winnt+sp4
- 大家帮我看段代码吧!
- 怎么得到存储过程的多个结果?我现在只能得到一组结果!
$sql = "insert into group(user_id,group_id) values('5','2')";
$result = mysql_query($sql);同时在表users中根据对应的字段user_id,在state字段中将group_id对应的group_name(在表user_group中)的值插入。
$sql = "select * from user_group where group_id = '2'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);$sql = "insert into users(user_id,state) values('5','". $row['group_name'] ."')";
$result = mysql_query($sql);这些应该可以实现LZ要的功能 有问题继续发贴~~
{
$sql = "insert into group values(5,2)";
if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not add user to group', '', __LINE__, __FILE__, $sql);
下面这句怎么放在里面好呢??
update users set state = (select group_name from user_group where group_id=2) where user_id=5;
}
after insert on group
for each row
begin
update users set state=(select group_name from user_group where group_id=NEW.group_id) where user_id=NEW.user_id;
end $$delimiter ;
{
$sql = "insert into group values(5,2)";
if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not add user to group', '', __LINE__, __FILE__, $sql);
}
else{
$sql="update users set state = (select group_name from user_group where group_id=2) where user_id=5;"
$db->sql_query($sql);
}
}