Xml data import

2014-12-11 Thread Sayth Renshaw
What is the best way to manage xml data feeds with mysql? I have an xml data feed with xsd, it's complex in elements not size. Wray are the best way to get data into mysql, do I have to hack with xquery? My goal is to be able create queries and send csv files out for analysis in R and plots in gg

Re: command is not allowed with this MySQL version

2014-12-11 Thread yoku ts.
Hi, Christophe has already told, > > The used MySQL version is 5.5.40 from Debian Wheezy package. Maybe you missed *mysql command-line client's --local-infile option* $ bin/mysql mysql> SELECT @@version; ++ | @@version | ++ | 5.5.40-log | ++ 1 row in set (0

Re: command is not allowed with this MySQL version

2014-12-11 Thread Johan De Meersman
- Original Message - > From: "Christophe" > Subject: command is not allowed with this MySQL version > > 'The used command is not allowed with this MySQL version' Out of sheer morbid curiosity, what version were they running? -- Unhappiness is discouraged and will be corrected with kitt

command is not allowed with this MySQL version

2014-12-11 Thread Christophe
Hi there, One of our customers would like to modernize his IT : new servers with new OS, etc. But he got an old fashion PHP/MySQL application that make queries like this : LOAD DATA LOCAL INFILE '/files/tmp_import.csv' IGNORE INTO TABLE users FIELDS TERMINATED BY ';' LINES TERMINATED BY '\

Re: How to retrieve next record?

2014-12-11 Thread Johan De Meersman
- Original Message - > From: "Wm Mussatto" > Subject: Re: How to retrieve next record? > Related what is the form of the prmary key. If its numeric something like > $sDBQuery1 = "SELECT * FROM kentekenlogtest WHERE kenteken < > '$sActueelkenteken' limit 1" > might work. No, kenteken is

RE: How to retrieve next record?

2014-12-11 Thread Martin Gainty
If you *dont* mind implementing your fetch in PHP: Get ALL of the records into a resultset then fetch each record one a time from the resultset e.g. if($con != null) { //start $con!=null $res = mysqli_query($con, "SELECT *FROM Table"); //we have all records in $r

Re: How to retrieve next record?

2014-12-11 Thread Trianon 33
Trianon 33 schreef op 11-12-14 om 23:20: Wm Mussatto schreef op 11-12-14 om 23:07: On Thu, December 11, 2014 13:43, Larry Martell wrote: On Thu, Dec 11, 2014 at 4:34 PM, Trianon 33 wrote: Hi all, It seems like a simple question, however I'm not able to find the answer. Let me explain.

Re: How to retrieve next record?

2014-12-11 Thread Larry Martell
Please reply to the list and not to me directly On Thu, Dec 11, 2014 at 5:10 PM, Trianon 33 wrote: > > Larry Martell schreef op 11-12-14 om 23:04: >> >> On Thu, Dec 11, 2014 at 4:58 PM, Trianon 33 wrote: >>> >>> Larry Martell schreef op 11-12-14 om 22:43: On Thu, Dec 11, 2014 at 4:34 P

Re: How to retrieve next record?

2014-12-11 Thread Wm Mussatto
On Thu, December 11, 2014 13:43, Larry Martell wrote: > On Thu, Dec 11, 2014 at 4:34 PM, Trianon 33 wrote: >> Hi all, >> >> It seems like a simple question, however I'm not able to find the >> answer. >> >> Let me explain. I have a DB with lots of columns, one is labeled as >> 'kenteken' and i

Re: How to retrieve next record?

2014-12-11 Thread Larry Martell
On Thu, Dec 11, 2014 at 4:34 PM, Trianon 33 wrote: > Hi all, > > It seems like a simple question, however I'm not able to find the > answer. > > Let me explain. I have a DB with lots of columns, one is labeled as > 'kenteken' and it is also the primary key in the DB. I poke into this DB > with

How to retrieve next record?

2014-12-11 Thread Trianon 33
Hi all, It seems like a simple question, however I'm not able to find the answer. Let me explain. I have a DB with lots of columns, one is labeled as 'kenteken' and it is also the primary key in the DB. I poke into this DB with the command $sDBQuery1 = "SELECT * FROM kentekenlogtest WH

DAC for MySQL 2.10.2-beta is out!

2014-12-11 Thread Aleksander Andreev
MicroOLAP Direct Access Components for MySQL and Delphi/C++ Builder (also known as MySQLDAC) is a Borland Delphi/C++Builder component set for direct connect to MySQL database server. DAC for MySQL allows you to create Delphi/C++Builder applications without BDE, ODBC, ADO and without libmysql.dll.

回复: Re: forum vs email

2014-12-11 Thread xiangdongzou
DEAR guys: I think Email is good for search and I can download to my moible device. 2014-12-11 I AM AN ORACLE FANS! Skype:Frank.oracle Email:xiangdong...@gmail.com Name:东东堂 发件人:Mark Goodge 发送时间:2014-12-11 17:23 主题:Re: forum vs email 收件人:"mysql" 抄送: On 10/12/2014 23:40, Reindl Ha

Re: forum vs email

2014-12-11 Thread Johan De Meersman
- Original Message - > From: "Sándor Halász" > Subject: Re: forum vs email > Something more sophisticated than grouping messages by trimmed subject-lines? > maybe involving such header lines as were used in the old netnews (if e-mail > is That's only a single level. Fora are more often

Re: forum vs email

2014-12-11 Thread Mark Goodge
On 10/12/2014 23:40, Reindl Harald wrote: Am 10.12.2014 um 18:38 schrieb h...@tbbs.net: 2014/12/10 09:00 +0100, Johan De Meersman One of the (for me, at least) defining features of a forum, is that the subjects tend to be divided up into a tree structure, which has it's own benefits