简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW)
Home > Database > Mysql Tutorial > body text

sql update是否成功更新了数据方法

WBOY
Release： 2016-06-07 17:51:15
Original
1413 people have browsed it

获取update更新的多少行的函数用：mysql_affected_rows($conn) 或者用mysqli_affected_rows($conn)

 代码如下 复制代码

$sql = "update table a set aname='名字' where aid=88";
$r = $conn->query($sql);
if ($r){
echo "错误以为这里就是数据做了更新，如果这个aid为88的数据不存在语句同样返回true。";
}
Related labels：
sql update update用法
source：php.cn
Previous article：MySQL Slave同一server_id的冲突原因分析 Next article：DBM数据导入到mysql数据库方法
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Retrieve MySql rows with the same column value Let us consider the following table - IDScore19521003884100573 I am a complete SQL noob, b...
From 2023-11-10 21:53:39
0
2
331
XAMPP/SQLSRV: Unable to find Sqlsrv in PHPINFO(); - error from connection I'm trying to connect to my SQLServer database hosted on a LinuxVM. I'm running xampp on m...
From 2023-11-09 22:34:33
0
1
172
What is the way to protect this function from SQL injection? publicstaticboolTruncateTable(stringdbAlias,stringtableName){stringsqlStatement=string.For...
From 2023-11-07 22:03:43
0
2
274
Prevent MySQL from reading when updating I have two simple queries, one to read the table and one to update the table. How to lock ...
From 2023-11-07 18:05:53
0
1
203
SQLSTATE: Column not found: 1054 Unknown column 'category_name' in 'field list' (SQL: insert into `categories`) to `categories`) Illuminate\Database\QueryExceptionSQLSTATE[42S22]:1054 Unknown column name 'category_name'...
From 2023-11-05 15:50:42
0
1
242
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！