php操作mysql数据库
<?php
$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) 索引数组
mysql_fetch_assoc($res) 关联数据
mysql_fetch_array($res) 索引和关联
mysql_fetch_object($res) 对象
自我复制
insert into products(cid,name,price,num,desn,ptime)select cid,name,price,num,desn,ptime from products;
