php数据库简单语法.

1、MYSQL 数据库ShowFiifsql? show ddtaba&es；! Databasei#-+t inft)rnAt ion_scheir) )A 1 mi/sqlidatabasesDropdatabaseCreatedatabase db_syca ndyUse db_syca ndyCreatetable 表名称Altertable tb_bookadd bookprice float; Show tabless ho bi tables：；：；- shou tables；! I ah les_in_dLb_sica.ri shou tables：i T ab les _

2、in_db_s5FcandyAlter table book drop sen dtimemysq 1 琶how tabLes：；：；I I ab les _in_dJ_sy candyDesc bookysql shou t ahl&s：；! Tables_in_d.b_sycandy !hookrow In set 5T5ql insert intv tb_s&i*usemftne,u$ei*pwdvaluesJ|, *12OK,. 1 row effected into t；uery OK. 1 rou offEITrun cate table tb_userSelect

3、 *from tb_userSelect *from tb_userlimit 0,2Select *from tb_userorder by id descSelect *from tb_userwhere age=3Select *from tb_userwhere age betwee n 20a nd 30Select *from tb_usergroup by gen dertiger , 123456 ; Set1Select coun t(*as total from tb_userSelect avg(ageas perce nt from tb_userSelect max(

4、ageas maxage from tb_userSelect min( ageasm in age from tb_userSelect *from tb userwhere user name liketj/sql? insert into !uer=20Select *from tb_userwhere user name liketigerandor age=20UpdateMysql_fetch_arraywhile($i nfo=mysql_fetch_array($result;mysql_free_result($result;mysql_close($c onn;?Mysql

5、_fetch_row$i nfo=mysql_fetch_row($result;doecho $mfo2 *while($infc = my s ql_fe tch_r o w ($r e suit)tinysql_free_result($resultLmy s ql_cl ofe($ conn);Mysql_fetch_object$i nfo=mysql_fetch_object($result;doecho $i nfo-userpwd.while($i nfo=mysql_fetch_object($result;mysql_free_result($result;mysql_close($c onn;Do.while(条件 循环数据库中的记录 Conn.php调用