LOAD XML LOCAL INFILE about xml and sql column names should diffirent




CREATE TABLE person (
mid INT NOT NULL PRIMARY KEY,
parti VARCHAR(40) NULL,
say VARCHAR(40) NULL
) ENGINE=InnoDB COLLATE utf8_general_ci;


My XML:



<?xml version="1.0" encoding="utf-8"?>
<veriler>
<veri>
<MATNR>20000003</MATNR>
<CHARG>0001015759</CHARG>
<VERME>500,000</VERME>
</veri>
<veri>
<MATNR>20000003</MATNR>
<CHARG>0001015758</CHARG>
<VERME>500,000</VERME>
</veri>
</veriler>


My intro code:



$sorgu = mysql_query("LOAD XML LOCAL INFILE 'file.xml'
INTO TABLE stok
ROWS IDENTIFIED BY '<veri>'");
$q = mysql_query($sorgu);


My MySQL column names should mid, parti and say. My XML column names should not change. What an I add in "INTO TABLE stok". How can I do?


No comments:

Post a Comment