i have this as part of /etc/my.cnf, all data file are in the directory
/my. be sure to set your permissions on /my to the mysql user
[mysqld]
datadir=/my
- hcir
On Monday, Oct 14, 2002, at 10:19 America/Anchorage, Niranjan Patel
wrote:
> I get that point but is there any other way we can
> c
select * from table where substring(timestampField,1,8) = 'MMDD'
from Perl, execute this statement and then process each returned row
- hcir
> My mysql database is set up having a field cdate
> -> cdate datetime
>
> has the format
>
> -00-00 00:00:00
>
> If I want to fetch rows for sa
show tables;
On Wednesday, Oct 9, 2002, at 05:43 America/Anchorage, Inbal Ovadia
wrote:
> Hi all,
> There is a way to know if I have table x in my db?
> Let's say some catalog tables that hold information about the db like
> tables
> name etc.
> and i can do query like "select tables from cata
the permissions on the file and the enclosing directory (all the way up
to the root dir) must allow for execution
also, my.cnf need to have
[mysqld]
local-infile=1
#!/usr/bin/perl
use DBI;
$dbh = DBI->connect( "dbi:mysql:databasename", 'user', 'password', {
PrintError => 0 } ) or die
check the permissions of the enclosing directory
- hcir
On Monday, Oct 7, 2002, at 17:43 America/Anchorage, Unidux (MIS) - K
Sudhir wrote:
> Hi,
>
> When i try to query ... load data infile ...
> i am getting the following error ...
> ERROR 13: Can't get stat of 'upload_fct_HQ_CA001S.txt' (Err
sounds like you need SUM()
- hcir
> Hi,
>
> I wanting to know what the sql statement is that will let me get the
> total
> of database. The feild is amount. I have tried a couple of sql
> statement and
> have even looked at mysql 6.3.3.1 Arithmetic Operations. But I am lost.
sounds like you need SUM()
- hcir
> Hi,
>
> I wanting to know what the sql statement is that will let me get the
> total
> of database. The feild is amount. I have tried a couple of sql
> statement and
> have even looked at mysql 6.3.3.1 Arithmetic Operations. But I am lost.
since your are already using Perl, check out DBI at www.cpan.org
- hcir
On Monday, Sep 23, 2002, at 17:52 America/Anchorage, William Martell
wrote:
> Hello All,
>
> I am building a web robot in perl that will find equipment from various
> manufacturers and will get information about that equip
THANKS!!
that works!
- hcir
> I have had luck by removing the word LOCAL from the statement.
>
> -=Bryan=-
>>
>> from the mysql command line, load data local infile DOES
>> work, am trying to get this to work from Perl
>>
>> $sth = $dbh->prepare("load data local infile
>> '/users/hcir/desktop
i have read several archives/docs on this but still can not get this to
work
from the mysql command line, load data local infile DOES work,
am trying to get this to work from Perl
$sth = $dbh->prepare("load data local infile
'/users/hcir/desktop/t2/0001' into table s0001");
$sth->execute() or
iH
getting the following after issueing
./configure --mandir=/usr/local/share/man/ --with-innodb
make
ld: Undefined symbols:
_tgoto
_tputs
_tgetent
_tgetflag
_tgetnum
_tgetstr
make[2]: *** [mysql] Error 1
make[1]: *** [all-recursive] Error 1
make: *** [all-recursive-am] Error 2
anyone have the
mysql> create table mytest (
-> my_1 varchar(5)
-> );
Query OK, 0 rows affected (0.32 sec)
mysql> alter table mytest change my_1 my_file_1 varchar(5);
Query OK, 0 rows affected (0.23 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> show columns from mytest;
+---++
iH
running mySQL 3.23.51, i have a my.cnf file with local-infile=1 and am
able to use the "load data local file" command when running run the
interactive mysql app (command line).
my problem is that i can not use the "load data local" command from a
Perl script. i am connecting as the same us
13 matches
Mail list logo
