×
Night mode
Sign up
Login
Mysql row count
MySQL row count of a single table: 
SELECT 
    COUNT(*)
FROM
    customers;
MySQL row count of two or more tables: 
SELECT 
    'customers' tablename, 
     COUNT(*) rows
FROM
    customers 
UNION 
SELECT 
    'orders' tablename, 
     COUNT(*) rows
FROM
    orders;
by Luka Tatarishvili
4 years ago
MySQL
Select
0
Pro tip: use ```triple backticks around text``` to write in code fences