MYSQL:更新 [英] MYSQL:Update

问题描述

如何分隔该字符串:今天是"Peter"的美好时光

how to delimit this string: It''s a nice day "Peter"

UPDATE `nemotherm`.`orderitems`
  SET `orderitems`.`message` = 'It's a nice day "Peter"

推荐答案

看看

Take a look at this[^]. Pay particular attention to the table of Escape Character Sequences.

The backslash is a pretty standard escape character, used in many languages.

使用MySQL API中的

use the

mysql_real_escape_string()

或

mysql_odbc_escape_string()

.

这篇关于MYSQL:更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！