mysql_query里面,要不要加分号?
$query = sprintf("SELECT firstname, lastname, address, age FROM friends WHERE firstname='%s' AND lastname='%s'",
mysql_real_escape_string($firstname),
mysql_real_escape_string($lastname));
因为MySQL语句本身是要求加分号才执行的。mysql_query里面加了分号后,执行速度是不是更快?因为不用PHP自动添加。
$query = sprintf("SELECT firstname, lastname, address, age FROM friends WHERE firstname='%s' AND lastname='%s';",
mysql_real_escape_string($firstname),
mysql_real_escape_string($lastname));
$query = sprintf("SELECT firstname, lastname, address, age FROM friends WHERE firstname='%s' AND lastname='%s'",
mysql_real_escape_string($firstname),
mysql_real_escape_string($lastname));
因为MySQL语句本身是要求加分号才执行的。mysql_query里面加了分号后,执行速度是不是更快?因为不用PHP自动添加。
$query = sprintf("SELECT firstname, lastname, address, age FROM friends WHERE firstname='%s' AND lastname='%s';",
mysql_real_escape_string($firstname),
mysql_real_escape_string($lastname));
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货