What is MySQL database?

Easy of Use

Mysql is user-friendly.
Any one learn fast and working on with minimum effort.
MySql Provide proper graphical user interface (GUI) interface so user easily perform every activity

Scalability

MySQL is handle small project database same like handle and manage big level enterprize data , easily manuputate data using graphical user interface (GUI) and structured Query Language(SQL).

Strong Community Support

MySQL has a large community. This community suport to begginer to grow and when any problem come you can directly search on google and many answer available related to problem.
Large learning platform related MySQL, available tutorial and troubleshooting help.

Integration with Other Technologies

MySql easy to integrates with most of programming languages like php ,python , etc. very easy setup and connect mySQL database with programming languages.

Structure and Storage

MySQL store data in tables formate of row and column. Mysql every table have schema, schema save detail about table like coloumn name , datatype , key types etc.

CRUD Operations

Indexes and Primary Keys

MySql Use index for retrived data faster and same primary key use for seprate row every row have a unique id this called primary key.

Joins and Relations

MySQL use join and relation for get data from multiple table based on relation. relationships like one-to-many or many-to-many.

SQL Queries for Interaction

MySQL use structured Query Language (SQL) for Interaction to MySQL database

• create a Database: a Database: CREATE DATABASE have_fun_with_code;
• Create a Table: CREATE TABLE fun_users (id INT PRIMARY KEY, name VARCHAR(100));
• Insert Data: INSERT INTO fun_users (id, name) VALUES (1, 'Alice');
• Retrieve Data: SELECT * FROM fun_users WHERE name = 'ajay';
• Update Data: UPDATE fun_users SET name = 'sbi' WHERE id = 1;
• Delete Data: DELETE FROM fun_users WHERE id = 1;

Backup and Recovery

You can backup your database in file export database in local