How to count the number of records in a table?

C

C

Chesterfield252021-07-01 23:45:47

SQL

Chesterfield25, 2021-07-01 23:45:47

How to count the number of records in a table?

What sql query is needed to display the amount of materials?
For example, I have a table xf_list. I need to find out how much data is in this table.

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

V

Vasily Bannikov, 2021-07-01
@vabka

select count(*) from xf_list

Similar questions

T

tolanych2017-04-12 10:28:41

How to correctly implement validation when binding two text-boxes? 5Reply

D

Denis Ruchiev2016-12-29 19:34:43

How does sum work with two JOINs? 2Reply

V

Vlad_isLove2019-05-26 20:28:19

Is it possible to store a SQL query in a PHP session variable? 2Reply

M

mazahakas2015-01-04 22:58:24

I can't write sql query, how can I do it? 2Reply

M

Mark2021-01-22 17:02:50

How to get any one record from a table, with the condition that there will be no record with a certain value in the associated table? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question