Install MySQL most used DB of industry

Опубликовано: 29 Сентябрь 2024
на канале: Alosha - a place for technology lovers.

There are many databases into the market, however MySQL is the one which is really one of the best opensource DB available today. My next video is going to be on Spring Data JPA but before that I wanted to make sure you all have one of the best and reliable DB onto your system. Obviously you can go with other DB like H2 and all as well.

This video will guide you for installation of MySQL DB on windows machine. Also I will be covering some of the basic DB command to start with :-

1. Used to show all the database
show databases;
2. Used to clear MySQL client command window
system cls;
3. To create a database
create database database_name;
4. To drop a database
drop database database_name;
5. select/choose a database
use database_name;
6. Show tables of connected database
show tables;
7. Describe/Info about tables
describe table_name;

If you like the video then give a thumps up.

Thanks!