the code is :
Code Select
(:connect db mysql-host mysql-user mysql-pwd mysql-db mysql-port)
(set 'r (:query db (append "show create table " mysql-table-name)))
(set 'mysql_sql ((((:fetch-all r) 0) 1) 1))
(println mysql_sql )
the result is :
Code Select
CREATE TABLE `tvsn` (
`order_id` varchar(13) NOT NULL COMMENT '??ID',
`sn` varchar(50) NOT NULL COMMENT '??SN?'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='???????SN?'
but in mysqlclient, the result is :
Code Select
CREATE TABLE `tvsn` (
`order_id` varchar(13) NOT NULL COMMENT '订单ID',
`sn` varchar(50) NOT NULL COMMENT '电视SN码'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='电视机SN码'
some description of mysql.lsp is:
;; @module Mysql
;; @author Jeff Ober <
;; @version 1.05 beta
;; @location
;; @package
;; @description A new MySQL module to replace the distribution standard module (requires newlisp 10).
how to solve it ?