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
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
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 say the
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'
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
sounds like you need SUM(field name)
- 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(field name)
- 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
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
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/t2/0001' into
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
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 user
13 matches
Mail list logo