whystea5

SELECT
TABLE_NAME AS '表名',
COLUMN_NAME AS '字段名',
DATA_TYPE AS '数据类型',
IS_NULLABLE AS '是否可空',
COLUMN_DEFAULT AS '默认值',
COLUMN_COMMENT AS '字段注释',
CHARACTER_MAXIMUM_LENGTH AS '字符最大长度',
NUMERIC_PRECISION AS '数值精度',
NUMERIC_SCALE AS '小数位数'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'practice_db'
ORDER BY TABLE_NAME, ORDINAL_POSITION;

sql-查表结构
llm-根据sql和输入，生成sql语句，（根据输入和sql查询结果编写select语句，要求输出只是完整的select没有其他额外信息，要告诉用户的输入）
sql:根据生成的sql语句，查询
llm:整理成json
代码：整理成echart
echart：作图
输出