Replace function in MySQL
来源:互联网 发布:80端口被占用怎么解决 编辑:程序博客网 时间:2024/04/30 12:18
I want to Replace a column of data to empty if length(column)<6. D1i@@>9sh
2?85Z$j
First of all, I searched "Replace" statement 2~$D< ;$H
+[q&3X9:%
Replace into test_out_realtime SET `PROGRAM` = replace( PROGRAM, '%', '' ) WHERE length( program ) <6 dv%AX8 G
MySQL 5 returns "Error", seems Replace cannot use WHERE condition at back... Y7tPq:i z
|X3B$H
l;AesFRbw
then I tried to use UPDATE, it WORKS!! - sKU;+b a
!(T.+c
update test_out_realtime xj~_uK /
set PROGRAM = '' Q1=,Gc&
where length(PROGRAM) < 6 dF5x>/:
y ?% ==
{"Pi=7g<7g
then !8A^o-+#
select distinct PROGRAM from test_out_realtime where length(PROGRAM) < 6 e<hS*q]
It gives me empty, that means I have replaced all Program legnth < 6 to "empty"
2?85Z$j
First of all, I searched "Replace" statement 2~$D< ;$H
+[q&3X9:%
Replace into test_out_realtime SET `PROGRAM` = replace( PROGRAM, '%', '' ) WHERE length( program ) <6 dv%AX8 G
MySQL 5 returns "Error", seems Replace cannot use WHERE condition at back... Y7tPq:i z
|X3B$H
l;AesFRbw
then I tried to use UPDATE, it WORKS!! - sKU;+b a
!(T.+c
update test_out_realtime xj~_uK /
set PROGRAM = '' Q1=,Gc&
where length(PROGRAM) < 6 dF5x>/:
y ?% ==
{"Pi=7g<7g
then !8A^o-+#
select distinct PROGRAM from test_out_realtime where length(PROGRAM) < 6 e<hS*q]
It gives me empty, that means I have replaced all Program legnth < 6 to "empty"
- Replace function in MySQL
- PHP错误:Warning: preg_replace() [function.preg-replace]: Unknown modifier '[' in
- use mysql replace something in dedecms
- Mysql,replace函数,in函数用法
- Oracle/PLSQL: Replace Function
- Extension of Group by Function in MySQL
- mysql replace
- mysql replace
- MYSQL replace
- mysql replace
- MySQL replace
- PostgreSQL customize inet_aton, inet_ntoa function in text type like MySQL.
- Error calling Python module function in MySQL Workbench
- JavaScript replace() 方法 之 var.replace is not a function
- mysql replace用法
- MySQL replace statement
- MySQL replace into 用法
- MySQL Replace 的使用
- Javascript 读写文件的一个例子
- Php部分常见问题总结
- how to enable or disable registry editing in xp
- Invalid postback or callback argument
- Microsoft Access: ActiveX component cannot create object
- Replace function in MySQL
- 富人和穷人的12大经典差异
- Critical analysis of SAP HR module (Part 1)
- ASP.NET程序中常用的三十三种代码一
- 优秀Java开源项目
- 用ASP把图片存入数据库
- java.util下的Timer,TimerTask和quartz的比较
- 好的网址
- 2007经典妙语