Do i need to go to cmd and execute “mysql -u root -p” command first ,to execute mysql commands. Isn’t there any direct method to use sql commands on mysql.
Answers:
Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.
Method 1
You can try using MySQL Workbench for executing sql commands instead of cmd. In the latest versions of mysql installer, MySQL Workbench exists by default. So you can also try to upgrade your sql version. You can download latest version as per your os by this link: download
Method 2
there is many SQL tool for this, sharing you a blog please consider for the best choice.
https://www.guru99.com/top-20-sql-management-tools.html
All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0