PHP函数：mysql_query()

mysql_query() 函数执行一条 MySQL 查询。

语法如下：

mysql_query(query,connection)

参数 query 是必需。它规定要发送的 SQL 查询。注释：查询字符串不应以分号结束。参数 connection 是可选的。它规定 SQL 连接标识符。如果未规定，则使用上一个打开的连接。

如果没有打开的连接，本函数会尝试无参数调用 mysql_connect() 函数来建立一个连接并使用之。

mysql_query() 仅对 SELECT，SHOW，EXPLAIN 或 DESCRIBE 语句返回一个资源标识符，如果查询执行不正确则返回 FALSE。对于其它类型的 SQL 语句，mysql_query() 在执行成功时返回 TRUE，出错时返回 FALSE。

非 FALSE 的返回值意味着查询是合法的并能够被服务器执行。这并不说明任何有关影响到的或返回的行数。很有可能一条查询执行成功了但并未影响到或并未返回任何行。

该函数自动对记录集进行读取和缓存。如需运行非缓存查询，请使用 mysql_unbuffered_query()。

Example 1$con = mysql_connect("localhost", "mysql_user", "mysql_pwd");if (!$con){die('Could not connect: ' . mysql_error());}$sql = "SELECT * FROM Person";mysql_query($sql, $con);// 一些代码mysql_close($con);Example 2通过 mysql_query() 函数创建一个新数据库：$con = mysql_connect("localhost", "mysql_user", "mysql_pwd");if (!$con){die('Could not connect: ' . mysql_error());}$sql = "CREATE DATABASE my_db";if (mysql_query($sql,$con)){echo "Database my_db created";}else{echo "Error creating database: " . mysql_error();}

文章来源：PHP程序员之家

本文地址：http://www.phperhome.com/php/178.html

http://www.phperhome.com/seo/377.html

http://www.phperhome.com/seo/376.html

http://www.phperhome.com/php/375.html

http://www.phperhome.com/life/374.html

http://www.phperhome.com/php/373.html

http://www.phperhome.com/php/372.html

http://www.phperhome.com/php/371.html

http://www.phperhome.com/php/370.html

http://www.phperhome.com/php/369.html

http://www.phperhome.com/php/368.html

http://www.phperhome.com/server/367.html

http://www.phperhome.com/server/366.html

http://www.phperhome.com/server/365.html

http://www.phperhome.com/server/364.html

http://www.phperhome.com/server/363.html

http://www.phperhome.com/server/362.html

http://www.phperhome.com/server/361.html

http://www.phperhome.com/server/360.html

http://www.phperhome.com/server/359.html

http://www.phperhome.com/server/358.html

http://www.phperhome.com/server/357.html

http://www.phperhome.com/server/356.html

http://www.phperhome.com/server/355.html

http://www.phperhome.com/server/354.html

http://www.phperhome.com/server/353.html

http://www.phperhome.com/server/352.html

http://www.phperhome.com/javascript/350.html

http://www.phperhome.com/javascript/349.html

http://www.phperhome.com/javascript/348.html

http://www.phperhome.com/javascript/347.html

http://www.phperhome.com/php/346.html

http://www.phperhome.com/php/345.html

http://www.phperhome.com/php/344.html

http://www.phperhome.com/php/343.html

http://www.phperhome.com/php/342.html

http://www.phperhome.com/php/341.html

http://www.phperhome.com/php/340.html

http://www.phperhome.com/php/339.html

http://www.phperhome.com/php/338.html

http://www.phperhome.com/php/337.html

http://www.phperhome.com/php/336.html

http://www.phperhome.com/php/335.html

http://www.phperhome.com/php/334.html

http://www.phperhome.com/php/333.html

http://www.phperhome.com/life/332.html

http://www.phperhome.com/life/331.html

http://www.phperhome.com/php/330.html

http://www.phperhome.com/javascript/329.html

http://www.phperhome.com/javascript/328.html

http://www.phperhome.com/javascript/327.html

http://www.phperhome.com/javascript/326.html

http://www.phperhome.com/javascript/325.html

http://www.phperhome.com/dedecms/324.html

http://www.phperhome.com/css/323.html

http://www.phperhome.com/css/322.html

http://www.phperhome.com/server/321.html

http://www.phperhome.com/life/320.html

http://www.phperhome.com/dedecms/319.html

http://www.phperhome.com/server/317.html

http://www.phperhome.com/javascript/313.html

http://www.phperhome.com/php/310.html

http://www.phperhome.com/php/303.html

http://www.phperhome.com/dedecms/302.html

http://www.phperhome.com/mysql/292.html

http://www.phperhome.com/mysql/281.html

http://www.phperhome.com/mysql/280.html

http://www.phperhome.com/mysql/277.html

http://www.phperhome.com/mysql/269.html

http://www.phperhome.com/php/253.html

http://www.phperhome.com/php/259.html

http://www.phperhome.com/php/258.html

http://www.phperhome.com/php/251.html

http://www.phperhome.com/php/249.html

http://www.phperhome.com/php/248.html

http://www.phperhome.com/php/247.html

http://www.phperhome.com/php/246.html

http://www.phperhome.com/php/245.html

http://www.phperhome.com/mysql/243.html

http://www.phperhome.com/mysql/242.html

http://www.phperhome.com/php/241.html

http://www.phperhome.com/javascript/240.html

http://www.phperhome.com/javascript/239.html

http://www.phperhome.com/javascript/238.html

http://www.phperhome.com/html5/235.html

http://www.phperhome.com/html5/230.html

http://www.phperhome.com/php/173.html

http://www.phperhome.com/html/213.html

http://www.phperhome.com/php/212.html

http://www.phperhome.com/php/208.html

http://www.phperhome.com/mysql/205.html

http://www.phperhome.com/php/197.html

http://www.phperhome.com/php/187.html

http://www.phperhome.com/php/178.html

http://www.phperhome.com/php/177.html

http://www.phperhome.com/life/175.html

http://www.phperhome.com/server/13.html

http://www.phperhome.com/php/170.html

http://www.phperhome.com/php/168.html

http://www.phperhome.com/php/167.html

http://www.phperhome.com/server/162.html

http://www.phperhome.com/life/161.html

http://www.phperhome.com/php/151.html

http://www.phperhome.com/jquery/141.html

http://www.phperhome.com/html5/137.html

http://www.phperhome.com/html5/131.html

http://www.phperhome.com/seo/123.html

http://www.phperhome.com/seo/119.html

http://www.phperhome.com/seo/116.html

http://www.phperhome.com/seo/115.html

http://www.phperhome.com/seo/114.html

http://www.phperhome.com/seo/113.html

http://www.phperhome.com/life/108.html

http://www.phperhome.com/html5/105.html

http://www.phperhome.com/php/99.html

http://www.phperhome.com/mysql/87.html

http://www.phperhome.com/mysql/86.html

http://www.phperhome.com/mysql/85.html

http://www.phperhome.com/mysql/83.html

http://www.phperhome.com/php/79.html

http://www.phperhome.com/php/76.html

http://www.phperhome.com/javascript/74.html

http://www.phperhome.com/jquery/71.html

http://www.phperhome.com/css3/66.html

http://www.phperhome.com/css3/69.html

http://www.phperhome.com/html/62.html

http://www.phperhome.com/life/61.html

http://www.phperhome.com/css/56.html

http://www.phperhome.com/seo/50.html

http://www.phperhome.com/php/47.html

http://www.phperhome.com/dedecms/44.html

http://www.phperhome.com/server/42.html

http://www.phperhome.com/server/40.html

http://www.phperhome.com/html/34.html

http://www.phperhome.com/life/39.html

http://www.phperhome.com/css/32.html

http://www.phperhome.com/html5/29.html

http://www.phperhome.com/dedecms/25.html

http://www.phperhome.com/dedecms/22.html

http://www.phperhome.com/dedecms/21.html

http://www.phperhome.com/life/8.html

http://www.phperhome.com/php/7.html

http://www.phperhome.com/mysql/202.html

http://www.phperhome.com/mysql/201.html

http://www.phperhome.com/mysql/196.html

http://www.phperhome.com/mysql/195.html

http://www.phperhome.com/mysql/194.html

http://www.phperhome.com/mysql/193.html

http://www.phperhome.com/mysql/184.html

http://www.phperhome.com/mysql/102.html

http://www.phperhome.com/html5/230.html

http://www.phperhome.com/html5/229.html

http://www.phperhome.com/css3/52.html

http://www.phperhome.com/javascript/224.html

http://www.phperhome.com/javascript/223.html

http://www.phperhome.com/javascript/222.html

http://www.phperhome.com/javascript/221.html

http://www.phperhome.com/javascript/220.html

http://www.phperhome.com/javascript/182.html

http://www.phperhome.com/javascript/64.html

http://www.phperhome.com/jquery/225.html

http://www.phperhome.com/html/213.html

http://www.phperhome.com/dedecms/183.html

http://www.phperhome.com/dedecms/180.html

http://www.phperhome.com/dedecms/179.html

http://www.phperhome.com/seo/117.html

http://www.phperhome.com/seo/43.html

http://www.phperhome.com/server/234.html

http://www.phperhome.com/server/41.html

http://www.phperhome.com/life/228.html

http://www.phperhome.com/life/227.html

http://www.phperhome.com/life/185.html

http://www.phperhome.com/life/161.html

http://www.phperhome.com/life/8.html