In MySQL, when writing SQL statements, you may encounter the error of you can ' t specify target table ' table name ' for update in FROM clause, which means that you cannot select some values from the same table before the UPD Ate this t
MySQL in your can ' t specify target table for update in FROM clause error means that you cannot select some of the values in the same table first, and then update the table (in the same statement).Example: DELETE from Sys_org_relation where Porgid in (Select Porgid from Sys_org_relation R where r.corgid= ' customer ID
The following example uses MERGE to update or insert rows to modify the SalesReason table. When the NewName value in the source table matches the value in the Name column of the target table (SalesReason), The ReasonType column in the target
There are various tables in the DB2 database. This article will introduce you to the clustering target table. This table is a special table in DB2. If you are interested in this, take a look.
There is a special table in the DB2 database called the clustering
Datastage obtains the number of records inserted into the target table by analyzing logs.
This is only a bad method, and there may be better and easier methods. This method requires that the existing log information be deleted before each job is run. Otherwise, the correct number of records cannot be counted. Of course, after the job is run, you can back up the logs of this job to the server disk in shell
In the process of creating the data Warehouse, you often encounter such problems, for example: the source table because of business reasons for the new field, and ETL program is extracted according to the previous source table structure, if you do not rebuild the ETL program, the new indicator will not flow into the DW, the problem is as shown inCreate a simple input and outputAs shown, there is a column3 f
the existing information, you have the following sql: /**
/updateset= (select from where= t2.id); View Code Quote "1093-you can ' t specify target table ' t ' for update in FROM clause" exception. It means that you can't specify the updated target table in the FROM clause (English is not good, even if you know each wo
GoldenGate dml target table of synchronization process and field processing test
-- Experiment: For goldengate processes that only have dml synchronization, if the source end performs the ddl plus field operation, how to deal with the corresponding process
-- Source orcl-- First check the Process status, running status:[Oracle @ localhost ogg] $./ggsciGGSCI (localhost. localdomain) 1> info all
Program Statu
Today in writing MySQL encountered a more specific problem.
The MySQL statement is as follows:
Update Wms_cabinet_form Set Cabf_enabled=0
where cabf_id in (
SELECT wms_cabinet_form.cabf_id from Wms_cabinet_form
Inner Join wms_cabinet on wms_cabinet_form.cabf_cab_id = wms_cabinet.cab_id
Inner Join Wms_cabinet_row on wms_cabinet.cab_row_id =wms_cabinet_row.row_id
where wms_cabinet_row.row_site_id=27 and Wms_cabinet_form.cabf_enabled=1)
The runtime pre
I encountered a special problem writing mysql today.
The mysql statement is as follows:
Update wms_cabinet_form set cabf_enabled = 0Where cabf_id in (SELECT wms_cabinet_form.cabf_id FROM wms_cabinet_formInner Join wms_cabinet ON wms_cabinet_form.cabf_cab_id = wms_cabinet.cab_idInner Join wms_cabinet_row ON wms_cabinet.cab_row_id = wms_cabinet_row.row_idWhere wms_cabinet_row.row_site_id = 27 and wms_cabinet_form.cabf_enabled = 1)
The following prompt
Tags: style io color os ar for SP data onThis error means that you cannot select some of the values in the same table, then update the table (in the same statement), the solution does not directly query the same, assuming that the table to be updated to a, the data of a is first put to table B, and then query from
In mysql, You can't specify target table for update in FROM clause. specifyclause
In mysql, You can't specify target table for update in FROM clause errors mean that some values in the same table cannot be selected first, update the tabl
MySQL in your can ' t specify target table for update in FROM clause error means that you cannot select some of the values in the same table first, and then update the table (in the same statement). For example, the following SQL:Delete fromTblwhereIdinch ( Select Max(ID) fromTBL Awhere EXISTS (
Operating environment: There are table Game_list, fields: uid,score1,score2,seat_id,last_update;The incoming parameter is I_player_detail, the incoming value is multiple user ID, before score, after score, seat number, and each user's data is separated by a semicolon (;);Operation Objective: To insert the corresponding properties of each user into the corresponding field of the target
Operating Environment: There are table Game_list, fields: uid,score1,score2,seat_id,last_update; The incoming parameter is I_player_detail, the passed-in value is the ID of multiple users, the previous score, after the score, Seat numbers, each user's data separated by semicolons (;); Action Purpose: To insert the corresponding properties of each user into the corresponding field in the target
Chkpt
MANAGER RUNNINGExtract stopped DPUMP1 00:00:00 00:00:11Extract stopped EXT1 00:00:00 00:00:09
-- Target orcltest-- Check that the replication process is running and stops the process:GGSCI (localhost. localdomain) 8> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNINGReplicat running REP1 00:00:00
GGSCI (localhost. localdomain) 9> stop *
Sending STOP request to REPLICAT REP1...Request processed.
-- Source orcl-- Add a
Problem:A problem was encountered today when removing duplicate data from the MySQL database. The following script:DELETE from WHERE inch (SELECTMAXas fromGROUP by Name,age)An error message will appear:You can ' t specify target table ' Tempa ' for update in FROM clauseBasically, in the same statement, you cannot select some of the values in the same table first
Error occurred during development execution:Update Bm_area Set level = 2 where Parent_code in (select B.parent_code from Bm_area as b where b.level = 1);ERROR 1093 (HY000): You can ' t specify target table ' Bm_area ' for update on FROM clauseGeneral use:CREATE TABLE tmp as select B.parent_code from Bm_area as b where b.level = 1;Update Bm_area Set level = 2 wher
In mysql, user information is intercepted cyclically and inserted into the corresponding fields of the target table. mysql user information
Operating Environment: Table game_list, field: uid, score1, score2, seat_id, last_update;The input parameter is I _player_detail. The input value is the id, previous score, post score, and seat number of multiple users. Data
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.