Execute multiple select queries in MySQL - SQLyog

Question

I am trying to execute two select queries like this in SQLyog

SELECT * FROM `admin`
SELECT * FROM `student`

I got this error

Then I tried adding semicolumn (;) at the end of first query

  SELECT * FROM `admin`;
  SELECT * FROM `student`

I am getting result of only second table

Then I tried this

  SELECT * FROM `admin`;
  SELECT * FROM `student`;

I got this error

Where m i missing?

Answer 1

Select(Ctrl+a) SQL query and try to execute..
There will be multiple Result tab for each result set as shown in image..,

.