Makkah live

Rabu, 16 Juli 2014

get affected rows on MySQL, SQLServer, PHP

MySQL
======
UPDATE TableName SET FieldName=FieldValue
WHERE FieldName=FieldValue;
SELECT ROW_COUNT() AS 'Affected Rows';

ROW_COUNT() is function for get affected rows...

SQLServer
=========
UPDATE TableName SET FieldName=FieldValue
WHERE FieldName=FieldValue;
SELECT @NumberRowsChanged=@@ROWCOUNT;

@@ROWCOUNT is global variable for get affected rows...

PHP
===
The ROW_COUNT function is the mysql_affected_rows equivalent in MySQL.

Tidak ada komentar:

Posting Komentar