SHOW VARIABLES LIKE "%CHAR%";
CREATE DATABASE IF NOT EXISTS test;
USE test;

CREATE OR REPLACE TABLE table_coupon_varchar (
  coupon_no varchar(10) NOT NULL DEFAULT '',
  memo varchar(30) DEFAULT NULL,
  discount double DEFAULT NULL,
  PRIMARY KEY (coupon_no)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO table_coupon_varchar VALUES ("1","abc",250),("2","def",200),("3","ghi",300);
SELECT * FROM table_coupon_varchar;

GRANT ALL ON test.* TO 'root'@'10.0.1.33';
