用mysql创建数据表的代码（带中文备注）： 1. 表名（英语）：客户历史交易记录 2.内容（英语）：主键为自增id，客户姓名、交易类型、交易金额、交易时间、销售姓名 3.对应的springboot-mybatis

代码如下：

CREATE TABLE `customer_trade_history` (
  `id` INT(11) NOT NULL AUTO_INCREMENT COMMENT '主键，自增id',
  `customer_name` VARCHAR(50) NOT NULL COMMENT '客户姓名',
  `trade_type` VARCHAR(50) NOT NULL COMMENT '交易类型',
  `trade_amount` DECIMAL(10,2) NOT NULL COMMENT '交易金额',
  `trade_time` DATETIME NOT NULL COMMENT '交易时间',
  `salesman_name` VARCHAR(50) NOT NULL COMMENT '销售姓名',
  PRIMARY KEY (`id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8mb4 COMMENT='客户历史交易记录表';

对应的springboot-mybatis代码如下：

@Mapper
public interface CustomerTradeHistoryMapper {

    @Insert("INSERT INTO `customer_trade_history` (`customer_name`, `trade_type`, `trade_amount`, `trade_time`, `salesman_name`) " +
            "VALUES (#{customerName}, #{tradeType}, #{tradeAmount}, #{tradeTime}, #{salesmanName})")
    int insert(CustomerTradeHistory customerTradeHistory);

    @Select("SELECT * FROM `customer_trade_history` WHERE `id` = #{id}")
    CustomerTradeHistory getById(Integer id);

    @Select("SELECT * FROM `customer_trade_history` WHERE `customer_name` = #{customerName}")
    List<CustomerTradeHistory> getByCustomerName(String customerName);

    // 更多CRUD操作...
}