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
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! Select queries for tables
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
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
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