REPLACE [LOW_PRIORITY | DELAYED]
[INTO] tbl_name [(col_name,...)]
VALUES (expression,...)
或 REPLACE [LOW_PRIORITY | DELAYED]
[INTO] tbl_name [(col_name,...)]
SELECT ...
或 REPLACE [LOW_PRIORITY | DELAYED]
[INTO] tbl_name
SET col_name=expression, col_name=expression,...
[INTO] tbl_name [(col_name,...)]
VALUES (expression,...)
或 REPLACE [LOW_PRIORITY | DELAYED]
[INTO] tbl_name [(col_name,...)]
SELECT ...
或 REPLACE [LOW_PRIORITY | DELAYED]
[INTO] tbl_name
SET col_name=expression, col_name=expression,...
str3+str2
这些只有自己搞定了。
[INTO] tbl_name [(col_name,...)]
VALUES (expression,...)
或 REPLACE [LOW_PRIORITY | DELAYED]
[INTO] tbl_name [(col_name,...)]
SELECT ...
或 REPLACE [LOW_PRIORITY | DELAYED]
[INTO] tbl_name
SET col_name=expression, col_name=expression,...这些不是mysql的语句吗!
mysql> SELECT REPLACE('www.mysql.com', 'w', 'Ww');
-> 'WwWwWw.mysql.com'
shuixin13(犬犬(心帆)) 非常感谢,但还是一个问题要请教,就是原来我str1和str2是连在一起的
,比如是“applebanana”如何将他拆出来apple和banana,谢谢
那得看你的str1+str2的组合规则了.