This article is an original work by Liu Feng from Yunbei Education. Please respect intellectual property rights. When forwarding, please indicate the source. No plagiarism, adaptations, or unauthorized reproduction is allowed. 1. Theory Analysis of Cursors 1.1. Concept and Function of Cursors A cursor is a database programming mechanism used to handle query result sets. … Read more
In this blog, we will delve into how to build an intelligent SQL query assistant using LangChain and LangGraph. This assistant can convert natural language questions into SQL queries, execute the queries, and provide human-friendly answers. More importantly, it supports human-machine collaborative workflows, allowing users to intervene at critical steps. 0. Initialize SQL Data We … Read more
I want to import data from an Excel file into a MySQL database table. First, I converted the Excel file to a CSV file. But for some reason, MySQL Workbench’s Table Data Import Wizard crashes after selecting the CSV file. So I thought, why not use Github Copilot to generate SQL to handle this? It’s … Read more