Mysql basics 1: mysql Basics
I. Overview
1. What is a database?
A: Data Warehouse. For example, in the ATM example, we create a database directory called database.
2. What are MySQL, Oracle, SQLite, Access, and ms SQL Server?
A: They are both software and have two main functions:
- A. Save the data to a file or memory
- B. receive specific commands and perform operations on the files
PS: if the above software is available, you do not need to create files and folders on your own, but directly PASS commands to the above software for file operations. They are collectively referred to as database management systems (DBMS, database Management System)
3. What is SQL?
A: MySQL and other software mentioned above can accept commands and perform corresponding operations. Because the commands can include operations such as deleting files and obtaining file content, the command is an SQL statement. SQL