php操作mysql数据库

$link=mysql_connect("localhost","root","root");
if($link){
  }else{
    echo "连接失败";
    exit;
    }
mysql_select_db("test");
 
$sql="create table shops(id int auto_increment not null,name varchar(30) not null, price double not null default '0.00', num int not null default '0', primary key(id),key(name,price))";
//$sql2="alter table shops add desn varchar(64) after price";
$sql2="insert into shops(name,price,desn,num)values('php',10,'php hello',5)";
$sql3="delete from shops where id<15";
$res=mysql_query($sql3);
if($res){
  }else{
    echo mysql_errno().":".mysql_error()."/n";
    }
if(mysql_affected_rows()>0){
  echo "执行成功:"."影响行数".mysql_affected_rows()."最后自动增长的ID=".mysql_insert_id();
  }else{
    echo "记录没有改变";
    }
mysql_close();
?>

从结果集将记录取出来
mysql_fetch_row($res)索引数组mysq{l}_{f}etc{h}_{a}ssoc($res) 关联数据
mysql_fetch_array($res)索引和关联mysq{l}_{f}etc{h}_{o}bject($res) 对象

自我复制

insert into products(cid,name,price,num,desn,ptime)select cid,name,price,num,desn,ptime from products;