You don't need the MySQL server packages/libraries, but you WILL require the
client packages/libraries
On 11/21/2017 10:54 AM, Saline Vector wrote:
Howdy,
I have a situation where a data feed for a postgres system is disappearing at the end of the month. I get the same data feed to a MySQL
before passing it to the database:
"select sum(column) as columnSum from table where value in ( $ValueIDs
) and row_date between cast( ? as date) and cast( ? as date) "); ...
but this might not be appropriate in your application.
On Tue, Apr 5, 2016 at 12:24 PM, Bruce Ferr
I'm generating a sql statement like this:
sth = $mysql_dbh->prepare(
"select sum(column) as columnSum from table where value in ( ? ) and row_date
between cast( ? as date) and cast( ? as date) ");
sth->execute( $ValueIDs ,$week_start_date,$week_end_date);
$ValueIDs is a series of unquoted
On 12/26/2015 12:06 PM, James E Keenan wrote:
> On 12/26/2015 11:41 AM, Erick Ocrospoma wrote:
>> Hello greate community!
>>
>> This is my first message into this list :-), I hope I could get some help
>> about this tricky issue.
>>
>> I'm trying to install manually Perl DBI 1.52 on a el6 server.
Bruce,
The error says your script is attempting to load
/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so
for DBD::Oracle. is that the correct path for that library? it looks like you built DBD::Oracle against the Oracle occi libraries and those are often in different locations than
the
1
Any ideas on how I can get the libraries and headers to build DBD::mysql?
Thanks in advance
Bruce Ferrell
Alexander Foken wrote:
On 13.05.2009 02:59, Brian Manning wrote:
Can you tell me why I'm getting this error:
DBD::mysql::st execute failed: Can't create/write to file
'/tmp/result.csv' (Errcode: 2)
You don't have create/write permissions to the /tmp directory on your
remote host as
Given the following code:
$sql=SELECT convert_tz( a.stamp,'GMT','$tz' ) as ts, a.status,
a.reason, a.tl
INTO OUTFILE '/tmp/result.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '\'
LINES TERMINATED BY '\n'
FROM alerts a
WHERE a.stamp BETWEEN ? AND ?