MySQL XML 25 codes

  1. Home
  2. MySQL
  3. XML
1 Choose element by value
2 Concatenate value from EXTRACTVALUE function
3 EXTRACTVALUE fuction and
4 EXTRACTVALUE function and calculation
5 EXTRACTVALUE function and tagName
6 EXTRACTVALUE function and wild card
7 EXTRACTVALUE(MATCH_INFO, match)
8 EXTRACTVALUE(MATCH_INFO,match@number)
9 EXTRACTVALUE(MATCH_INFO,townwon)
10 Get all address information for the corresponding Employee
11 Get all the data of the Employee concerned
12 Get descendant
13 Get the last phone number of the relevant Employee
14 Get the match number and team number
15 Get the match number and the town of the first address
16 Match two values from one EXTRACTVALUE function
17 Query xml data with path
18 Replace result from EXTRACTVALUE
19 Set xml data with UPDATEXML function
20 The value of the first element
21 Update xml value
22 Using EXTRACTVALUE function
23 Using EXTRACTVALUE function in where clause
24 Using EXTRACTVALUE function with xml data
25 Xml data column