mycli 在使用show create命令的时候语句中的换行符不能显示为换行而是显示为\n换行符,这个要修改哪个配置才能让显示的更好看一些
MySQL root@(none):demo> show create table userinfo;
+----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| userinfo | CREATE TABLE `userinfo` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `age` tinyint(3) unsigned DEFAULT NULL,\n `sex` enum('男','女','保密') DEFAULT NULL,\n `city` varchar(32) DEFAULT NULL,\n `tel` varchar(16) DEFAULT NULL,\n PRIMARY KEY (`id`),\n CONSTRAINT `fk_uid` FOREIGN KEY (`id`) REFERENCES `user` (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 |
+----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
如图显示, 另外表格显示的也有些奇怪
这部分是存在与mysql系统文件中的,可以理解类似元数据。
表格显示奇怪是因为创表语句太长了