Convert Sql Server Query to MySql Server Query

Question

Good Morning

I am Trying to Convert Sqlserver Join to Mysql server Join , Anyone please help me on this

Sql Server Code

 Update @ABC   
  Set grpId = g.GroupId
  From @ABC, luGroup g
  Where typeWrd = g.GroupName  
  and g.GroupTypeId = @gtid

Description :

@Abc    -- temporary table
luGroup -- Normal Table

Please help me to Convert this code to Mysql , i shall be thankful to you

Thanks Amandeep

Are @ABC and @workA meant to be the same table variable (not temp table)? Also, that's fairly bad original SQL Server code to start from. Whoever wrote it hasn't learnt that Standard SQL got explicit join syntax over a quarter of a century ago and any SQL database product you're likely to encounter these days has probably adopted this part of the standard decades ago. — Damien_The_Unbeliever
– Damien_The_Unbeliever, Commented Jul 24, 2018 at 5:58
@Damien_The_Unbeliever : Sorry , Now please check it I changed the code, Sorry again for Wrong — Aman
– Aman, Commented Jul 24, 2018 at 6:08

ScaisEdge · Accepted Answer · 2018-07-24 05:53:08Z

1

change the update from clause

Update @workA a    
INNER JOIN luGroup g ON a.typeWrd = g.GroupName  
AND g.GroupTypeId = @gtid
Set grpId = g.GroupId

answered Jul 24, 2018 at 5:53

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

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

Comments

Strawberry · Accepted Answer · 2018-07-24 05:51:58Z

1

Crudely...

Update @ABC   
  From @workA, luGroup g

  Set grpId = g.GroupId

Where typeWrd = g.GroupName  
  and g.GroupTypeId = @gtid

answered Jul 24, 2018 at 5:51

Strawberry

34k14 gold badges43 silver badges57 bronze badges

Add small explanation even though code is explanatory