Database Administrator

Export the table creation statement in the MySQL database to a file using Python To control the version of Data Objects, You need to export the table structure in the MySQL database to a file for version management. After a try, you can completely

MySQL Stored Procedure A stored procedure is a set of SQL statements stored on the database server. You can run these SQL statement commands by calling a specified name in the query. Introduction The SQL statement needs to be compiled and then

MySQL table sharding auto-incremental ID Solution After we perform the table sharding operation on MySQL, we cannot rely on the automatic increment of MySQL to generate a unique ID, because the data has been distributed to multiple tables. Avoid

Install Percona Server using a binary tar package Install Percona Server using a binary tar package InstallingPercona ServerFrom a Binary Tarball1. Download the binary tar package Take version 5.6 as an example. Go to the official website

How to compile and run PL/SQL code snippets from a Case Study PL/SQL is a process-oriented structured programming statement developed by Oracle for database business logic requirements. In the Oracle kernel, there are two important components:

[MongoDB] Installation of MongoDB, mongodb First what I wanna make clear is that in the official website the detailed process of installation has been described. you cocould call it throught the

Preface: Recently, some projects use the IBM DB2 database in Linux, which is not as easy to understand as MySQL. It may be that the DB2 database is more commercialized and is not as open-source as MySQL, the related DB2 resources are not as popular

11 Database Design Guidelines and 11 database guidelines I have followed Author Shivprasad koirala, a former MVC engineer from Microsoft ASP/ASP. NET, is now a CEO in India. If you have any questions about the first translation, please kindly advise.

[Mysql] Common commands-user operations (create, authorize, modify, delete) and mysql user operations Each user in Mysql corresponds to different user addresses and permissions. There are three ways to create a Mysql user: 1. create user 2. grant 3.

Petelai project experience small set (2) ___ Combined Query stored procedure, error "failed to convert varchar JBID ='' to data type int ",The storage process for writing a composite query encountered the following problem:Failed to convert varchar

I. Mark data Log On with the scott user and set the tag data SQL> select table_name from user_tables; TABLE_NAME ------------------------------ DEPT EMP BONUS SALGRADE EMP_BAK Creates a backup table emp_bak for the emp table. Ii. Back up the

Why don't you shrink the database file (foreign translation) and the database translation? Preface: I have read a lot of articles about SQL server shrinking data files over the past few days. I am going to write an article about shrinking logs, but

The environment is AIX 6.1, and DB2 9.7.0.7 first checks whether the db2 master process exists.Ps-ef | grep db2sysIf notDb2startOpen the database backup media as a cold backup data source and cd it to the directory where the media is located:Cd/home/

The Department name, number of employees of the Department, average salary of the department, name of the employee with the lowest income of the Department, and name of the employee with the highest income are queried. Example: The Department name,

Http://www.infoq.com/cn/news/2014/01/nosql-vs-rdbms Naresh Kumar is a software engineer and enthusiastic blogger who is very interested in programming and new things and is very happy to share technical research results with other developers and

NUMBER (x, y) Data Types in Oracle databases, oraclenumber Test preparation Analyze and Experiment Processing of 1 decimal part 2. Maximum value that can be saved 3. Minimum value that can be saved Summary The NUMBER data type

Blue growth note-chasing DBA (13): Coordinating hardware manufacturers, six stories: what you see as "servers, storage, switches", dba hardware manufacturers Original Works are from the blog of "Deep Blue blog". You are welcome to repost them.

PL/SQL Exception error handling and plsql error handlingZookeeper Exception HandlingA good program should be able to correctly handle all kinds of errors and recover from errors as much as possible. ORACLE provides EXCEPTION and exception handler

Microsoft is evil, not 2 P, 3 P, huh, Office BI is 4 P. As a member of 4 P, Power Map is a half product.   The latest update is a bit bright. Mp4 can be generated. However, maps still do not support Chinese characters, including English,

Set MySQL Data Synchronization in one-way and two-way) due to the company's business needs, we need to synchronize data between China Netcom and China Telecom, so we have done a two-way MySQL synchronization, write down the process, and use it later