How to count multiple table rows in single query?

|
2021-06-10 20:23:43
socks proxy supports auth
Sonu 2021-06-11 13:21:53
Can we use php library imagick in php 8
2021-06-11 13:30:35
Got It
Sonu 2021-06-11 13:57:26
Sonu 2021-06-11 13:21:53
Can we use php library imagick in php 8

Anyone tell me please

gershom256 2021-06-11 14:29:39
codeslide-34436.jpg
any help please
D_deepak 2021-06-11 14:42:06
gershom256 2021-06-11 14:29:39
any help please

CREATE TABLE Worker(
WORKER_ID INT,
FIRST_NAME VARCHAR(10),
LAST_NAME VARCHAR(10),
SALARY INT,
JOINING_DATE date,
DEPARTMENT VARCHAR(10)
);

D_deepak 2021-06-11 14:42:19
Try this 👆
DollyMishra03 2021-06-11 15:12:02
codeslide-34442.jpg
Hello any one help please I am try to fix I can’t
Usama 2021-06-11 16:02:41
DollyMishra03 2021-06-11 15:12:02
Hello any one help please I am try to fix I can’t

Share your code

DollyMishra03 2021-06-11 16:19:59
codeslide-34446.jpg
Controller
DollyMishra03 2021-06-11 16:20:40
codeslide-34447.jpg

DollyMishra03 2021-06-11 16:21:10
codeslide-34448.jpg

Jordans_Telegram 2021-06-11 17:02:40
Count * from tablea

Count * from tableb

Count * from tablec

How to count multiple table rows in single query ??

Jordans_Telegram 2021-06-11 17:03:54
Anyone…?
Testusers 2021-06-11 17:10:34
Pls give count * from tablea,tableb,tablec
Testusers 2021-06-11 17:11:05
Is it ok
Khaldoon_1982 2021-06-11 17:11:48
Select count(*)
Jordans_Telegram 2021-06-11 17:15:55
Testusers 2021-06-11 17:10:34
Pls give count * from tablea,tableb,tablec

Not working

Jordans_Telegram 2021-06-11 17:16:09
Please send compelete query
acilaris 2021-06-11 17:16:44
i want share the code url but , i am not able to send
Jordans_Telegram 2021-06-11 17:16:59
Give space between them
Jordans_Telegram 2021-06-11 17:17:11
Or send screenshot plz
D_deepak 2021-06-11 17:17:19
How to learn php framework easy + intresting way to
Testusers 2021-06-11 17:18:26
Jordans_Telegram 2021-06-11 17:16:59
Give space between them

Have you got the answer

Jordans_Telegram 2021-06-11 17:18:33
No
Testusers 2021-06-11 17:19:21
Ok just wait I will test and reply
Jordans_Telegram 2021-06-11 17:19:30
Ok
Testusers 2021-06-11 17:35:06
SELECT ‘demo’ AS table_name, COUNT(*) FROM demo
UNION
SELECT ‘A’ AS table_name, COUNT(*) FROM A
UNION
SELECT ‘B’ AS table_name, COUNT(*) FROM B
Testusers 2021-06-11 17:35:34
Demo a b are 3 tables
Testusers 2021-06-11 17:37:09
Is it ok
Usama 2021-06-11 17:42:48
DollyMishra03 2021-06-11 16:19:59
Controller

You are using $results in your controller and in foreach you are using $result.
Try correcting the variable names.

Jordans_Telegram 2021-06-11 17:47:00
Testusers 2021-06-11 17:35:06
SELECT ‘demo’ AS table_name, COUNT(*) FROM demo
UNION
SELECT ‘A’ AS table_name, COUNT(*) FROM A
UNION
SELECT ‘B’ AS table_name, COUNT(*) FROM B

Not working

Testusers 2021-06-11 17:50:03
I used Oracle
h_a_r_s_a_l 2021-06-11 17:50:12
D_deepak 2021-06-11 17:17:19
How to learn php framework easy + intresting way to

Tell me also I also want to learn laravel

Testusers 2021-06-11 17:50:14
Which one you are
|