CODEWITHSUNDEEP
mysqlsqlsql-server
Aman
Aman

Reputation: 31

Convert Sql Server Query to MySql Server Query

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

Upvotes: 1

Views: 63

Answers (2)

ScaisEdge
ScaisEdge

Reputation: 133370

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

Upvotes: 1

Strawberry
Strawberry

Reputation: 33945

Crudely...

Update @ABC   
  From @workA, luGroup g

  Set grpId = g.GroupId

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

Upvotes: 1

Related Questions