随笔-193  评论-715  文章-1  trackbacks-0
@import url(http://www.blogjava.net/CuteSoft_Client/CuteEditor/Load.ashx?type=style&file=SyntaxHighlighter.css);@import url(/css/cuteeditor.css); 1、模糊匹配时忽略大小写
select * from table where lower(name) like lower('%a%');

2、去除某一列的尾部空格
update table_name set column_name=trim(column_name);

3、查看某个表的字段是否为空的语句:
select column_name,nullable from cols  t where t.table_name like '%GROUP_INFO';
posted on 2006-08-18 15:02 Robin's Programming World 阅读(1124) 评论(0)  编辑  收藏 所属分类: DB

只有注册用户登录后才能发表评论。


网站导航: