Re: 5.0.15 error 1054

iH Swawn, thanks for the quick reply and the pointing out the change, after reading the new mysql syntax doc i have my query qorking again On Oct 31, 2005, at 9:12 AM, [EMAIL PROTECTED] wrote: hcir <[EMAIL PROTECTED]> wrote on 10/31/2005 12:37:15 PM: > iH > > i saw this

5.0.15 error 1054

iH i saw this report as a bug for previous mysql versions but not for 5.0.15 ERROR 1054 (42S22): Unknown column 'c.len' in 'on clause' the query that generated this works fine of mysql 5.0.11 others having this issue? using OS X 10.4 (32bit) thanks Rich Allen Dare & Do -- MySQL General M

Re: Thoughts on MySQL training?

i attended this class back in September, it was MORE than worth the cost!! - hcir mysql sql On Wednesday, Apr 2, 2003, at 12:26 America/Anchorage, Rachel Rodriguez wrote: I should have been more specific: we're looking at the "Using and Managing MySQL" training. Opinions a

Re: Default data dir

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

Re: fetching specific date from datetime field

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

Re: information about the tables in the database

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

Re: Problems with LOAD DATA LOCAL INFILE

PrintError => 0 } ) or die "Can't connect to mysql database: $DBI::errstr\n"; $input = "load data infile '/users/hcir/p99x/palmer/last/trk' into table trk"; $dbh->do($input) or warn "$DBI::errstr\n"; $dbh->disconnect or print &q

Re: Error with LOAD DATA INFILE

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 '

Re: Get the total of a feild

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 Oper

Re: Get the total of a feild

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 Oper

Re: Create Tables Dynamically

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 informatio

Re: load data local infile

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->prepa

load data local infile

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&quo

compiling 4.0.3 on OS X 10.2

the correct procedure for comiling under Jaguar? thanks - hcir - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

Re: Data Entry for a Newbie

e many others that will also work, ie. PHP -- hcir [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

Re: how to update time field with current time?

Now() will update to the current time Insert into table values(now()); - hcir [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list a

Re: phpMyAdmin and mysql 3.23.49

around this new "feature"? Thanks. > > Bz > > On Fri, 2002-07-05 at 10:14, hcir wrote: >> starting with version 3.23.49, load data local is dis-abled >> >> see this URL for more info >> >> http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html >>

Re: phpMyAdmin and mysql 3.23.49

> This is what I got: > > The used command is not allowed with this MySQL version > > I think the "used command" here is referring to "load data local > infile". Has anyone else had this problem? Any w

Re: changing coulmn

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; +---++

Perl/DBI & load data local

nnecting as the same user and i do with the command line. other command such as connect, disconnect, insert, select do work what am i missing to allow the same access via Perl as with the command line thanks - hcir [EMAIL PROTECTED]