SQL update query issue

Question

I just accidentally noticed that a Query like

Update tableA tableA set id = '5'

Works fine. Should this give error as I am using table name twice here. Any thoughts why is this working fine ?

thanks for pointing out edited the question. It was a typo

Andy897
– Andy897

2014-03-26 20:37:54 +00:00
Commented Mar 26, 2014 at 20:37 — Andy897
– Andy897, Commented Mar 26, 2014 at 20:37

Radu Gheorghiu · Accepted Answer · 2014-03-26 20:20:41Z

2

Because the second tableA is seen as an alias. There is no constraint in regards to the name of the alias, so you can have the same name on the alias as the table name.

answered Mar 26, 2014 at 20:20

Radu Gheorghiu

20.6k16 gold badges78 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Andy897 Over a year ago

Ahh.. how stupid of me .. Should have guessed that :\

Radu Gheorghiu Over a year ago

@Andy897 Happens to the best of us :)

Ayfan · Accepted Answer · 2014-03-26 20:39:09Z

2

your code exactly equal

Update tableA as 'tableA' set id = "5"

or

Update tableA as "tableA" set id = "5"

this is simple alias as Sql Alias Tutorial

edited Mar 26, 2014 at 20:39

answered Mar 26, 2014 at 20:25

Ayfan

296 bronze badges

2 Comments

user330315 Over a year ago

You have the quotes the wrong way. In (standard) SQL identifiers are quoted with double quotes and string literals are enclosed in single quotes.

Ayfan Over a year ago

ooooh so sorry I am coming from mysql area so that's allowed in our area butI will add it as "or"

Collectives™ on Stack Overflow

SQL update query issue

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related