Starting off with MySQL shell 8.0 on Windows
Database is mainly used in storing data in the form of records(rows) and fields(columns). MySQL is an open source relational database management system which provides us with a wide variety of tools for managing the database. Recently when I installed MySQL installer which consisted of: MySQL Server MySQL Connectors MySQL Workbench and sample models Sample Databases MySQL for Excel MySQL Notifier MySQL for Visual Studio Documentation MySQL shell was an interactive Javascript, Python, or SQL interface supporting development and administration for the MySQL Server and is a component of the MySQL Server. Initially, I had some difficulty to start and work with MySQL shell which was slightly different from the traditional MySQL shell in terms of connecting and many more features. If we need the traditional mysql shell C:\Program Files\MySQL\MySQL Server 8.0\bin > mysql -u user -p eg: mysql -u root -p then it will a...