mysql如何创建客户表

应该按行创建还是按列创建呢？初学者该如何下手？如何使用Decimal字符？谢谢

创建第一行的字段就行了，下边的是插入数据

CREATE TABLE `sale`.`customer`  (
  `khbh` char(4) NOT NULL,
  `xm` char(10) NULL,
  `khdj` char(5) NULL,
  `dz` char(20) NULL,
  `dh` char(13) NULL,
  `ljjf` decimal(10, 2) NULL
);

CREATE TABLE `customerxx` (
  `khbh` char(4) COLLATE utf8_bin NOT NULL,
  `xm` char(10) COLLATE utf8_bin NOT NULL,
  `Khdj` char(5) COLLATE utf8_bin NOT NULL,
  `dz` char(20) COLLATE utf8_bin DEFAULT NULL,
  `dh` char(13) COLLATE utf8_bin DEFAULT NULL,
  `Ljjf` decimal(10,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;