How to Show how many rows in airtable or mysql in lable

Discuss
#1

How to show how many rows(Total Number) are in airtable or mysql in lable

#2

The ‘Got all rows’ block contains total rows variable

#3

But in My Sql Database Extension

#4

There is a channel named Deep Host on You tube from there you can clear your all doubt. Just watch that video …
Thanks

#5

I’m Already Using Deep Host Mysql Database Extension But There is no option to get total rows

#6

image
You can use these

#7

It is showing all values not total Rows Number

#8

For Airtable:
image

And for MySql:

image
image837×491 63.9 KB

P.S. don’t forget to subtract 1 from length of list as columns are also returned in response content

3 Likes
#9

Just use raw query block and run this mysql query for count rows
SELECT COUNT(column_name) FROM table_name
Same query should be used with condition.
It count rows and return not provide row data

#10

SELECT COUNT(*) FROM Sales.Customer

I have already Found This Code on Internet but i dont know what is star icon this is the reason i have asked this question. Thanks

Is it possible to open app using my website

#11
  • icon means select all
#12