php数据库简单语法.docVIP

?MYSQL 数据库 Show databases Drop database Create database db_sycandy Use db_sycandy Create table 表名称 Alter table tb_book add bookprice float; Show tables Rename table tb_book to book Alter table book modify bookname varchar(100) Alter table book change bookname name varchar(200) Alter table book drop sendtime Desc book Insert into tb_user(username,userpwd)values(‘tiger’,’123456’); Set names gbk Set names gb2312 Truncate table tb_user Select * from tb_user Select * from tb_user limit 0,2 Select * from tb_user order by id desc Select * from tb_user where age=3 Select * from tb_user where age between 20 and 30 Select * from tb_user group by gender Select count(*) as total from tb_user Select avg(age) as percent from tb_user Select max(age) as maxage from tb_user Select min(age)as minage from tb_user Select * from tb_user where username like ‘tiger’ Select * from tb_user where username like ‘tiger’ and age=20 Select * from tb_user where username like ‘tiger’ or age=20 Drop table book; Update tb_user set username=’xxxx’,userpwd=’xxxxx’ where id=1 Delete from tb_user where id= 1 循环数据库中的记录 Mysql_fetch_array ?php /*$conn = mysql_connect(localhost,root,tiger); //echo $conn; //echo get_resource_type($conn); if(!$conn) { echo 数据库连接失败; } else{ echo 数据库连接成功; }*/ //$conn = mysql_connect(localhost,root,tiger) or die(连接数据库错误).mysql_error; $conn = mysql_connect(localhost,root,tiger); mysql_select_db(db_sycandy,$conn); mysql_query(set names gb2312); $result = mysql_query(select * from tb_user,$conn); //echo $result; //echo get_resource_type($result); $info = mysql_fetch_array($result); do{ echo $info[userpwd].br/; } while($info = mysql_fetch_array($result)); mysql_free_result($result); mysql_close($conn); ? Mysql_fetch_row $info = mysql_fetch_row($result); do{ echo $info[2].br/; } while($info = mysql_fetch_row($result)); mysql_free_result($result); mysql_close($conn); Mysql_fetch_object $info = mysql_fetch_object($result); do{ echo $info-userpwd.br/; } whi