Aggregate

ROW_COUNT

MySQL

Returns the number of rows affected by the most recent INSERT, UPDATE, or DELETE statement.

Tipe hasil: BIGINTDiperbarui: 13 Jun 2026

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;

Number of rows that were updated.

Hasil

updated_rows: 150

After DELETE

SQL

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

Number of rows that were deleted.

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;

Check whether any rows were affected by the update.

Hasil

result: 25 products updated

Pertanyaan Umum tentang ROW_COUNT

Apa itu fungsi ROW_COUNT di MySQL?

Returns the number of rows affected by the most recent INSERT, UPDATE, or DELETE statement. Di MySQL, fungsi ROW_COUNT termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.

Bagaimana cara menggunakan ROW_COUNT di MySQL?

Gunakan sintaks berikut: ROW_COUNT(). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.

Apa nilai yang dikembalikan oleh fungsi ROW_COUNT?

Fungsi ROW_COUNT mengembalikan nilai bertipe BIGINT. Pastikan tipe data hasil sudah sesuai dengan kebutuhan query atau formula kamu. Jika input mengandung nilai NULL, perilaku fungsi dapat berbeda — selalu periksa dokumentasi untuk memastikan hasilnya sesuai ekspektasi.

Ngulik Langsung

Sudah paham ROW_COUNT? Latih langsung di browser

Latihan interaktif, langsung di browser.

Latihan Langsung →

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;