/SQL/Sql query to get the number of rows in a table

Sql query to get the number of rows in a table

To count number of rows in SQL table

SELECT count(*)
FROM information_schema.columns
WHERE table_name = 'Your_table_nale';

6

Sql query to get the number of rows in a table

select count(*) from tablename

0

Source: stackoverflow.com

Similar codes

0 vote255 views1 answer
How to connect pgadmin with excel
SQL
0 vote242 views1 answer
Mysql begin statement
SQL
0 vote258 views2 answers
How to tun mysql on ubunto
SQL
1 vote261 views2 answers
Install mysqldump ubuntu
SQL
0 vote256 views1 answer
Call procedure in wordpress
SQL
0 vote244 views1 answer
Mql5 list all available symbols
SQL
0 vote252 views1 answer
Which MySQL data type to use for storing boolean values
SQL
17 votes252 views3 answers
How to change a collumn name in sql
SQL
0 vote270 views1 answer
Mysql last friday of current month
SQL
0 vote273 views2 answers
What is rownum in oracle
SQL

Share