MySQL is the most prevalent Open Source Relational SQL Database Management System.
Open Source – Any application program for which the original source code is made freely available and may be redistributed and modified.
Relational – A relational database fits more complicated systems by connecting information from two or more database tables that define relationships.
SQL– stands for Structured Query Language. It is a standard language to access and modify databases by executing queries against the database.
Database – A database is a collection of correlated data, usually stored and accessed electronically from a computer system.
Database Management System (DBMS) – A Database Management System is a software for storing, managing and retrieving users’ data by considering efficiency and suitable security measures.
Most commonly used MySQL commands:
Description | Query | Example |
---|---|---|
Create a database. Replace database_name with the name of the database that you want to create. |
|
|
List all the databases on the SQL server. |
|
|
Select and use a particular database to work with. |
|
|
Create a new table in the current database. |
|
|
Displays all the tables in the current database. |
|
|
Displays a detailed description of the attributes/fields in the given table. |
OR
|
OR
|
Add new rows of data to the table. |
OR
|
|
Display all the data from the table. |
|
|
Display a selective column from the table. |
OR
|
OR
|
Update existing records in a table |
|
|
To add, delete, or modify columns in an existing table |
OR
|
OR
|
Delete data from the table |
|
|
Delete the table data but not the schema |
|
|
Delete a table contents and the schema from the current database. |
|
|
Delete the database contents and the schema. |
|
|
My brother suggested I might like this web site. He was entirely right. This post truly made my day. You cann’t imagine simply how much time I had spent for this information! Thanks!
LikeLike