mysql query

divyashree · 12-12-2013, 12:10 AM

I have 3 tables a,b,c in a mysql db.

PHP Code:



select count(*)  from services a inner join objects b  ON a.service_id=b.object_id where b.name=@var;

The above join will give me counts where the @var variable will be selected from a row in table c.

The output will print the rowname(@var) and its count from join statement.

I will query the table c by:

Quote:

select d_name from host;

Can any one help me with writing this cursor with REPEAT.

Sydney · 12-15-2013, 06:52 PM

Hi have you checked out this documentation from the comments you may find Loop to be easier to do this with.