@import url(http://www.tkk7.com/CuteSoft_Client/CuteEditor/Load.ashx?type=style&file=SyntaxHighlighter.css);@import url(/css/cuteeditor.css);
1、模糊匹配時(shí)忽略大小寫(xiě)
select * from table where lower(name) like lower('%a%');
2、去除某一列的尾部空格
update table_name set column_name=trim(column_name);
3、查看某個(gè)表的字段是否為空的語(yǔ)句：
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 閱讀(1127)
評(píng)論(0) 編輯 收藏 所屬分類(lèi):
DB