mysql各种类型的字段

mysql各种类型的字段

/*
Navicat MySQL Data Transfer

Source Server         : MySQL_localhost_2020
Source Server Version : 50717
Source Host           : localhost:3306
Source Database       : test_2020

Target Server Type    : MYSQL
Target Server Version : 50717
File Encoding         : 65001

Date: 2020-10-14 09:21:10
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for test_fields
-- ----------------------------
DROP TABLE IF EXISTS `test_fields`;
CREATE TABLE `test_fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `field1` tinyint(4) DEFAULT NULL,
  `field2` smallint(6) DEFAULT NULL,
  `field3` mediumint(9) DEFAULT NULL,
  `field4` int(11) DEFAULT NULL,
  `field5` int(11) DEFAULT NULL,
  `field6` bigint(20) DEFAULT NULL,
  `field7` bit(1) DEFAULT NULL,
  `field8` double DEFAULT NULL,
  `field9` double DEFAULT NULL,
  `field10` float DEFAULT NULL,
  `field11` decimal(10,0) DEFAULT NULL,
  `field12` decimal(10,0) DEFAULT NULL,
  `field13` char(255) DEFAULT NULL,
  `field14` varchar(255) DEFAULT NULL,
  `field15` date DEFAULT NULL,
  `field16` time DEFAULT NULL,
  `field17` year(4) DEFAULT NULL,
  `field18` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `field19` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `field20` tinyblob,
  `field21` blob NOT NULL,
  `field22` mediumblob,
  `field23` longblob,
  `field24` tinytext,
  `field26` mediumtext,
  `field27` longtext,
  `field28` enum('') DEFAULT NULL,
  `field30` binary(255) DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
  `field31` varbinary(255) DEFAULT '',
  `field32` point DEFAULT NULL,
  `field33` linestring DEFAULT NULL,
  `field36` multipoint DEFAULT NULL,
  `field37` multilinestring DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of test_fields
-- ----------------------------