an74520的专栏

select * from table where temp <> '擦擦';如果temp里面的除了"擦擦"数据,其它为null则使用下面的sql语句select * from table where isnull(temp,'')

-- 创建临时表空间create temporary tablespace spaceNametempfile 'E:\oracle\product\10.2.0\oradata\orcl\stbss_temp01.dbf'tempfile 'size 32mautoextend onnext 32m maxsize 2048mextent management local--创建

CREATE TABLE `sunmnet_visit_record` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键ID' ,`ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'ip地址' ,`brow...