qq_43084261的博客

【Postgresql 基础】查询昨天、本周、本月、上月、本年统计数据1、获取当前系统时间select now();select current_timestamp;# now()/current_timestamp展示当前系统的时间，日期格式2、获取当前日期或时间select current_date;# 当前日期select current_time;# 当前时间3、查询偏移时间select (now() - interval '1 day') # 将查询时间结果偏移一天

ORA-00257表示oracle日志文件已满，需清理日志空间rman命令清理日志# rman target sys/pass检查一些无用的archivelogRMAN> crosscheck archivelog all;删除过期的归档RMAN> delete expired archivelog all;删除截止到前一天的所有archivelogdelete archivelog until time 'sysdate-1' ;使用 dba角色登陆sqlplus

– 修改数据库字符集alter database tkp_tn character set utf8 COLLATE utf8_general_ci;– 字段的字符集SELECT CONCAT('ALTER TABLE ', table_name, ' MODIFY ', column_name, ' ‘, DATA_TYPE, ‘(’, CHARACTER_MAXIMUM_LENGTH, ...

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘eral_tkp.eb_user.UserID’ which is not functionally dependent on columns in GROUP BY clause; this is incompatib...