Do you want me to read them till you rest before your deadline?

Thanks Ilia . 👍

I know sql, but this a sppecial issue

If you know SQL then just wrote SQL queries to get to the user the data he needs. Don’t create pagers they are useless.

I need to retrieve all data in database, but as you know it’s not practicable to retrieve then at once.
So I have to retrieve them as bullks (pages)

This is a wrong approach, at all, you should not retrieve all data, it is useless for the user and harmful for performance

What is not clear?

Define variables

yes

It depends on the stucture of OCCUPATION table

OCCUPATION is the table

It is a little bit stupid query, not a good example, no need to explain it.

In particular, the subquery is not needed, neither is order by.

It tries to use a numeric Function On a string alias field… Maybe mysql makes string to INT conversión, but can’t imagine why using min()

Also defines and never retrieves 4 variables.

At least, name seems a string field

Can someone please share document for performance tuning in mysql step by steps ..

https://dev.mysql.com/doc/refman/8.0/en/optimization.html

Hi,
I want to find out the indexes having same names but on different tables in the same schema in MySQL. I am using MySQL 5.1

E.g – EmpID_IDX1 on Employee(EmpID)
EmpID_IDX1 on Department(EmpID)

I want table name, index name fields as output. How I could have this output?

This is possible, Look at the tables in information_schema database. All meta information is there

Thanks, did it another way

Just ask your question

Don’t do it

If you don’t want to know it then it’s better just stop

There are only two options: you do it and you don’t. It wouldn’t make even a bit of sense if it will be solved by someone else

Yes you are right! Assignment exactly for filter people who can’t do it without help from outside

Google has even more that you need

To complete that task instead of you would been a terrible disservice from us to you

Okay. What is unclear for you?

Do you want me to read them till you rest before your deadline?

I don’t know it you are right one more time. But I don’t see any problem caused by this fact!

Make yourself to know it through reading docs and articles will be much more effective than asking chat. Especially when almost everyone there sleep.

Almost the same efficiency as my tonight English lesson!

Notice please that I don’t cry about my English is poor. If I would do that, it will definitely kept poor.

Instead of it I just work on it. Yes it is not ideal and I have a lot of mistakes

But it is improving every day

Do the same and don’t scare of deadlines

Please ask only exact questions with maximum detailed explanation to the chats