Database Administrator

MySQL DATE_FORMAT () function Definition and usageThe DATE_FORMAT () function is used to display date/time data in different formats. SyntaxDATE_FORMAT (date, format)The date parameter is a valid date. Format specifies the output format of the

Oracle filling tables with random data A script from AskTom can also fill in random data for a table. Create or replaceProcedure gen_data (p_tname in varchar2, p_records in number)-- This routine is designed to be installed ONCE pre database, hence--

ORA-27300 troubleshooting instance Recently, a customer reported that some pages of its core business system were running slowly, and the production database (dual-node RAC environment) encountered exceptions. After logging on to the BOSS database

Oracle shrink table use case, oracleshrink There is a serious shortage of External table space in the site, and the customer does not want to resize it. To clean up some data, it is a large field blob. the tablespace is 1 TB and 0.99 TB has been

[Niuyun Video] SQL trigger and niuyun SQL trigger I learned about the data center management system. I have already written about database operations in the net version, but now I am learning about it, only to find that I have understood it

[Instance] in php, the PDO method is used to add, delete, modify, and query databases.You can easily organize and understand the PDO operation instances. Note that you need to enable the pdo support for php. php5.1 and later versions support

MySQL database: consolidate the DDL statements, mysqlddl The SQL language includes four major programming languages: Data Definition Language (DDL), data operation language (DML), Data Control Language (DCL), and transaction control language. Data

Session warehouse receiving and phpsession warehouse receiving Session_set_save_handler (callback open, callback close, callback read, call write, callback destroy, callback gc)   Execution time and usage of each parameter Callback Function

Oracle sys_context () function, oraclesys_context The first parameter is 'userenv', which is fixed. The second parameter is also fixed, but multiple options are fixed. The optional values are as follows: Select sys_context ('userenv',

Report development instance-dynamic multi-level KPI drilling report (II), kpiii InReport development instance-dynamic multi-level KPI drilling report (I)In, we talked about the scenario where dynamic hierarchical reports require hierarchical

Mx matrix assignment (C) and matlebmx in mixed programming of VC and matleb Convert the x and y data of the vector container to the mxMatrix of the matlab matrix:1: memcpy(mxGetPr(mxa_x),&x[0], y.size()*sizeof(double));memcpy(mxGetPr(mxa_y),&y[0],

MySQL study note _ 3_MySQL create a data table (medium) and study note _ 3_mysqlCreating a data table in MySQL 3. Data field attributes 1. unsigned [unsigned] Space can be doubled, for example,-128 ~ 127 increase to 0 ~ 255 Note: Only numeric fields

Date and Time storage and processingThis section summarizes the knowledge about date and time that are frequently used in databases.Because the character set has an effect on the date and time, this is the first thing we need to pay attention to,

Transaction Control for database learning and database learning transactions Transaction Overview: 1. transactions are databasesConcurrency ControlAndRestoration TechnologyBasic Unit;2. transactions have four features: atomicity, consistency,

Sorting and using MySQL built-in functions See mysql Official Website: Introduction to functions and operators For time and date functions, see Mysql5.5 official documentation. General examples 1. view the current system date Call the date

SQL Server column-to-row refer, sqlbench Today, we are doing a data presentation. We use column-to-row conversion. There are multiple methods for column-to-row conversion. The feature is one of them, and Povit is a function that is available only

Error code: 1054 Unknown column 'Course' in 'field list', 1054 column 1. Error description 1 queries executed, 0 success, 1 errors, 0 warnings query: SELECT stu_name, course, score FROM t_student_info s LIMIT 0, 1000 error code: 1054 Unknown

Report diversity data sources-MongoDB and report diversity-mongodb MongoDB and other nosql databases have advantages such as scalability and high performance, but their computing capabilities are weaker than traditional SQL databases. For example,

Customized tablespace retention policies and customized retention policies In large databases, the recycle bin is large, and there is a lot of garbage. It is very slow to query tablespaces. To prevent accidental operations, it is impossible to add

MySQL 'root' @ 'localhost' cannot be logged on, mysqllocalhost This morning, my colleague said that the MySQL root Account could not be logged on. I tried it.# Mysql-u root-pPrompt "Access denied for user 'root' @ 'localhost' (using password: YES )"