About the summary of the additional, deletion and modification operation course

Detailed graphic and text explanation of using SQL statements to operate data tables (phpMyAdmin usage tutorial 3) Click the "SQL" button in the main interface of phpMyAdmin to open the SQL statement editing area and enter the complete SQL statement to query the data. Add, modify and delete operations! In the previous article "Detailed graphic explanation of data table addition, deletion and modification operations (phpMyAdmin usage tutorial 2)", we introduced how to complete the operation, creation and deletion of data tables in the phpMyAdmin graphical management tool. Today we Let me introduce to you how to use SQL statements to operate data tables in the phpMyAdmin interface! 1. Use SQL statements to insert data. Use the insert statement item in the SQL statement editing area to insert data into the data table php.cn. Click the "Execute" button to insert a piece of data into the data table. If the submitted SQL statement contains errors, Then the system will give a warning and prompt the user to modify it, as shown below: If the SQL statement has no errors, click the "Browse" button in the upper left corner after submitting it to enter the data display page, as shown below: Tips:

1. Detailed introduction about the main interface

##Introduction: Use SQL statements to operate data tables Detailed graphic and text explanation (phpMyAdmin usage tutorial 3) Click the "SQL" button in the main interface of phpMyAdmin to open the SQL statement editing area and enter the complete SQL statement to implement data query, add, modify and delete operations! In the previous article "Detailed graphic explanation of data table addition, deletion and modification operations (phpMyAdmin usage tutorial 2)", we introduced how to complete the operation, creation and deletion of data tables in the phpMyAdmin graphical management tool. Today we Let me introduce to you...

2. Detailed graphic and text explanation of adding, deleting and modifying data tables (phpMyAdmin usage tutorial 2)

#Introduction: Operating a data table is based on selecting a specified database, and then creating and managing data tables in the database. Below we will introduce in detail how to create, modify and delete data tables!

3. Detailed graphic and text explanation of database addition, deletion and modification operations (phpMyAdmin usage tutorial 1)

Introduction: Whether it is a Windows operating system or a Linux operating system, the method of using the phpMyAdmin graphical management tool is the same.

4. Detailed introduction to the method of using PDO exec() function to query the number of affected rows after execution

Introduction: This article mainly introduces how PHP uses the exec() function under PDO to query the number of affected rows after execution. It analyzes the use of PHP in the form of examples. When pdo performs addition, deletion and modification operations, the exec() function queries the number of affected rows after the operation is executed. Related implementation tips and precautions, friends in need can refer to the following

5. mysql Commonly used basic operation syntax (3)~~Add, delete, and modify operations on data [command line mode]

Introduction: 1. Insert a single piece of data: insert into tablename (field name 1, field name 2,...) values ​​(value 1, value 2,...); As can be seen from the figure, each insert is not required. The fields all have values ​​(provided there are no relevant constraints), but it should be noted that the number of fields must be consistent with the number of subsequent values, the order of the custom fields, and the type must also be consistent, otherwise an error will be reported . In addition, if no fields are specified, all fields are selected by default, and each field must have a corresponding value, and it needs to be consistent with

6. mysql Commonly used basic operation syntax (2)~~Add, delete, and modify operations on tables [Command line mode]

: 1. Modify the table name: Alert Table Oldtableename Rename Newtableename; or Alert Table Oldtableename to Newtableename; Add one last Field column: Alter Table Tableename ADD attribute name attribute type; 3. Add field in the first column of the table: Alter Tabl

7. Thinking

This Brief introduction: The problem of copying stagnation in the master -slave replication structure is 1032 errors and 1062 errors, Among them, the 1032 error is that after the main library was successfully executed, it was found that this record could not be found from the library when it was update or delete. The 1062 error was that the primary key conflict could not be successful when the main library Insert was completed. These problems can be solved by skipping the error and the previous replication data verification repair, but the direct causes of these problems are that the main and slang data data is inconsistent. In addition to the inconsistent data that may occur in the logical replication itself, there is also a reason for the business side or developers in violation of the regulations to directly add and delete the operation on the preparatory library.

8. [MySQL 14] Trigger after and before

##Introduction: after completes the addition, deletion and modification of data first, and then triggers. The triggered statement is later than the monitored addition, deletion and modification operation, and cannot affect the previous addition, deletion and modification actions; that is to say, the order record is inserted first, and then the product is updated. Quantity;

9. JS to add, delete, and modify HTML tables

Introduction: This article mainly introduces JS to add, delete and modify HTML tables in detail. It has certain reference value. Interested friends can refer to it

10. P. When modifying the data in mysql, it is only valid for digital operations, and non -digital operations are invalid. What should I do? _PHP Tutorial

##Introduction: When PHP modifies data in MySql, it is only valid for numeric operations, not The digital operation is invalid, what should I do? . Problem description: Use PHP to modify the data from the MySQL database, and achieve the addition and deletion and modification (the database can be correctly connected). #[Related Q&A recommendations]:

mysql - Test the query efficiency of different sql statements

The above is the detailed content of About the summary of the additional, deletion and modification operation course. For more information, please follow other related articles on the PHP Chinese website!