mysql学习

Navicat 里面的代码

[IMP] Import start
[IMP] Import type - CSV file
[IMP] Import from - /Users/zhou001/Desktop/1.csv
[ERR] Cannot create table [1]: 1071 - Specified key was too long; max key length is 3072 bytes
[ERR] CREATE TABLE `HMD`.`1`  (
  `f1` varchar(255) NOT NULL,
  `获取日期` varchar(255) NOT NULL,
  `姓名` varchar(255) NOT NULL,
  `身份证号` varchar(255) NOT NULL,
  `手机号` varchar(255) NOT NULL,
  `本金/本息` varchar(255) NOT NULL,
  `执行日期` varchar(255) NOT NULL,
  `发生案例` varchar(255) NOT NULL,
  `未还/罚息` varchar(255) NOT NULL,
  `已还金额` varchar(255) NOT NULL,
  `逾期次数` varchar(255) NOT NULL,
  `邮箱地址` varchar(255) NOT NULL,
  `借款期数` varchar(255) NOT NULL,
  `逾期天数` varchar(255) NOT NULL,
  PRIMARY KEY (`f1`, `获取日期`, `姓名`, `身份证号`, `手机号`, `本金/本息`, `执行日期`, `发生案例`, `未还/罚息`, `已还金额`, `逾期次数`, `邮箱地址`, `借款期数`, `逾期天数`)
)
[IMP] Processed: 0, Added: 0, Updated: 0, Deleted: 0, Errors: 0
[IMP] Finished with errors

实际在shell里面的代码

 create table `HMD`(
    ->   `f1` varchar(255) NOT NULL,
    ->   `获取日期` varchar(255) NOT NULL,
    ->   `姓名` varchar(255) NOT NULL,
    ->   `身份证号` varchar(255) NOT NULL,
    ->   `手机号` varchar(255) NOT NULL,
    ->   `本金/本息` varchar(255) NOT NULL,
    ->   `执行日期` varchar(255) NOT NULL,
    ->   `发生案例` varchar(255) NOT NULL,
    ->   `未还/罚息` varchar(255) NOT NULL,
    ->   `已还金额` varchar(255) NOT NULL,
    ->   `逾期次数` varchar(255) NOT NULL,
    ->   `邮箱地址` varchar(255) NOT NULL,
    ->   `借款期数` varchar(255) NOT NULL,
    ->   `逾期天数` varchar(255) NOT NULL)
    -> ;

 

转载于:https://www.cnblogs.com/zj0724/p/9157600.html