Aggregate

ROW_COUNT

MySQL

Mengembalikan jumlah baris yang dipengaruhi oleh statement sebelumnya (INSERT, UPDATE, DELETE).

Tipe hasil: BIGINT

Syntax

SQL

ROW_COUNT()

Parameter

Fungsi ini tidak memerlukan parameter.

Contoh Penggunaan

After UPDATE

SQL

1 UPDATE users SET status = 'active' WHERE created_at > '2024-01-01';
2 SELECT ROW_COUNT() AS updated_rows;

Jumlah rows yang di-update.

Hasil

updated_rows: 150

After DELETE

SQL

1 DELETE FROM logs WHERE created_at < '2024-01-01';
2 SELECT ROW_COUNT() AS deleted_rows;

Jumlah rows yang dihapus.

Hasil

deleted_rows: 5000

Conditional Logic

SQL

1 UPDATE products SET price = price * 1.1 WHERE category = 'electronics';
2 SELECT CASE 
3   WHEN ROW_COUNT() = 0 THEN 'No products updated'
4   ELSE CONCAT(ROW_COUNT(), ' products updated')
5 END AS result;

Cek apakah ada yang ter-update.

Hasil

result: 25 products updated

Kembali ke MySQL Functions

1	UPDATE users SET status = 'active' WHERE created_at > '2024-01-01';
2	SELECT ROW_COUNT() AS updated_rows;

1	DELETE FROM logs WHERE created_at < '2024-01-01';
2	SELECT ROW_COUNT() AS deleted_rows;

1	UPDATE products SET price = price * 1.1 WHERE category = 'electronics';
2	SELECT CASE
3	WHEN ROW_COUNT() = 0 THEN 'No products updated'
4	ELSE CONCAT(ROW_COUNT(), ' products updated')
5	END AS result;