Often check the data table do not know the meaning of the field, and then to look at the design table to see the meaning of the field, the database has been modified by many people, database design documents can not support the current table structure. Just want to make a data dictionary, MySQL in the INFORMATION_SCHEM
The MySQL database to generate a data dictionary, directly available to view database tables, fields, make a data dictionary is very necessary, the following simply to change the configuration can be used, the style is very good.
The above is the entire content of
Tags: char cells SQL set OCA while header INF imagesUsually do development, look at the MySQL table is used navicat, although it is convenient to view the individual table fields, but to see the entire database of the individual fields of the details of the table is not so convenient, so I found a piece of code on the Internet, the database all the table fields are displayed, This will make the view structure clearer. Show effect 1PHP2 /**
3 * Genera
PostgreSQL, Oracle, and MySQL use data dictionaries to obtain the table structure. The schema name and table name are required.
PostgreSQL:Select a. attname, pg_catalog.format_type (A. atttypid, A. atttypmod) as data_typeFrom pg_catalog.pg_attribute,(Select C. OIDFrom pg_catalog.pg_class CLeft join pg_catalog.pg_namespace nOn n. OID = C. relnamespaceWhere (C. relname) = lower ('cxf ')And (N. nspname) = lowe
1, the function of the data dictionary
The data dictionary records the system Information of the data, which is a collection of read-only tables and views.
The owner of the data dictionary
Python data types-tuples, commonly used dictionary operations, python data type dictionaryTuples
The Python tuples are similar to the list. The difference is thatThe elements of the tuples cannot be modified..
The tuples use parentheses, And the list uses square brackets.
Creating tuples is simple. You only need to add elements in brackets and separate them with
Redis data structure (2) dictionary, redis Data Structure dictionary
The Redis dictionary is actually a Hash table. Its implementation is similar to the hashmap structure in JAVA. Key-Value pairs are stored in Key-Value mode, but there are some differences.The hashmap struc
Oracle local management comparison data dictionary management tablespace, oracle dictionary
Locally vs. Dictionary Managed Tablespaces
Organized from: http://www.orafaq.com/node/3.
When Oracleallocates space to a segment (like a table or index), a group of contiguousfree blocks, called an extent, is added to the segme
1. Object definition
When the Create command is executed to create an object, Oracle stores the object definition in the data dictionary.
03:31:40 sql> Select Dbms_metadata.get_ddl (' TABLE ', ' DEPT ') DDL from DUAL;
Ddl
--------------------------------------------------------------------------------
CREATE TABLE "SCOTT". " DEPT "
("DEPTNO" number (2,0),
"Dname" VARCHAR2 (14
2, viewing the space oc
Python from the start to the actual combat series--the definition of a directory dictionary
A dictionary is another variable container model, and can store any type of object, with key-value (Key-value) storage, with extremely fast lookup speed;Each key value of the dictionary (key=>value) pairs with a colon (:) split, each pair is separated by a comma (
Using System;
Using System.Collections;
Using System.Collections.Generic;
Using System.Diagnostics;
Using System.Reflection;
Using System.Runtime;
Using System.Runtime.InteropServices;
Using System.Runtime.Serialization;
Using System.Security;
Using System.Threading;
Namespace Dictionary
{
Thread-Safe Data dictionary
public class Synchronizeddictionary{
Priva
PL/SQL-related data dictionary and plsql-related dictionary
Data Dictionary related to PL/SQLHttp://www.oracle.com/technetwork/issue-archive/2012/12-nov/o62plsql-1851968.html
Sometimes, we encounter the following problems during PL/SQL development:1) What database objects d
True
Second, collections. Ordereddict: Dictionary with OrderOrdereddict internally maintains a doubly linked list to record the order in which key values are inserted, update the key value does not affect the original order, insert key value is inserted at the end, so its memory consumption is twice times the normal dictionary ,From collections Import ORDEREDDICTD = Ordereddict () d[' a '] =
have children's shoes to ask about the sorting problem of dictionary library , Here's a quick introduction to a new skill . Data Dictionary Usage scenario: the type of leave in the absence process, sick leave, leave, take some and so on. definitionData Dictionary, and used in the processsheetdropdownlistorsheetradiobut
1. Introduction 在InnoDB启动时,如果是新建数据库则需初始化库,需要创建字典管理的相关信息。函数innobase_start_or_create_for_mysql调用dict_create完成此功能。即创建数据字典,因为InnoDB系统表的个数结构固定,所以初始化库的时候只需要创建这几个表的B+树即可并将B+树的根页号存放到固定位置。对于B+树,只要找到根页面,就可以从根页面开始检索数据。相关系统表(即上一节讲到的4个系统表)在InnoDB内部,不会暴露给用户。 4个系统表通过固定的硬编码进行构建。具体原理流程如下。2. Data dictionary creation and loading principle flow3. Description1) The Innobase_start_or_create_for_mysql function calls the Dic
Data dictionary table for Oracle users, roles, and permissions (System and object permissions), and oracle dictionary
1. Three dictionary tables
1.1 users
Select * from dba_users;
Select * from all_users;
Select * from user_users;
1.2 roles
Select * from dba_roles;
1.3 Permissions
System permissions and object permissi
MySQL source code learning: amp; mdash; MDL dictionary lock bitsCN.com
What is MDL?
MDL, Meta Data lock, metadata lock, usually calledDictionary lock. The dictionary lock corresponds to the data lock. The dictionary lock is
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.