@import url(http://www.tkk7.com/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 閱讀(1128)
評論(0) 編輯 收藏 所屬分類:
DB