springboot集成duckdb
DuckDB 是一个开源的 嵌入式分析型数据库管理系统(DBMS),设计用于高效地执行 OLAP(联机分析处理) 查询。它的目标是像 SQLite 一样易于嵌入,但专注于分析型工作负载,而不是事务型(OLTP)工作负载。 ✅ DuckDB 的核心特点: 表格 复制 特性 描述 嵌入式 无需服务器,直接嵌入到应用中(类似 SQLite)。 列式存储 数据按列存储,适合分析型查询。 SQL 支持 支持标准 SQL,包括窗口函数、CTE、JOIN、子查询等。 零依赖 单文件 C++ 库,易于集成。 高性能 向量化执行引擎,适合大数据量聚合...
MYSQL AES解密
SET block_encryption_mode = 'aes-256-ecb'; SELECT u.`id` AS `id`, u.`username` AS `username`, u.`unionid` AS `unionid`, u.`openid` AS `openid`, CONVERT(AES_DECRYPT(FROM_BASE64(u.`country_code`), '32位秘钥') USING utf8mb4) AS `country_code`, CONVERT(AES_DECRYPT(u.`tel`, '32位秘钥') USING utf8mb4) AS `tel`, CONVERT(AES_DECRYPT(u.`district`, '32位秘钥') USING utf8mb4) AS `district`, CONVERT...
docker定时任务Mysql脚本
#!/bin/bash # 定义备份参数 number=31 backup_dir=/root/mysqlbackup dd=`date +%Y-%m-%d` tool=docker exec -i mysql mysqldump username=root password=123456 database_name=dbname # 如果备份目录不存在,则创建 if [ ! -d $backup_dir ]; then mkdir -p $backup_dir; fi # 执行mysqldump命令备份数据库 docker exec -i mysql mysqldump -u$username -p$password. $database_name>$backup_dir/bangong_$dd.sql # 记录备份日志 echo "create $backup_dir/$database_name-$dd.sql...
docker安装mysql8注意事项
my.cnf [mysqld] lower-case-table-names=1 log-bin=/var/lib/mysql/mysql-bin server-id=1 binlog_expire_logs_seconds=259200 pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock datadir = /var/lib/mysql secure-file-priv= NULL character_set_server=utf8 collation-server=utf8_general_ci max_connections=1000 [client] default-character-set=utf8 docker-compose.yml version : '3' services: mysql: ...
.NET8 Mysql SSL error
参考 dockerfile: #See https://aka.ms/customizecontainer to learn how to customize your debug container and how Visual Studio uses this Dockerfile to build your images for faster debugging. FROM mcr.microsoft.com/dotnet/aspnet:7.0 COPY --from=mcr.microsoft.com/dotnet/aspnet:8.0 /usr/share/dotnet /usr/share/dotnet #USER app WORKDIR /app EXPOSE 80 COPY ./bin/Release/net8.0/publish . ENTRYPOINT ["dotnet", "web.pc.dll"]
定时备份docker中的mysql
docker exec mysql /bin/bash -c 'mysqldump -uroot -pPASSWORD --databases confluence ' >/mnt/home/brucehe/confluence/backup/confluence_`date +%F`.sql; gzip /mnt/home/brucehe/confluence/backup/confluence_`date +%F`.sql; crontab表达试: sudo crontab -e 0 1 * * * backupmysql.sh #每天晚上1点执行 注意:一定要删除命令(docker exec -it)中的 -it, 因为-it会开启新的终端,而cron表达试及service等不支持交互试的命令执行。
docker-compose通过容器名连接mysql
这是Mysql的配置: version :'3' services: desneyMysql: container_name: app_mysql image: mysql:5.7 build: context:./mysql ports: -"3307:3306" volumes: -./mysql/conf:/etc/mysql/conf.d -./mysql/logs:/logs -./mysql/data:/var/lib/mysql command:[ 'mysqld', '--innodb-buffer-pool-size=80M', '--character-set-server=utf8mb4', '--collation-server=utf8mb4_unicode_ci', '--default-time-zone=+8:00', '--lower-case-table-names=1' ] environment: MY...
unity3d mysql error: The given key was not present in the dictionary.
please update(upgrade) your mysql.data.dll to right version.
MySQL 批量修改数据表编码及字符集
一、 修改数据库编码及字符集 修改数据库编码及字符集比较简单: <span class="token keyword">ALTER</span> <span class="token keyword">DATABASE</span> db_name <span class="token keyword">CHARACTER</span> <span class="token keyword">SET</span> <span class="token operator">=</span> utf8mb4 <span class="token keyword">COLLATE</span> <span class=&qu...
Your database must use ‘READ-COMMITTED’ as the default isolation level.
create database confluence default charset utf8 collate utf8_bin; SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED;