Consult! SQL statement how to specify the keyword matching table to another table-CodePudding

Home > database > Consult! SQL statement how to specify the keyword matching table to another table

Consult! SQL statement how to specify the keyword matching table to another table

Time：12-01

Due to SQL server and mysql grammar is not very consistent, want to consult a great god, and the link within the needs statement how to use mysql to achieve? https://bbs.csdn.net/topics/392004987

 UPDATE a 
SET a new column=STUFF (b.N ewCol, 1, 1, ' ') 
The FROM information AS a 
CROSS the APPLY (SELECT the ', '+ parts the FROM keyword WHERE a. descriptions LIKE' % '+ +' % 'parts FOR XML PATH ('') AS b (NewCol)

CodePudding user response:

Page link：https//www.codepudding.com/database/90422.html

Prev:Directing the kernel source design implementation/performance tuning/operational best practice - eac

Next:River's lake emergency!

Tags：

MySQL

Links：
CodePudding