Roland Turner

about | contact

One liner for counting rows in MySQL

To execute a simple query to get a number, with no headers and no ASCII-art:

mysql database -sNe “SELECT COUNT(*) FROM table”