select * from emp where `file#` = 1332;
returns
ERROR 1054: Unknown column 'file' in 'where clause'
-Original Message-
From: Bernard Clement [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 1:19 PM
To: Howell, Scott; Mysql (E-mail)
Subject: Re: HELP! Selec
I am trying to query a table that has field names with # characters in them.
For example a table emp_earn has a field called FILE#
I need to do a query where FILE# = 1332, but anything I try errors out.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
This query below is running REALLY slow. The indexes and EXPLAIN result are below.
Last week this query was running in <20 sec, now it takes so long (>20 mins). No I
reloaded all the data from the oe-invoice table over the weekend. as I do every
weekend. I have noticed that sometimes the query p
Has anyone written a perl script to get records from another database and
write it to a file on mysql's LOAD DATA INFILE format? I just need some
pointers in perl so a LOAD DATA INFILE will be read correctly.
For example, a perl script:
Select * from emp from a Progress database
Will write to a te
I am looking for a simple extraction/load program to load data daily from a
Progress 8.3B database via ODBC to a mysql 3.23.57 database. It does not
necessarily need to do any data-type transforms. It need to run on Windows
2000 and be able to run it as a service, or as a cron task if running unde