Update ", 65,67,68,69," this type of Id field

2011-01-20  来源:本站原创  分类:Database  人气:103 

---- Update remove hw_dmt_zdk_test table stuname field '67 '
update hw_dmt_zdk_test t
set t.stuname = (case when instr (t.stuname, '67 ', 1,1)> 0 then
replace (replace (t.stuname, '67',''),',,',',')
else
t.stuname
end)

相关文章
  • Update ", 65,67,68,69," this type of Id field 2011-01-20

    ---- Update remove hw_dmt_zdk_test table stuname field '67 ' update hw_dmt_zdk_test t set t.stuname = (case when instr (t.stuname, '67 ', 1,1)> 0 then replace (replace (t.stuname, '67',''),',,',',') else t.stuname end)

  • Delphi BDE ('Type mismatch for field "xxxx", expecting: Integer actual: Float') 2010-05-21

    Encountered this problem, the database of a field, such as l_id type is number (10) IDE: delphi5; Database connection: BDE Database: oracle 10.2.0 Problem when adding fields, l_id is number (10) fair to say add fields should correspond to the TIntege

  • spring2 the way through jdbc to read. update the database clob or blob type of data 2010-02-05

    Today, due to the need for the project must be spring the way through jdbc to read and update the clob types of data, just the beginning, I get a data connection directly through the spring and then use the PreparedStatement handle, but the result wa

  • TimeStamp type in the field of Hinbernate small example of processing 2010-08-11

    Suddenly came a demand for the system to change all the time all the TimeStamp field type, since the use of the Hibernate persistence layer technology; here to do a little of the demo.

  • 如何打印没有重复数字的自然数字列表? 2013-10-17

    在问答区看到这个问题,下面7788的回答,真是千奇百怪. 因此,花了几分钟写了一下,不一定是最优解,但是效率和速度应该还可以,代码如下: public class Test1 { public static void main(String[] args) { long start = System.currentTimeMillis(); for (int i = 1; i <= 10; i++) { printNumberNotRepeat(i, new ArrayList<Integer

  • And N times better than they are in charge of trouble, is to contradict themselves ah! 2010-03-22

    Companies these days are busy with new products soon to be released, this does not have a client requests give them a test version, we present the condition is only Kongzhi 5 test platform of devices, Goodfellas, Zhuguangaile Tongxun bottom, I web co

  • linux command summary 2010-04-20

    Name: cat Permissions: All users way: cat [-AbeEnstTuv] [- help] [- version] fileName Description: The connection string to the file reached the basic output (screen or add> fileName to another file) Parameters: -N or - number from 1 to begin the lin

  • [Transfer] Cairngorm + BlazeDS integration of Flex + Java's Demo (example) 2010-10-09

    Go to: http://blog.dreamhui.net/archives/64 Today learning Cairngorm, Got me a tutorial, wrote a Demo, in order to record and share the learning process. Various parts of Cairngorm: ModelLocator: stored procedures in one place all the value object (V

  • JSP review notes - Chapter 10 The JSP + JDBC connect to the database management program message 2010-10-26

    JSP + JDBC Message Manager Java code Table 1 .-- Create Table 2 .-- user (login), message table 3. Delete Table 4 .-- 5.DROP TABLE person; 6.DROP TABLE note; 7. 8 .-- deleted sequence 9.DROP SEQUENCE note_sequ; 10. Create a sequence of 11 .-- 12.CREA

  • jquery1.43 animated part of the source analysis 2010-10-26

    js to achieve the principles of animation production with the same animation. Animation is little difference between the number of the original painting with a certain number of frames played. js animation is one of the elements by continuous change

  • Detailed Linux system commands and their use 2010-11-02

    cat cd chmod chown cp cut Name: cat Permissions: All users use: cat [-AbeEnstTuv] [- help] [- version] fileName Description: The connection string passed to the basic file output (screen or add> fileName to another file) Parameters: -N or - number fr

  • Redis memory storage structure analysis 2011-05-24

    1 Redis memory storage structure This article is based on the analysis Redis-v2.2.4 version. 1.1 Redis the overall structure of memory storage Redis support multiple key-value database (table), and with RedisDb to represent a key-value database (tabl

  • Detailed command and its use of Linux systems 2010-11-08

    [Size = large] [size = medium] [size = medium] [size = medium] Linux system commands and the use of explain (Daquan) (Source: China System Analyst) cat cd chmod chown cp cut Name: cat Access: All users use: cat [-AbeEnstTuv] [- help] [- version] file

  • linux command Daquan (full article) 2011-03-18

    cat cd chmod chown cp cut Name: cat Access: All users use: cat [-AbeEnstTuv] [- help] [- version] fileName Description: The connection string passed to the basic file output (screen or add> fileName to another file) Parameters: -N or - number from 1

  • [Transfer] Linux system commands and their use Detailed 2011-07-02

    Detailed command and its use of Linux systems (Source: China System Analyst) cat cd chmod chown cp cut Name: cat Access: All users use: cat [-AbeEnstTuv] [- help] [- version] fileName Description: The connection string passed to the basic file output

  • Detailed command and its use of Linux systems (Daquan network Abstract) 2011-07-22

    ( Source : China System Analyst ) cat cd chmod chown cp cut Name :cat Permissions : All users use :cat [-AbeEnstTuv] [--help] [--version] fileName Explain : The connection string passed to file the basic output ( Screen or additional > fileName To an

  • Detailed command and its use of Linux systems (Daquan) 2011-08-13

    Detailed command and its use of Linux systems cat cd chmod chown cp cut Name: cat Access: All users use: cat [-AbeEnstTuv] [- help] [- version] fileName Description: The connection string passed to the basic file output (screen or add> fileName to an

  • 初识NodeJS服务端开发(Express+MySQL) 2014-11-05

    NodeJS对前端来说无疑具有里程碑意义,在其越来越流行的今天,掌握NodeJS已经不再是加分项,而是前端攻城师们必须要掌握的技能.本文将与同志们一起完成一个基于Express+MySQL的入门级服务端应用,即可以对数据库中的一张表进行简单的CRUD操作.但本人还是斗胆认为,通过这个应用,可以让没怎么接触后端开发的同志对使用Node进行后端开发有一个大致了解. Express工程环境准备 1. 安装express,和express项目种子生成器(什么?你问第1步为什么不是安装NodeJS,我也只

  • Ibatis 3 的CRUD(增删改查) 2013-10-03

    1.目录结构 2.导入相应包 jdbc.properties 1 2 3 4 driver=com.mysql.jdbc.Driver url=jdbc:true&characterEncoding=utf-8 username=root password=root SqlMapper.xml 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 <?xmlversion="1.0"

  • AngularJS 数据建模 2014-10-03

    我们知道,AngularJS并没有自带立等可用的数据建模方案.而是以相当抽象的方式,让我们在controller中使用JSON数据作为模型.但是随着时间的推移和项目的成长,我意识到这种建模的方式不再能满足我们项目的需求.在这篇文章中我会介绍在我的AngularJS应用中处理数据建模的方式. 为Controller定义模型 让我们从一个简单的例子开始.我想要显示一个书本(book)的页面.下面是控制器(Controller): BookController 1 2 3 4 5 6 7 8 9 10