The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
I want to know ,How to get list of project Key and Project namefor Jira project by Database Mysql
Welcome to the Atlassian Community!
I'd strongly recommend you don't go any further down the path of reading the database, it's the worst possible way you can report on Jira.
This quuery is however simple and safe - read the project table - it's got the key and next number to use in it amongst other project data (note next number - not necessarily the number of issues in the project)