learn

Handle strings and Unicode

Use parameterized queries to safely insert and fetch string data from the database. import mssql_python conn = mssql_python.connect(connection_string) cursor = conn.cursor() # Create temp table for ...
learn

Use bulk copy with mssql-python

The mssql-python driver includes a bulk copy feature that efficiently inserts large amounts of data into SQL Server, Azure SQL Database, Azure SQL Managed Instance, and SQL database in Microsoft ...
shattered.io

Switch 2 Games List: Build a Tracker in 12 Steps [2026]

Build a Python tracker for the Nintendo Switch 2 games list: scrape, dedupe, alert on new releases, and export a shareable ...
note

[Local AI Development Part 3] Saving Ollama Conversations and Search History to MySQL

The current Ollama model being used is gemma4:12b. The connection from Python to Ollama is managed via OLLAMA_API_URL, just as it was before. Regarding the MySQL connection, I have also updated it to ...
blog.csdn

Python 连 MySQL 总报 2003？把 pymysql 连接参数改到 TaoToken 的排查清单

Python 连 MySQL 总报 2003？把 pymysql 连接参数改到 TaoToken 的排查清单 凯二七墨衍会员·1平台·100+阅读墨衍智能分发本文由作者通过墨衍一键同步至各平台1分发平台100+累计阅读0平均单平台已同步平台CSDN微信公众号微博知乎掘金百家号博客园抖音小红书你的文章也可以这样分发墨衍会员 ¥399起/年，写一 ...
blog.csdn

数据库中文乱码怎么办？从字符集到连接层全链路排查与修复指南

这篇文章就是一份“存入数据库的数据出现中文乱码”的实战解决方案。我不会只扔给你一条修改命令，而是会带你从字符编码的基本原理出发，分别从应用程序层、连接层、数据库层、命令行和客户端工具几个层面，把乱码的成因和修复方法讲清楚。无论你用的是 MySQL、PostgreSQL，还是 SQL Server ...