StackOverflow Questions for Tag: mysql-error-1093

Cozzy
Cozzy

Reputation: 651

Insert and set value with max()+1 problems

Score: 64

Views: 269819

Answers: 11

Read More
Sergio del Amo
Sergio del Amo

Reputation: 78136

MySQL Error 1093 - Can't specify target table for update in FROM clause

Score: 854

Views: 793752

Answers: 18

Read More
CSchulz
CSchulz

Reputation: 11040

You can't specify target table for update in FROM clause

Score: 457

Views: 370838

Answers: 12

Read More
Martin Ocando
Martin Ocando

Reputation: 924

Can't update table with the same column from next record Error 1093

Score: 0

Views: 41

Answers: 1

Read More
bobobobo
bobobobo

Reputation: 67346

MySQL Getting around error 1093

Score: 4

Views: 9683

Answers: 6

Read More
T. Brian Jones
T. Brian Jones

Reputation: 13542

How do I lock read/write to MySQL tables so that I can select and then insert without other programs reading/writing to the database?

Score: 38

Views: 109876

Answers: 6

Read More
user394486
user394486

Reputation: 61

how to delete duplicate rows from a table in mysql

Score: 6

Views: 9204

Answers: 1

Read More
jlengstorf
jlengstorf

Reputation: 447

MySQL INSERT Using Subquery with COUNT() on the Same Table

Score: 5

Views: 19824

Answers: 5

Read More
egervari
egervari

Reputation: 22522

SQL UPDATE with sub-query that references the same table in MySQL

Score: 40

Views: 106138

Answers: 7

Read More
Paul Santoro
Paul Santoro

Reputation: 13

MySQL Error 1093 - Can't specify target table for update in FROM clause (two joins)

Score: 0

Views: 291

Answers: 2

Read More
pipoca_com_sazom
pipoca_com_sazom

Reputation: 1

error 1093, but there is no selection in the subquery

Score: 0

Views: 41

Answers: 0

Read More
Kazzed
Kazzed

Reputation: 3

Mysql - You can't specify target table for update in FROM clause - Subquery misunderstanding?

Score: 0

Views: 162

Answers: 1

Read More
Daniel Kahle
Daniel Kahle

Reputation: 69

MySQL insert with select on same table

Score: 0

Views: 1912

Answers: 2

Read More
Martin Ocando
Martin Ocando

Reputation: 924

Error referencing main table on lookup subquery for update

Score: 0

Views: 75

Answers: 2

Read More

mysql error code 1093: You can't specify target table for update in FROM clause

Score: 1

Views: 4107

Answers: 3

Read More
LazNiko
LazNiko

Reputation: 2123

Update with percentage calculation on the same table

Score: 0

Views: 2225

Answers: 2

Read More
nfzhlk
nfzhlk

Reputation: 1

Mysql delete by primary key with select(error 1093)

Score: 0

Views: 102

Answers: 1

Read More
Waka Waka
Waka Waka

Reputation: 95

Update For all loans WHERE user_id=? in CASE when DATEDIFF() >0. Error 1242 and 1093

Score: 1

Views: 67

Answers: 1

Read More
markzzz
markzzz

Reputation: 48035

Delete - I can't specify target table?

Score: 48

Views: 38532

Answers: 2

Read More
user3649154
user3649154

Reputation: 21

how to cut the strings before a particular strings in sql

Score: 0

Views: 80

Answers: 2

Read More
PreviousPage 1Next