mysql拼接字符串函数
1.concat1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374mysql> select concat('drop ...
查询Oracle闪回区路径及闪回区目录大小
123456789101112131415161718192021222324(1) 查看闪回区是否开启SQL> select flashback_on from v$database(2) 查看闪回区大小SQL> show parameter retentionNAME TYPE VALUE-----------...
Oracle批量替换数据文件路径
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081---set newname for datafi...
Oracle批量重命名数据文件、重命令临时文件
12345678910111213141516171819202122232425262728293031323334353637383940414243Linux:---修改日志文件set linesize 200 pagesize 200 select 'alter database rename file '|| ...
一、Oracle12c 数据库自带的用户名123456789101112131415161718192021222324252627282930313233343536373839404142434445464748---12.1.0.2select username from dba_users where username not in ('SCOTT', ...
检查Oracle索引是否有效
123456789col owner for a10col table_name for a30col index_name for a30col status for a15col tablespace_name for a15set linesize 300 pagesize 300select owner, table_name, tablespace...
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970[oracle@server01:/home/oracle]$crontab -lYou (oracle) are not allo...
Mysql8.0安装Xtrabackup
一、Xtrabackup简介 Innobackupex is the symlink for xtrabackup. innobackupex still supports all features and syntax as 2.2 version did, but is now deprecated and will be ...
在遇到 MySQL 8报错 “error while loading shared libraries: libcrypto.so.3” 时，通常是因为系统找不到所需的 libcrypto.so.3 库文件，libcrypto.so.3 是 OpenSSL 3.0 中的一个库文件，MySQL 8.x 版本和一些 MariaDB 版本可能依赖这个库。
一、错误提示12[root@serve...
查看Mysql数据库占用空间大小
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576---统计各个数据库数据总量SELECT table_sche...
