I am accustomed to using SQL Sever to directly design the database every time, but do not pay enough attention to SQL statements. I took the opportunity of this reconstruction of the computer room cooperation version to use SQL statements to design the database and at the same time Let’s sort out the basic usage of SQL statements.
【Classification】
There are 9 types of SQL statements, which can be roughly divided into 4 types according to their functions:
1. Query statement: select ----The most commonly used statement in the database
2. Data definition: create, drop, alter----for Operations on databases, data tables, and fields in tables
3. Data manipulation: insert, update, delete----the legendary "add, delete, modify, query", for specific Data operations
4. Data control: grant, revoke----definition and deletion of permissions
If you have learned the operating system, you will not be very familiar with these definition statements. Strangely enough, a database group file is also a kind of file and needs to have a logical name (i.e. file name), physical name (actual storage address on the disk), file size, etc.; the log file records all logical operations in the database, with details such as advantages and disadvantages. For the content, see Baidu Encyclopedia: Log file
[cascade|restrict] --Delete table, with constraints Restrict
must be added to the condition
3. Query statement:
Regular The query statement is: select * from datatable
It should be noted that nested and connected queries are queried from multiple tables. This combination relationship is commonly used in M:N relationships. Find the corresponding relationship.
select TB1.column1,TB1.column2
from TB1
where TB1.column1 in（select column1
from TB2
where TB2.column2="特定值"）；
Copy after login
This relationship is not recommended for users with confusing logic, as it is particularly likely to cause search failure.
set ##5. Embedded SQL usage technology, commonly used execution views, stored procedures, etc., add exec to execute
[Summary]
Knowledge is always like this , you will gain different results every time you study, especially after using it, you will try to compare the differences between different methods. I look forward to the next comparative study of database views, stored procedures and security settings.
The above is the content of a large collection of MySQL sql basic statements. For more related content, please pay attention to the PHP Chinese website (www.php.cn)!
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
MySQL and phpMyAdmin are powerful database management tools. 1) MySQL is used to create databases and tables, and to execute DML and SQL queries. 2) phpMyAdmin provides an intuitive interface for database management, table structure management, data operations and user permission management.
Compared with other programming languages, MySQL is mainly used to store and manage data, while other languages such as Python, Java, and C are used for logical processing and application development. MySQL is known for its high performance, scalability and cross-platform support, suitable for data management needs, while other languages have advantages in their respective fields such as data analytics, enterprise applications, and system programming.
In MySQL, the function of foreign keys is to establish the relationship between tables and ensure the consistency and integrity of the data. Foreign keys maintain the effectiveness of data through reference integrity checks and cascading operations. Pay attention to performance optimization and avoid common errors when using them.
The main difference between MySQL and MariaDB is performance, functionality and license: 1. MySQL is developed by Oracle, and MariaDB is its fork. 2. MariaDB may perform better in high load environments. 3.MariaDB provides more storage engines and functions. 4.MySQL adopts a dual license, and MariaDB is completely open source. The existing infrastructure, performance requirements, functional requirements and license costs should be taken into account when choosing.
SQL is a standard language for managing relational databases, while MySQL is a database management system that uses SQL. SQL defines ways to interact with a database, including CRUD operations, while MySQL implements the SQL standard and provides additional features such as stored procedures and triggers.
Abstract of the first paragraph of the article: When choosing software to develop Yi framework applications, multiple factors need to be considered. While native mobile application development tools such as XCode and Android Studio can provide strong control and flexibility, cross-platform frameworks such as React Native and Flutter are becoming increasingly popular with the benefits of being able to deploy to multiple platforms at once. For developers new to mobile development, low-code or no-code platforms such as AppSheet and Glide can quickly and easily build applications. Additionally, cloud service providers such as AWS Amplify and Firebase provide comprehensive tools
MySQL and phpMyAdmin can be effectively managed through the following steps: 1. Create and delete database: Just click in phpMyAdmin to complete. 2. Manage tables: You can create tables, modify structures, and add indexes. 3. Data operation: Supports inserting, updating, deleting data and executing SQL queries. 4. Import and export data: Supports SQL, CSV, XML and other formats. 5. Optimization and monitoring: Use the OPTIMIZETABLE command to optimize tables and use query analyzers and monitoring tools to solve performance problems.
