Thu, December 2, 2021

https://devcodepro.comdevcodepro

X

InterServer Web Hosting and VPS

Home · Latest · Trends

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: 1854 / 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

Login with Google

Share

Posted

Ronald

Ronald

Member since Sep 6, 2016

Total Points: 222

Total Code Snippets: 25

Total Comments: 2

Location: New Britain, Connecticut

Ronald snippets

Bind variables in ADODB

5 years ago, tue, sep 6, 16, 10:11:38

comments: 0 / hits: 2659

PHP

ADOdb Performance Monitor

5 years ago, tue, sep 6, 16, 10:18:23

comments: 0 / hits: 2504

PHP

Check if php mail function is enabled

5 years ago, tue, sep 6, 16, 10:42:24

comments: 0 / hits: 2896

PHP

Compare dates in smarty

5 years ago, fri, sep 16, 16, 1:10:12

comments: 0 / hits: 3371

PHP

Chrome input style

5 years ago, fri, sep 16, 16, 1:12:32

comments: 0 / hits: 2186

CSS

Get domain name without Tld

5 years ago, fri, sep 16, 16, 1:27:33

comments: 0 / hits: 3322

PHP

Validating international phone numbers

5 years ago, sun, sep 25, 16, 2:52:42

comments: 1 / hits: 2645

Smarty Remove BBCode

5 years ago, thu, nov 10, 16, 4:21:59

comments: 1 / hits: 2799

PHP

How to check if uploaded file is image in php

5 years ago, mon, nov 21, 16, 10:48:23

comments: 2 / hits: 10218

PHP

Web Analytics