N5打卡_seq2seq详解

深入理解RNN-basedseq2seq模型与注意力机制
seq2seq模型是一种用于NLP的序列到序列学习方法,由编码器和解码器组成,常用于机器翻译。长文本处理时面临长期依赖、内存限制和对齐问题。注意力机制通过关注输入序列的特定部分,改善了模型处理长序列的能力,提高翻译质量。

原作者:K同学啊

本周任务:

1. 了解seq2seq是什么

2. 基于RNN的seq2seq模型如何处理文本/长文本序列

3. seq2seq模型处理长文本序列有哪些难点?

4.基于RNN的seq2seq模型如何结合attention来改善模型效果?

一、seq2seq是什么

seq2seq(sequence to sequence)是一种常见的NLP模型结构,翻译为“序列到序列”,即:从一个文本序列得到一个新的文本序列。典型的任务有:机器翻译任务,文本摘要任务。

NLP初学者想要充分理解并实现seq2seq模型很不容易。因为,我们需要拆解一系列相关的NLP概念,而这些NLP概念又是是层层递进的,所以想要清晰的对seq2seq模型有一个清晰的认识并不容易。

首先看seq2seq干了什么事情?seq2seq模型的输入可以是一个(单词、字母或者图像特征)序列,输出是另外一个(单词、字母或者图像特征)序列。

以NLP中的机器翻译任务为例,序列指的是一连串的单词,输出也是一连串单词

二、seq2seq原理

seq2seq模型由编码器(Encoder)和解码器(Decoder)组成。绿色的编码器会处理输入序列中的每个元素并获得输入信息,这些信息会被转换成为一个黄色的向量(称为context向量)。当我们处理完整个输入序列后,编码器把 context向量 发送给紫色的解码器,解码器通过context向量中的信息,逐个元素输出新的序列。

黄色的context向量本质上是一组浮点数。而这个context的数组长度是基于编码器RNN的隐藏层神经元数量的。在实际应用中,context向量的长度是自定义的,比如可能是256,512或者1024

 

RNN是如何具体地处理输入序列:

  1. 假设序列输入是一个句子,这个句子可以由 n 个词表示:sentence={w1, w2, ...,wn}
  2. RNN首先将句子中的每一个词映射成为一个向量得到一个向量序列:X={x1,x2,...,xn},每个单词映射得到的向量通常又叫做:word embedding
  3. 然后在处理第t鸽实践部的序列输入xt时,RNN的输入和输出可以表示为ht = RNN(xt, ht-1)

三、seq2seq模型处理长文本序列有哪些难点

seq2seq模型处理长文本序列有哪些难点
1.长期依赖问题:由于长文本序列中存在大量的上下文信息,因此需要建立模型能够捕捉到长期的依赖关系。但是,常规的RNN结构很容易出现梯度消失或梯度爆炸的问题,导致模型无法有效地处理长期的依赖关系。

2.内存限制:Seq2seq模型在训练和推理过程中需要对整个序列进行处理,而长文本序列可能会超出模型内存限制的范围,导致无法处理完整个序列。

3.对齐问题:解码器在生成输出序列时需要与输入序列对齐,但是当输入序列很长时,对齐问题变得更加困难。此时,模型需要学习如何在长文本序列中保持正确的对齐关系,以便生成正确的输出序列。

4.训练时间和计算成本:由于长文本序列需要更多的计算和处理,因此训练和推理时间会更长,计算成本也会更高。

5.数据稀疏性:长文本序列通常包含大量的稀疏数据,例如停用词、低频词等。这些数据可能会导致模型学习不到足够的信息,从而影响模型的性能。

四、Attention的引入

基于RNN的seq2seq模型编码器所有信息都编码到了一个context向量中,便是这类模型的瓶颈。一方面单个向量很难包含所有文本序列的信息,另一方面RNN递归地编码文本序列使得模型在处理长文本时面临非常大的挑战(比如RNN处理到第500个单词的时候,很难再包含1-499个单词中的所有信息了)。

面对以上问题,Bahdanau等2014发布的Neural Machine Translation by Jointly Learning to Align and Translate 和 Luong等2015年发布的Effective Approaches to Attention-based Neural Machine Translation两篇论文中,提出了一种叫做注意力attetion的技术。通过attention技术,seq2seq模型极大地提高了机器翻译的质量。归其原因是:attention注意力机制,使得seq2seq模型可以有区分度、有重点地关注输入序列。

一个注意力模型与经典的seq2seq模型主要有2点不同:

1.首先,编码器会把更多的数据传递给解码器。编码器把所有时间步的 hidden state(隐藏层状态)传递给解码器,而不是只传递最后一个 hidden state(隐藏层状态)。

2.注意力模型的解码器在产生输出之前,做了一个额外的attention处理。如下图所示,具体为:
a. 由于编码器中每个 hidden state(隐藏层状态)都对应到输入句子中一个单词,那么解码器要查看所有接收到的编码器的 hidden state(隐藏层状态)。
b. 给每个 hidden state(隐藏层状态)计算出一个分数(我们先忽略这个分数的计算过程)。
c. 所有hidden state(隐藏层状态)的分数经过softmax进行归一化。
d. 将每个 hidden state(隐藏层状态)乘以所对应的分数,从而能够让高分对应的 hidden state(隐藏层状态)会被放大,而低分对应的 hidden state(隐藏层状态)会被缩小。
e. 将所有hidden state根据对应分数进行加权求和,得到对应时间步的context向量。

UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29552 WHERE SPEC_SEQ = 25133; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29553 WHERE SPEC_SEQ = 25176; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29554 WHERE SPEC_SEQ = 25196; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29555 WHERE SPEC_SEQ = 25156; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29566 WHERE SPEC_SEQ = 25164; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29567 WHERE SPEC_SEQ = 25168; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29568 WHERE SPEC_SEQ = 25165; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29569 WHERE SPEC_SEQ = 25163; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29570 WHERE SPEC_SEQ = 25158; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29571 WHERE SPEC_SEQ = 25172; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29572 WHERE SPEC_SEQ = 25173; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29573 WHERE SPEC_SEQ = 25160; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29574 WHERE SPEC_SEQ = 25166; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29575 WHERE SPEC_SEQ = 25162; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29576 WHERE SPEC_SEQ = 25159; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29577 WHERE SPEC_SEQ = 25169; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29578 WHERE SPEC_SEQ = 25161; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29579 WHERE SPEC_SEQ = 25175; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29580 WHERE SPEC_SEQ = 25171; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29581 WHERE SPEC_SEQ = 25167; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29582 WHERE SPEC_SEQ = 25157; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29583 WHERE SPEC_SEQ = 25174; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29584 WHERE SPEC_SEQ = 25170; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29590 WHERE SPEC_SEQ = 29325; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29591 WHERE SPEC_SEQ = 29327; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29592 WHERE SPEC_SEQ = 29329; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29593 WHERE SPEC_SEQ = 29334; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29594 WHERE SPEC_SEQ = 29335; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29595 WHERE SPEC_SEQ = 29336; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29596 WHERE SPEC_SEQ = 29337; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29597 WHERE SPEC_SEQ = 29339; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29598 WHERE SPEC_SEQ = 29347; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29599 WHERE SPEC_SEQ = 29348; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29600 WHERE SPEC_SEQ = 29349; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29601 WHERE SPEC_SEQ = 29351; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29602 WHERE SPEC_SEQ = 29353; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29603 WHERE SPEC_SEQ = 29356; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29604 WHERE SPEC_SEQ = 29358; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29605 WHERE SPEC_SEQ = 29324; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29606 WHERE SPEC_SEQ = 29326; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29607 WHERE SPEC_SEQ = 29328; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29608 WHERE SPEC_SEQ = 29330; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29609 WHERE SPEC_SEQ = 29331; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29610 WHERE SPEC_SEQ = 29332; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29611 WHERE SPEC_SEQ = 29333; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29612 WHERE SPEC_SEQ = 29338; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29613 WHERE SPEC_SEQ = 29340; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29614 WHERE SPEC_SEQ = 29341; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29615 WHERE SPEC_SEQ = 29342; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29616 WHERE SPEC_SEQ = 29343; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29617 WHERE SPEC_SEQ = 29344; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29618 WHERE SPEC_SEQ = 29345; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29619 WHERE SPEC_SEQ = 29346; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29620 WHERE SPEC_SEQ = 29350; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29621 WHERE SPEC_SEQ = 29352; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29622 WHERE SPEC_SEQ = 29354; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29623 WHERE SPEC_SEQ = 29355; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29624 WHERE SPEC_SEQ = 29357; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29655 WHERE SPEC_SEQ = 25141; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29656 WHERE SPEC_SEQ = 25184; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29657 WHERE SPEC_SEQ = 25204; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29658 WHERE SPEC_SEQ = 25145; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29659 WHERE SPEC_SEQ = 25188; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29660 WHERE SPEC_SEQ = 25208; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29661 WHERE SPEC_SEQ = 25142; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29662 WHERE SPEC_SEQ = 25185; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29663 WHERE SPEC_SEQ = 25205; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29664 WHERE SPEC_SEQ = 25140; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29665 WHERE SPEC_SEQ = 25183; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29666 WHERE SPEC_SEQ = 25203; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29667 WHERE SPEC_SEQ = 25135; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29668 WHERE SPEC_SEQ = 25178; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29669 WHERE SPEC_SEQ = 25198; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29670 WHERE SPEC_SEQ = 25149; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29671 WHERE SPEC_SEQ = 25192; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29672 WHERE SPEC_SEQ = 25212; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29673 WHERE SPEC_SEQ = 25150; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29674 WHERE SPEC_SEQ = 25193; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29675 WHERE SPEC_SEQ = 25213; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29676 WHERE SPEC_SEQ = 25137; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29677 WHERE SPEC_SEQ = 25180; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29678 WHERE SPEC_SEQ = 25200; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29679 WHERE SPEC_SEQ = 25143; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29680 WHERE SPEC_SEQ = 25186; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29681 WHERE SPEC_SEQ = 25206; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29682 WHERE SPEC_SEQ = 25139; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29683 WHERE SPEC_SEQ = 25182; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29684 WHERE SPEC_SEQ = 25202; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29685 WHERE SPEC_SEQ = 25136; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29686 WHERE SPEC_SEQ = 25179; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29687 WHERE SPEC_SEQ = 25199; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29688 WHERE SPEC_SEQ = 25146; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29689 WHERE SPEC_SEQ = 25189; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29690 WHERE SPEC_SEQ = 25209; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29691 WHERE SPEC_SEQ = 25138; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29692 WHERE SPEC_SEQ = 25181; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29693 WHERE SPEC_SEQ = 25201; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29694 WHERE SPEC_SEQ = 25152; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29695 WHERE SPEC_SEQ = 25195; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29696 WHERE SPEC_SEQ = 25215; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29697 WHERE SPEC_SEQ = 25148; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29698 WHERE SPEC_SEQ = 25191; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29699 WHERE SPEC_SEQ = 25211; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29700 WHERE SPEC_SEQ = 25144; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29701 WHERE SPEC_SEQ = 25187; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29702 WHERE SPEC_SEQ = 25207; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29703 WHERE SPEC_SEQ = 25134; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29704 WHERE SPEC_SEQ = 25177; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29705 WHERE SPEC_SEQ = 25197; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29706 WHERE SPEC_SEQ = 25151; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29707 WHERE SPEC_SEQ = 25194; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29708 WHERE SPEC_SEQ = 25214; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29709 WHERE SPEC_SEQ = 25147; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29710 WHERE SPEC_SEQ = 25190; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29711 WHERE SPEC_SEQ = 25210; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29727 WHERE SPEC_SEQ = 29255; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29728 WHERE SPEC_SEQ = 29417; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29728 WHERE SPEC_SEQ = 29382; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29729 WHERE SPEC_SEQ = 29290; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29730 WHERE SPEC_SEQ = 29257; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29731 WHERE SPEC_SEQ = 29419; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29731 WHERE SPEC_SEQ = 29384; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29732 WHERE SPEC_SEQ = 29292; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29733 WHERE SPEC_SEQ = 29259; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29734 WHERE SPEC_SEQ = 29421; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29734 WHERE SPEC_SEQ = 29386; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29735 WHERE SPEC_SEQ = 29294; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29736 WHERE SPEC_SEQ = 29264; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29737 WHERE SPEC_SEQ = 29426; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29737 WHERE SPEC_SEQ = 29391; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29738 WHERE SPEC_SEQ = 29299; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29739 WHERE SPEC_SEQ = 29265; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29740 WHERE SPEC_SEQ = 29427; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29740 WHERE SPEC_SEQ = 29392; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29741 WHERE SPEC_SEQ = 29300; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29742 WHERE SPEC_SEQ = 29266; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29743 WHERE SPEC_SEQ = 29428; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29743 WHERE SPEC_SEQ = 29393; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29744 WHERE SPEC_SEQ = 29301; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29745 WHERE SPEC_SEQ = 29267; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29746 WHERE SPEC_SEQ = 29429; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29746 WHERE SPEC_SEQ = 29394; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29747 WHERE SPEC_SEQ = 29302; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29748 WHERE SPEC_SEQ = 29269; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29749 WHERE SPEC_SEQ = 29431; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29749 WHERE SPEC_SEQ = 29396; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29750 WHERE SPEC_SEQ = 29304; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29751 WHERE SPEC_SEQ = 29277; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29752 WHERE SPEC_SEQ = 29439; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29752 WHERE SPEC_SEQ = 29404; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29753 WHERE SPEC_SEQ = 29312; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29754 WHERE SPEC_SEQ = 29278; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29755 WHERE SPEC_SEQ = 29440; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29755 WHERE SPEC_SEQ = 29405; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29756 WHERE SPEC_SEQ = 29313; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29757 WHERE SPEC_SEQ = 29279; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29758 WHERE SPEC_SEQ = 29441; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29758 WHERE SPEC_SEQ = 29406; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29759 WHERE SPEC_SEQ = 29314; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29760 WHERE SPEC_SEQ = 29281; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29761 WHERE SPEC_SEQ = 29443; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29761 WHERE SPEC_SEQ = 29408; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29762 WHERE SPEC_SEQ = 29316; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29763 WHERE SPEC_SEQ = 29283; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29764 WHERE SPEC_SEQ = 29445; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29764 WHERE SPEC_SEQ = 29410; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29765 WHERE SPEC_SEQ = 29318; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29766 WHERE SPEC_SEQ = 29286; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29767 WHERE SPEC_SEQ = 29448; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29767 WHERE SPEC_SEQ = 29413; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29768 WHERE SPEC_SEQ = 29321; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29769 WHERE SPEC_SEQ = 29288; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29770 WHERE SPEC_SEQ = 29450; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29770 WHERE SPEC_SEQ = 29415; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29771 WHERE SPEC_SEQ = 29323; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29772 WHERE SPEC_SEQ = 29254; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29773 WHERE SPEC_SEQ = 29416; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29773 WHERE SPEC_SEQ = 29381; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29774 WHERE SPEC_SEQ = 29289; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29775 WHERE SPEC_SEQ = 29256; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29776 WHERE SPEC_SEQ = 29418; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29776 WHERE SPEC_SEQ = 29383; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29777 WHERE SPEC_SEQ = 29291; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29778 WHERE SPEC_SEQ = 29258; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29779 WHERE SPEC_SEQ = 29420; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29779 WHERE SPEC_SEQ = 29385; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29780 WHERE SPEC_SEQ = 29293; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29781 WHERE SPEC_SEQ = 29260; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29782 WHERE SPEC_SEQ = 29422; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29782 WHERE SPEC_SEQ = 29387; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29783 WHERE SPEC_SEQ = 29295; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29784 WHERE SPEC_SEQ = 29261; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29785 WHERE SPEC_SEQ = 29423; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29785 WHERE SPEC_SEQ = 29388; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29786 WHERE SPEC_SEQ = 29296; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29787 WHERE SPEC_SEQ = 29262; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29788 WHERE SPEC_SEQ = 29424; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29788 WHERE SPEC_SEQ = 29389; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29789 WHERE SPEC_SEQ = 29297; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29790 WHERE SPEC_SEQ = 29263; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29791 WHERE SPEC_SEQ = 29425; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29791 WHERE SPEC_SEQ = 29390; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29792 WHERE SPEC_SEQ = 29298; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29793 WHERE SPEC_SEQ = 29268; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29794 WHERE SPEC_SEQ = 29430; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29794 WHERE SPEC_SEQ = 29395; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29795 WHERE SPEC_SEQ = 29303; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29796 WHERE SPEC_SEQ = 29270; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29797 WHERE SPEC_SEQ = 29432; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29797 WHERE SPEC_SEQ = 29397; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29798 WHERE SPEC_SEQ = 29305; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29799 WHERE SPEC_SEQ = 29271; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29800 WHERE SPEC_SEQ = 29433; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29800 WHERE SPEC_SEQ = 29398; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29801 WHERE SPEC_SEQ = 29306; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29802 WHERE SPEC_SEQ = 29272; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29803 WHERE SPEC_SEQ = 29434; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29803 WHERE SPEC_SEQ = 29399; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29804 WHERE SPEC_SEQ = 29307; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29805 WHERE SPEC_SEQ = 29273; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29806 WHERE SPEC_SEQ = 29435; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29806 WHERE SPEC_SEQ = 29400; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29807 WHERE SPEC_SEQ = 29308; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29808 WHERE SPEC_SEQ = 29274; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29809 WHERE SPEC_SEQ = 29436; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29809 WHERE SPEC_SEQ = 29401; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29810 WHERE SPEC_SEQ = 29309; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29811 WHERE SPEC_SEQ = 29275; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29812 WHERE SPEC_SEQ = 29437; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29812 WHERE SPEC_SEQ = 29402; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29813 WHERE SPEC_SEQ = 29310; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29814 WHERE SPEC_SEQ = 29276; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29815 WHERE SPEC_SEQ = 29438; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29815 WHERE SPEC_SEQ = 29403; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29816 WHERE SPEC_SEQ = 29311; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29817 WHERE SPEC_SEQ = 29280; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29818 WHERE SPEC_SEQ = 29442; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29818 WHERE SPEC_SEQ = 29407; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29819 WHERE SPEC_SEQ = 29315; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29820 WHERE SPEC_SEQ = 29282; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29821 WHERE SPEC_SEQ = 29444; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29821 WHERE SPEC_SEQ = 29409; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29822 WHERE SPEC_SEQ = 29317; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29823 WHERE SPEC_SEQ = 29284; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29824 WHERE SPEC_SEQ = 29446; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29824 WHERE SPEC_SEQ = 29411; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29825 WHERE SPEC_SEQ = 29319; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29826 WHERE SPEC_SEQ = 29285; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29827 WHERE SPEC_SEQ = 29447; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29827 WHERE SPEC_SEQ = 29412; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29828 WHERE SPEC_SEQ = 29320; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29829 WHERE SPEC_SEQ = 29287; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29830 WHERE SPEC_SEQ = 29449; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29830 WHERE SPEC_SEQ = 29414; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29831 WHERE SPEC_SEQ = 29322; 帮我把SPEC_SEQ 前后的值替换下
最新发布
09-24
你希望将 `SPEC_SEQ` 的值进行“前后替换”——即把原来的 `SET SPEC_SEQ = 新值 WHERE SPEC_SEQ = 旧值` 改为 `SET SPEC_SEQ = 旧值 WHERE SPEC_SEQ = 新值`。 以下是将每条语句中 `SPEC_SEQ` 的新旧值进行互换的 SQL 语句: ```sql UPDATE TSPCSMDTMAST SET SPEC_SEQ = 25133 WHERE SPEC_SEQ = 29552; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 25176 WHERE SPEC_SEQ = 29553; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 25196 WHERE SPEC_SEQ = 29554; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 25156 WHERE SPEC_SEQ = 29555; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 25164 WHERE SPEC_SEQ = 29566; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 25168 WHERE SPEC_SEQ = 29567; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 25165 WHERE SPEC_SEQ = 29568; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 25163 WHERE SPEC_SEQ = 29569; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 25158 WHERE SPEC_SEQ = 29570; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 25172 WHERE SPEC_SEQ = 29571; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 25173 WHERE SPEC_SEQ = 29572; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 25160 WHERE SPEC_SEQ = 29573; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 25166 WHERE SPEC_SEQ = 29574; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 25162 WHERE SPEC_SEQ = 29575; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 25159 WHERE SPEC_SEQ = 29576; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 25169 WHERE SPEC_SEQ = 29577; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 25161 WHERE SPEC_SEQ = 29578; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 25175 WHERE SPEC_SEQ = 29579; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 25171 WHERE SPEC_SEQ = 29580; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 25167 WHERE SPEC_SEQ = 29581; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 25157 WHERE SPEC_SEQ = 29582; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 25174 WHERE SPEC_SEQ = 29583; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 25170 WHERE SPEC_SEQ = 29584; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29325 WHERE SPEC_SEQ = 29590; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29327 WHERE SPEC_SEQ = 29591; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29329 WHERE SPEC_SEQ = 29592; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29334 WHERE SPEC_SEQ = 29593; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29335 WHERE SPEC_SEQ = 29594; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29336 WHERE SPEC_SEQ = 29595; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29337 WHERE SPEC_SEQ = 29596; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29339 WHERE SPEC_SEQ = 29597; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29347 WHERE SPEC_SEQ = 29598; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29348 WHERE SPEC_SEQ = 29599; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29349 WHERE SPEC_SEQ = 29600; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29351 WHERE SPEC_SEQ = 29601; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29353 WHERE SPEC_SEQ = 29602; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29356 WHERE SPEC_SEQ = 29603; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29358 WHERE SPEC_SEQ = 29604; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29324 WHERE SPEC_SEQ = 29605; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29326 WHERE SPEC_SEQ = 29606; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29328 WHERE SPEC_SEQ = 29607; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29330 WHERE SPEC_SEQ = 29608; UPDATE TSPCSMDTMAST SET SPEC_SEQ = 29331 WHERE SPEC_SEQ = 29609; UPDATE TSPCSMDTMAST S
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值