kathygriffin
Members-
Posts
33 -
Joined
-
Last visited
kathygriffin's Achievements
Newbie (1/5)
0
Reputation
-
loading xml file into mysql using xampp shell version 1.8.2
kathygriffin replied to kathygriffin's topic in MySQL Help
Actually I did that wrong It will look like this. <?xml version="1.0" encoding="UTF-8"?> <add> <doc><field name="id">something</field> <field name="other1">something2</field> <field name="other3">something3</field> <field name="other4">something4</field> <field name="other5">something5</field> <field name="other6">something6</field> <field name="other7"><![CDATA[something7]]></field> <field name="other8"><![CDATA[something8]]></field> <field name="other9"><![CDATA[something9.jpg]]></field> <field name="other10a"><![CDATA[<p></p>]]></field> <field name="other10">something10</field> <field name="other11">something11</field> <field name="other12">something12</field> <field name="other13">something13</field> <field name="other14">something14</field> <field name="other16">something15</field> <field name="other16">something16</field> <field name="other18">something17</field> <field name="other18">something18</field> <field name="other18">something19</field></doc> </add> -
mysql event only querying half of the rows? bug?
kathygriffin replied to kathygriffin's topic in MySQL Help
Well that still doesn't explain why it only queried half of the items. Because it did keep on querying.But on the old stuff..So that one I have yet to figure out. It works now and I am happy. Is there any log anywhere that might say? thank you -
mysql event only querying half of the rows? bug?
kathygriffin replied to kathygriffin's topic in MySQL Help
Its the same exact query that I am sure of. Its 5.1.73 For some reason when I added another 20,000 items it never queried everything. Only the old stuff. So I deleted the even then readded it. Any suggestions or ideas where to look or what to do besides upgrading mysql? Thanks -
loading xml file into mysql using xampp shell version 1.8.2
kathygriffin replied to kathygriffin's topic in MySQL Help
Thank you for letting me. Ok Here is what I am dealing with. Only its about 200,000 items. <?xml version="1.0" encoding="UTF-8"?> <add> <doc><field name="id">something</field> <field name="other1">something2</field> <field name="other3">something3</field> <field name="other4">something4</field> <field name="other5">something5</field> <field name="other6">something6</field> <field name="other7"><![CDATA[something7]]></field> <field name="other8"><![CDATA[something8]]></field> <field name="other9"><![CDATA[something9.jpg]]></field> <field name="other10a"><![CDATA[<p></p>]]></field> <field name="other10">something10</field> <field name="other11">something11</field> <field name="other12">something12</field> <field name="other13">something13</field> <field name="other14">something14</field> <field name="other15">something15</field> <field name="other16">something16</field> <field name="other17">something17</field> <field name="other18">something18</field> <field name="other19">something19</field></doc> </add> -
mysql event only querying half of the rows? bug?
kathygriffin replied to kathygriffin's topic in MySQL Help
Wow thats exactly what it was. Turns out whenever you add more rows of data you have to go in and delete the old event then add it again. I am using 5.1 something i believe. Is this a bug or is this how mysql events are suppose to be ? -
mysql event only querying half of the rows? bug?
kathygriffin replied to kathygriffin's topic in MySQL Help
I went ahead and deleted the event then added in a new one... I will keep eveyone posted. -
ok so I had this database of 20,000 items. My part numbers I had to add a gg in front of all them then add them into the same database. So I had the old part numbers that looked like this 33344 and new part numbers that looked like this gg33344. Now for some reason it is only totaling up the old numbers and not the new numbers. The same exact query with a recently new database was built and seems to have no issue with the letters being in front. So my guess is that if you insert new items into database you have to readd the event? Anyone have any ideas or input? example of new database after query ran for total my query is something like this total = (stock ny+ stock nc ) part number - stock ny - stock nc - total 33344 5 6 11 gg33344 5 6 0 34344 5 6 11 gg34344 5 6 0 36344 5 6 11 gg36344 5 6 0 thanks
-
loading xml file into mysql using xampp shell version 1.8.2
kathygriffin replied to kathygriffin's topic in MySQL Help
bump -
loading xml file into mysql using xampp shell version 1.8.2
kathygriffin replied to kathygriffin's topic in MySQL Help
bump -
loading xml file into mysql using xampp shell version 1.8.2
kathygriffin replied to kathygriffin's topic in MySQL Help
Sorry.. Heres what I am working with USE things; LOAD XML LOCAL INFILE 'C:/Users/computer/Documents/items.xml' INTO TABLE everything ROWS IDENTIFIED BY '<doc>'; /g Now in the xml file I have more than one field name that is named the same thing. For example I have 3 stuff2 and 4 stuff3s In my mysql table with the code I am using about it inserts only the first field of stuff2 and first field of stuff3s. So I setup stuff2 then stuff2a then stuff2b how would I get it setup to into the mysql column names that do match. -
loading xml file into mysql using xampp shell version 1.8.2
kathygriffin replied to kathygriffin's topic in MySQL Help
How would I extract xml to go into the correct rows where the xml stuff1 is in there 4 times. I can't use stuff1 in mysql column because it will not allow me to use the same name... Any suggestions? -
loading xml file into mysql using xampp shell version 1.8.2
kathygriffin replied to kathygriffin's topic in MySQL Help
Actually I just tried USE stuffdb; LOAD XML LOCAL INFILE 'C:/Users/computeruser/Desktop/stuff.xml' INTO TABLE stuff_load ROWS IDENTIFIED BY '<doc>' ; /g I will find out in about 4 hours if it worked.. -
loading xml file into mysql using xampp shell version 1.8.2
kathygriffin replied to kathygriffin's topic in MySQL Help
I did look at what you sent you but I am a bit confused here so if I have it right I would have to use it like this >>> USE stuffdb; LOAD XML LOCAL INFILE 'C:/Users/computeruser/Desktop/stuff.xml' INTO TABLE stuff_load (stuff1,stuff2, stuff3, stuff4, stuff5, stuff6, stuff7, stuff8, stuff9) ROWS IDENTIFIED BY '<doc>' /g Correct? -
loading xml file into mysql using xampp shell version 1.8.2
kathygriffin replied to kathygriffin's topic in MySQL Help
A. Some files are 100 mb some others are about 200 mb. Some part numbers contains more data then others. B. I'm not seeing row anywhere. I have provided a example below. Thanks <doc><field name="id">22439789</field><field name="prtnmbr">22439789</field><field name="subprtnmbr">22439930</field><field name="mannmbr">00955tr</field><field name="listprc">370.95</field><field name="updatedate">2014-01-01T01:56:03Z</field><field name="iname"><![CDATA[TIRE 190/55 ZR17 PILOT ROAD3 B]]></field><field name="vname"><![CDATA[MICHELIN]]></field><field name="atrribute"><![CDATA[BIAS / RADIAL, RADIAL]]></field><field name="atrributevalueid">11</field><field name="atrribute"><![CDATA[SPEED RATING, (W)->168 MPH]]></field><field name="atrributevalueid">118</field><field name="atrribute"><![CDATA[LOAD INDEX, 75-853 LBS]]></field><field name="atrributevalueid">154</field><field name="producttype"><![CDATA[TIRES]]></field><field name="atrribute"><![CDATA[FADE, REAR]]></field><field name="atrributevalueid">464</field><field name="atrribute"><![CDATA[TUBE TYPE, TUBELESS]]></field><field name="atrributevalueid">556</field><field name="atrribute"><![CDATA[TIRE INNER DIAMETER, 17 INCH]]></field><field name="atrributevalueid">561</field><field name="atrribute"><![CDATA[WIDTH, 190 MM]]></field><field name="atrributevalueid">588</field><field name="atrribute"><![CDATA[ASPECT RATIO, 55]]></field><field name="atrributevalueid">593</field><field name="atrribute"><![CDATA[PURPOSE, STREET]]></field><field name="atrributevalueid">608</field><field name="atrribute"><![CDATA[TIRE LINE, PILOT ROAD]]></field><field name="atrributevalueid">677</field><field name="atrribute"><![CDATA[TIRE BRAND, MICHELIN]]></field><field name="atrributevalueid">689</field><field name="atrribute"><![CDATA[VERSION, LOADED/TWO-UP]]></field><field name="atrributevalueid">692</field></doc> -
loading xml file into mysql using xampp shell version 1.8.2
kathygriffin replied to kathygriffin's topic in MySQL Help
bump....