What is the difference between modifying ordinary string and date data in mysql?
The string types are different. For common string types (such as VARCHAR or TEXT), you can directly modify them with string values, such as the condition of update table name set column name =' new string' where. If the string value contains single quotation marks, you need to deal with it with escape characters or enclose the string with double quotation marks.