xxxxxxxxxx
SELECT COUNT(*) as count_pet
FROM pet;
xxxxxxxxxx
SELECT count(*)
FROM information_schema.columns
WHERE table_name = 'Your_table_nale';
xxxxxxxxxx
#The COUNT() function returns the number of rows that match specific characteristics.
SELECT
COUNT(*)
FROM
database_name.table_name