next to normal mti

* ABAP/4 Report: Normal production order printing/two options* By:lake* Date:2002-10-22************************************************ Amendments:* Modify Person:* Date Modified:***********************************************Report ypp012No standard page headingMessage-id y001Line-size "A4 width of the paperLine-count 60 (3). "The length of each sheet of paperInitialization.Tables:afko, "Order header data pp order, AUFPLAfpo, "Order itemsAFVV, "db of

This afternoon, a machine is installing the package. After the shutdown was started, remote SSH was found to be disconnected and could be connected before. Perform service sshd There was no return, even sshd service. Rpm-qa |grep SSH openssh-4.2p1-18.2 openssh-askpass-4.2p1-18.2 But the display has been installed, want to focus on the test RPM-IVH--replacepkgs openssh-4.2p1-18.2.x86_64.rpm RPM-IVH--replacepkgs openssh-askpass-4.2p1-18.2.x86_64.rpm Perform service sshd and discover that

Fault problem: Found on the motherboard has a capacitor in the middle of the drum up, and not home liquid leakage, but the computer can still boot and run normally. Does this have any effect on the normal use of the computer? What should be done? Fault handling: This is commonly known as "explosive slurry", the leakage of the material is the electrolyte of the capacitor. Although the "explosive pulp" after the computer can also start and run normally

xml| conversion Everyone knows that webservice, which is passed in a dataset, will not be compatible with J2ee,flash, so I find a way to convert them into normal XML. The code is as follows: Method One: Public Class datasettoxml:inherits System.Web.UI.Page Private Sub Page_Load (ByVal sender as System.Object, ByVal e as System.EventArgs) Handles MyBase.Load Dim objconn as SqlConnection Dim strSQL as String strSQL = "SELECT top * from Customers" obj

Select Sid, Sql_id from v$session where sid = 1001Select B.begin_interval_time, A.disk_reads_total, A.buffer_gets_total,a.buffer_gets_delta, A.rows_processed_total, A.plan_hash_valueFrom Dba_hist_sqlstat A, dba_hist_snapshot bwhere a.snap_id = b.snap_id and sql_id = ' 466bpq7055f4c ' ORDER by 1 desc;select* from V$sql_planSelect Name, last_analized from Dba_tablesEXEC dbms_stats.gather_table_stats (ownname=> ' BOXV2 ',tabname=> ' Ft_t_posh ', estimate_percent=>3,degree= >32,granularity=> ' GLOBA

Primary key and foreign keyPrimary key: Is an index, help us quickly find, in the database to take out a column as the primary key, data is the only non-repeatable data can not be empty data, slowing down the new dataRight-click Table, point design, right-click column, set as primary keyPrimary KEY Key KeyA foreign key is a constraint that constrains the source of a column of data from another table, which requires a column that is uniquely labeledUnique (Make a column of data unique)Remove the

the returned information and its location in binary log;3. After the Slave IO thread receives the information, it writes the received log content to the end of the relay log file (mysql-relay-bin.xxxxxx) on the Slave side, And the read to the master side of the Bin-log's file name and location to the Master-info file, so that the next time you read the high-speed master "I need to start from somewhere in the Bin-log log content, please send me"4. When the Slave SQL thread detects a new addition

Tags: mysq ons question mark content nbsp har text HTML WriteOne of my programs, used in the background database MySQL, field is varchar,character set is UTF8, the field can and has been correctly stored in Chinese. After extracting the information from the database, debug in the background Java code to see the correct Chinese. However, through the Ajax way to send information to the foreground, the front desk display?? , a two question mark is also viewed with alert. Look at the page encoding m

Tags: using OS io strong file data for artmaster:192.168.209.19slave:192.168.209.20MySQL version: mysql5.6.131. Create a normal user as root, such as MySQL, and create the MySQL installation directory:# useradd MySQL# passwd MySQL# Mkdir/mysql# chown Mysql:mysql/mysqlTo install a dependency package:Yum-y install gcc gcc-c++ autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel* make CMake2. Download the full development ver

The interview was asked the difference between the arrow function and the normal function ... -_-|| Borrow a chestnut from someone else: function make () { return () =>{ console.log (this); } } var TestFunc = Make.call ({name: ' foo '}); TestFunc (); Object {name: ' foo '} object {name: ' foo '}You can see the arrow function is defined, this will not change, no matter what way to call it, this will not change; Cause: The arrow func

Tags: A programming SQL PAC Chinese read Get cacheis the channel name in Aapt2 not Chinese? Select query Learning (federated query of two tables) IIS7 thinkhphp pseudo-static configuration thinkphp use file_get_contents get no web contentJava custom Annotations If you automatically call test file read mode (for program Optimization) TP (already resolved) module bound domain name access issueDesign a USB stick soft encryption Program Delete key (BACKSPACE) a function cache can only be stored in a

| +--------------------+ | information_schema | | db1 | | mysql | | performance_schema | | test | +--------------------+ 5 rows in set (0.00 sec)Create a tableuse db1; //切换到db1库 create table t1(`id` int(4),`name` char(40)); //注意：中间使用的是反引号，创建表t1View Database versionMysql> select version (); +-----------+ | version() | +-----------+ | 5.6.36 | +-----------+ 1 row in set (0.00 sec)View database StatusShow status;View paramet

] |+----------------+1 row in Set (0.00 sec)Mysql> show engines;+--------------------+---------+----------------------------------------------------------------+-------------- +------+------------+| Engine | Support | Comment | Transactions | XA | savepoints |+--------------------+---------+----------------------------------------------------------------+-------------- +------+------------+| Mrg_myisam | YES | Collection of identical MyISAM tables | NO | NO | NO || CSV | YES | CSV Storage Engine

Tags: else mys delay synchronous while replication Stat Master ClassDevelop a daemon script that monitors MySQL master-slave replication anomalies (including unsynchronized and delayed) every 30 seconds#!/bin/bashfile=/root/mysql.txt #mysql > Show slave status\g; This command can view status information and save it to a file. Aa= ($ (Cat $file | grep-e ' Running|Behind ' |Cut-d ': '-f2)) for ((i=0;iFor a delay of 30 seconds, put the above script inside the function, using the while true null val

Tags: script min font RIP plug-in class background database color body//After the action has requested a date from the background database, the data is obtained in JSON format, so parsing can be displayed in the foreground 1. The code written on the JSP page is as follows :2. In the example code above, we still need to specify format, where we first abstract a formatdatebox function to display the date. The code written in JS is as follows: function Formatdatebox (value) { if (value = = NULL | |

resolution plan for that long-running SQL has changed during this periodSelect * from V$sql_planStep4. To view the statistics time for a tableSelect from Dba_tablesStep5. Generating statistics on a tableexec dbms_stats.gather_table_stats (ownname scot ' , Tabname=> " gavin , Estimate_percent=> 3 , Degree=> Span style= "color: #800000; Font-weight:bold; " >32 , Granularity=> " global , cascade => false,no_invalidate=> FALSE); Thanks and regardsPlsql_ Statistical Information Seri

Tags: Host SQL Hadoop unified Connect spark OOP password Express(i), under the root User: (Mysql) 1. Under root User: Create Hive Metabase Create database if not exists hivedb; 2. Add user user under root user: Hadoop Note: This place host is localhost, you can customize the hostname, such as the following SPARK1, need unification! Insert into Mysql.user (Host,user,password) VALUES ('% ', ' Hadoop ', Password (' Hadoop ')); 3. Under root users, Hadoop authorizes any host to the Hivedb database

Tags: localhost password identified mysql change passwordAllow the root user to log on to the universal Navicat for MySQL client:Mysql> Grant all privileges on * * to [e-mail protected] '% ' identified by ' root ';Query OK, 0 rows Affected (0.00 sec)mysql> flush Privileges;Query OK, 0 rows Affected (0.00 sec)Change the password for the User1 user, the permission is a bit large, but do not execute the following first command, the password cannot be changed.Mysql> Grant all privileges on * * to [e

myPartition; select * from t_temp;8. After you refresh the data using the Sync_interim_table module of the Dbms_redefinition package, the intermediate table can also see the data changes--管理员权限执行sql命令行执行,同步两边数据 exec dbms_redefinition.sync_interim_table(‘scott‘‘myPartition‘‘t_temp‘); --管理员权限执行sql命令行执行 Query whether the data on both sides of the synchronization is consistent: select * from myPartition; select * from t_temp;9. End the online redefinition--管理员权限执行sql命令行执行，结束重定义 exec dbms_redefiniti

Tags: Linux system font Universal root privileges Linux Vim edit modify exit Enter passwordWhen using a Linux system, you will often be asked to use Super permissions, but Root is too large, and generally use caution!!! So you can add sudo permissions to ordinary users, usually with ordinary users to operate, when the need for root access to sudo operation. Here are the workarounds:1. Enter Super User mode, that is, enter "Su root", the system will let you enter the super user password, enter th