LOAD XML INFILE 'test_file.xml'
INTO TABLE tbl_tutorials
CHARACTER SET utf8
ROWS IDENTIFIED BY '<row>'
;

CREATE TABLE IF NOT EXISTS tbl_tutorials(
    item_id INT(11) NOT NULL,
    title VARCHAR(100) NOT NULL,
    link VARCHAR(120) NOT NULL,
    description VARCHAR(400) NOT NULL,
    keywords VARCHAR (50) NOT NULL
) ;

<?xml version="1.0" encoding="UTF-8"?>
<tbl_tutorials>
<row>
    <item_id>1</item_id>
    <title>test title 1</title>
    <link>test link 1</link>
    <description>test description 1</description>
    <keywords>test keyword  1</keywords>
</row>
<row>
    <item_id>2</item_id>
    <title>test title 2</title>
    <link>test link 2</link>
    <description>test description 2</description>
    <keywords>test keyword 2</keywords>
</row>
<row>
    <item_id>3</item_id>
    <title>test title 3</title>
    <link>test link 3</link>
    <description>test description 3</description>
    <keywords>test keyword 3</keywords>
</row>

SET @xmlFile = load_file('c:xamppmysqldatatest_foldertest_file.xml ');
SELECT extractvalue(@xmlFile , '/tbl_tutorials/row/keywords') keywords;

------------
| keywords |
------------
|NULL      |
------------

----------------
| keywords     |
----------------
|test keyword 1|
----------------