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
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
- 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
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
'\
- 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
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
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.
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
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
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
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
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.
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
- 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
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
15 matches
Mail list logo