DataBase entry count

[JeViCo]

Hello everyone! I have a question from topic - how can i count entries from sqlite/mysql database?

For example i have a table called "houses" and some entries in it like "id", "owner", "price" etc.

I need to make house limit (3 per owner). I know that this is possible for simple tables. Is it possible here too?

[IIYAMA]

Use the aggregate COUNT function:

https://dev.mysql.com/doc/refman/5.7/en/counting-rows.html

 

Here you have more related functions:

https://dev.mysql.com/doc/refman/5.7/en/group-by-functions.html

[JeViCo]

12 minutes ago, IIYAMA said:

Use the aggregate COUNT function:

https://dev.mysql.com/doc/refman/5.7/en/counting-rows.html

 

Here you have more related functions:

https://dev.mysql.com/doc/refman/5.7/en/group-by-functions.html

Thank you!

[Pirulax]

@IIYAMA

How should be this used?With dbPoll?

[IIYAMA]

dbQuery + dbPoll for sql.