LQAgentPlatform/config/sql/test.sql

 -- 测试信息表

CREATE TABLE IF NOT EXISTS test_tab (
    id INT AUTO_INCREMENT PRIMARY KEY COMMENT '用户唯一标识符',
    name VARCHAR(100) NOT NULL COMMENT '用户姓名',
    email VARCHAR(100) UNIQUE NOT NULL COMMENT '用户邮箱，唯一',
    age INT COMMENT '用户年龄',
    status ENUM('active', 'inactive') DEFAULT 'active' COMMENT '用户状态：active-活跃, inactive-非活跃',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '记录最后更新时间',
    INDEX idx_email (email) COMMENT '邮箱索引，用于快速查找',
    INDEX idx_status (status) COMMENT '状态索引，用于按状态筛选'
) COMMENT='用户信息表';







### MySQL 数据库操作测试
  - 新增
        http://localhost:8001/test/mysql/add
        {
          "config": {
              "session_id":"10002"
          },
          "input": "张三"
        }
    - 查询列表
      http://localhost:8001/test/mysql/list
       {
        "config": {
            "session_id":"10002"
        },
        "input": "张三"
      }

     - 查询单个
      http://localhost:8001/test/mysql/get
       {
        "config": {
            "session_id":"10002"
        },
        "input": "4"
      }

      - 修改
        http://localhost:8001/test/mysql/update
        {
          "config": {
              "session_id":"1"
          },
          "input": "李四"
        }