当前位置：网站首页>MYSQL export data dictionary
MYSQL export data dictionary
2022-08-08 04:29:00 【TomcatLikeYou】
Field Export:
SELECTTABLE_SCHEMA AS `database name`,TABLE_NAME AS `table name`,COLUMN_NAME AS `column name`,COLUMN_TYPE AS `type`,COLUMN_DEFAULT AS `default`,IS_NULLABLE AS `Allow null`,DATA_TYPE AS `Data type`,CHARACTER_MAXIMUM_LENGTH AS `Maximum length of characters`,NUMERIC_PRECISION AS `Numeric precision`,NUMERIC_SCALE AS `Number of decimal places`,COLUMN_COMMENT AS `Field description`FROMinformation_schema.COLUMNSWHERETABLE_SCHEMA = 'db_name' #db_name represents the database nameTable export
SELECTTABLE_SCHEMA AS `database name`,TABLE_NAME AS `table name`,CREATE_TIME AS `create time`,TABLE_COLLATION AS `Character Set`,TABLE_COMMENT AS `Table comments`FROMinformation_schema.TABLESWHERETABLE_SCHEMA = 'db_name'View export
SELECTTABLE_SCHEMA AS `database name`,TABLE_NAME AS `view name`FROMinformation_schema.VIEWSWHERETABLE_SCHEMA = 'db_name'边栏推荐
- 2022/08/06 Study Notes (day24) Collection
- 机器学习笔记：学习率预热 warmup
- leetcode: 874. Simulate a walking robot
- Mini Program Optimization Practice
- 一文带你彻底了解synchronized 和 Lock
- 2022-08-07 mysql/stonedb慢SQL-子查询-半连接
- leetcode 70.爬楼梯 动态规划
- 【论文分享】异质图上的小样本学习：HG-Meta: Graph Meta-learning over Heterogeneous Graphs
- leetcode: 122. 买卖股票的最佳时机 II
- reduce具体使用以及使用reduce，toString，flat进行数组降维
猜你喜欢
C语言-函数
Week 4 Step by step building multi-layer neural network and application (1 & 2)
NLP之基本介绍
Building a High-Performance Platform on AWS Using Presto and Alluxio to Support Real-Time Gaming Services
【Review of Live Streaming】Synthesis MindSpore Usability SIG2022 First Half Review Summary
32. 你知道Redis的字符串是怎么实现的吗？
分类、目标检测、语义分割、实例分割的区别
Inside outside l think MindSpore AI framework, heavy industry gathering, huawei big extraordinary path of the model
数据库篇复习篇
This article will give you a thorough understanding of synchronized and Lock
随机推荐
中国科学院金属研究所科研课题获华为技术认证，助力材料学发展新范式！
y90.第六章 微服务、服务网格及Envoy实战 -- 服务网格基础(一)
[Code Analysis] Graph small sample anomaly detection method: GDN: Few-shot Network Anomaly Detection via Cross-network Meta-learning
Voice identification software
[Graph Basics] How to Define Few-Shot Learning on Heterogeneous Graphs: Heterogeneous Graph Few-Shot Learning
失业在家的6个月，我通过外包全款买了房：你看不起的行业，往往很赚钱
topk()/eq( ) / gt( ) / lt( ) / t( )的用法
The type of block in the database buffer cache
Basic introduction to NLP
让你的文字被更多人看到：来投稿吧，稿酬靠谱！
【多任务模型】《Multi-Faceted Hierarchical Multi-Task Learning for a Large Number of Tasks with Multi-dimens
Redis持久化机制、主从、哨兵、cluster集群方案解析
The sword refers to Offer 17. Print the n digits from 1 to the largest
leetcode 112. Path sum recursion
ES6解构赋值的使用说明
NetCore uses Dapper to query data
单主机docker 搭建 redis-cluster
package package
MySQL - Indexes and Transactions
Open3D ICP精配准（使用鲁棒性核函数）