how to concat two query in my sql

Question

 select concat_ws((
select count(*) from feed_back where schedule_id=1),'/',(select count(*) from event_schedule_mapping where event_schedule_id=1))
as total

i am getting count from both query but when i try to concat it using concat_ws its give me blobdata as blank please tell me where am doing wrong please suggest.

snag.gy/OFZ8Yu.jpg in this screen see

Mhanaz Syed
– Mhanaz Syed

2016-11-03 12:45:42 +00:00
Commented Nov 3, 2016 at 12:45 — Mhanaz Syed
– Mhanaz Syed, Commented Nov 3, 2016 at 12:45

sagi · Accepted Answer · 2016-11-03 12:35:41Z

0

Why concat_ws() and not concat() ?

SELECT CONCAT( (First Select),
                '/'
               (Second Select)) as total

answered Nov 3, 2016 at 12:35

sagi

40.6k7 gold badges66 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mhanaz Syed Over a year ago

same thing i did then also same issue still am getting Blob type data with blank

Carlos Laspina · Accepted Answer · 2016-11-03 12:45:05Z

0

Try this, using the separator first:

    SELECT CONCAT_WS('/', 
        (select count(*) from feed_back where schedule_id=1), 
        (select count(*) from event_schedule_mapping where event_schedule_id=1))

String Functions - MySQL CONCAT_WS

edited Nov 3, 2016 at 12:45

answered Nov 3, 2016 at 12:38

Carlos Laspina

2,3014 gold badges29 silver badges44 bronze badges

3 Comments

Mhanaz Syed Over a year ago

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select count() from feed_back where schedule_id=1),'/', (select count() from ev' at line 1

Carlos Laspina Over a year ago

try running each query separately, to see the values that returns, look at this example. Is a simple function, you should not have any problem.

Carlos Laspina Over a year ago

looking for a bit, I found this, you could try it and let me know

saravanan · Accepted Answer · 2016-11-03 13:00:32Z

0

Try Like this

SELECT sum(a+b) as total FROM (SELECT count(*) as a from feed_back where schedule_id=1) as x, (SELECT count(*) as b FROM event_schedule_mapping where event_schedule_id=1) as y

answered Nov 3, 2016 at 13:00

saravanan

1455 bronze badges

Collectives™ on Stack Overflow

how to concat two query in my sql

3 Answers 3

1 Comment

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related