透视mysql更新语句（Perspective MySQL UPDATE statement）.docVIP

透视mysql更新语句（Perspective MySQL UPDATE statement） SQL used to operate the database is generally divided into two kinds, one is the query statement, that is, we call the SELECT statement, and the other is the updated statement, also known as data manipulation statement. The implication is that the data is modified. There are 3 statements in the standard SQL, which are INSERT, UPDATE, and DELETE. There is another REPLACE statement in MySQL, so this article discusses how to make update statements in SQL with MySQL as the background. One, INSERT and REPLACE The function of INSERT and REPLACE statements is to insert new data into a table. The syntax of the two statements is similar. Their main difference is how to deal with repeated data. 1., the general use of INSERT The INSERT statements in MySQL are different from the standard INSERT. In standard SQL statements, there is only one form of a INSERT statement that inserts a single record at a time. INSERT INTO tablename (column name)... ) VALUES (column value); And theres another form in MySQL. INSERT, INTO, tablename, SET, column_name1 = value1, column_name2 = value2,... ; The first method separates column names from column values, and when used, column names must be consistent with the column values. If the following statement inserts a record into the users table: INSERT, INTO, users (ID, name, age), VALUES (123, ` Yao Ming , 25); The second method allows column names and column values to appear and use in pairs, such as the following statement that will produce the effect of the sample. INSERT, INTO, users, SET, id = 123, name = ` Yao Ming , age = 25; If you use the SET method, you must assign at least one column. If a field uses a missing value (such as default or self increment), these two methods can omit these fields. If the value increment is used on the ID field, the above two statements can be written as follows: INSERT, INTO, users (name, age), VALUES (` Yao Ming , 25); INSERT, INTO, uses, SET, name = ` Yao Min