Home
SQL / MySQL
Aggregate Functions
Backup Load
Command MySQL
Cursor
Data Type
Database
Date Time
Engine
Event
Flow Control
FullText Search
Function
Geometric
I18N
Insert Delete Update
Join
Key
Math
Procedure Function
Regular Expression
Select Clause
String
Table Index
Transaction
Trigger
User Permission
View
Where Clause
XML
Element « XML « SQL / MySQL
SQL / MySQL
XML
Element
1.
The value of the first element
2.
Choose element by value
3.
Xml data column
4.
Get the match number and the town of the first address
5.
Get the last phone number of the relevant Employee.
6.
Get the match number and team number.
7.
Get all address information for the corresponding Employee.
8.
Get all the data of the Employee concerned.