@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