Wed, April 14, 2021
 
https://devcodepro.comdevcodepro
Home · Latest · Trends  /  SQL
3

Select one table count(*) from multiple tables MySQL

Select from one table count(*) from two tables MySQL
SELECT *, 
(SELECT COUNT(postid) FROM posts where user = 4) AS counter,
(SELECT COUNT(revid) FROM reviews where userid = 4) AS counters
FROM users where usid = 4 LIMIT 1
rated 3 times (3) (0)
comments: 0 / hits: 1692  / 4 years ago, wed, aug 2, 17, 05:43:46
More From » SQL
 

Comments

There are no comments for this Snippet yet
Only authorized users can post. Please sign in first, or register a free account
 
Share
Posted
Ronald
Member since Sep 6, 2016
Total Code Snippets: 23
Total Comments: 1
Location: New Britain, Connecticut
Ronald snippets
5 years ago, tue, sep 6, 16, 10:11:38
comments: 0 / hits: 2328
PHP
5 years ago, tue, sep 6, 16, 10:18:23
comments: 0 / hits: 2235
PHP
5 years ago, tue, sep 6, 16, 10:42:24
comments: 0 / hits: 2527
PHP
5 years ago, fri, sep 16, 16, 1:10:12
comments: 0 / hits: 2801
PHP
5 years ago, fri, sep 16, 16, 1:12:32
comments: 0 / hits: 2021
CSS
5 years ago, fri, sep 16, 16, 1:27:33
comments: 0 / hits: 3003
PHP
5 years ago, sun, sep 25, 16, 2:52:42
comments: 1 / hits: 2373
5 years ago, thu, nov 10, 16, 4:21:59
comments: 1 / hits: 2479
PHP
4 years ago, mon, nov 21, 16, 10:48:23
comments: 2 / hits: 7777
PHP