LIKE \"%s\" AND t_branch <> \"000000\"是什么意思

sjzxtzhl 2008-03-04 03:11:42

SELECT DISTINCT t_branch FROM t_branch WHERE t_branch LIKE \"%s\" AND t_branch <> \"000000\"中的\"%s\"和\"000000\"是什么意思
为什么要 \"%s\" 表示
而不是"%s"或者"\%S\"

...全文

160 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

cloudflashes 2008-03-26

打赏
举报

\"%s\"其实就是"%s"，\是转义字符。

转义字符以反斜线\开头，后跟一个或几个字符。转义字符具有特定的含义，不同于字符原有的意义，故称“转义”字符。

估计你所列出的是嵌入在某个程序段里的SQL语句。通常的程序语言中，""是特殊字符，成对出现以用来括起一段字符串。如果在""括起的部分中，还包含有"，你就要用在前面加\来表明它是字符串的一部分，以免程序将它解释为右半个括号。

# that don't start with an underscore (but look like they should) # are compatible with macros generated by rpm-2.5.x and will be made # more consistent in a future release. # #======================...

inoremap <C-v> <esc>:set paste<cr>mui<C-R>+<esc>mv'uV'v=:set nopaste<cr> "在Visual模式中使用Ctrl+c复制内容到全局剪贴板 vnoremap <C-c> "+y "在Visual模式中使用Ctrl+x剪切内容到全局剪贴板 ...

MySQL·　性能优化·5.7 Innodb... CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements are not supported inside transactions when using GTIDs (that is, when the server was started with the ...

instructions() print(format_instructions) 输出结果如下， The output should be a markdown code snippet formatted in the following schema, including the leading and trailing "\`\`\`json" and "\`\`\`": #...

append_branch()Similarly to t_fork_to, it extends destination set by a new entry. The difference is that current URI is taken as new entry.Without parameter, the function copies the current URI into a