Here's a messy hack that would let you use your column names like
'a35#70' to select and insert.
Set up a table like this:
col1a35#70
col2a35#71
col3a35#72
...
Then make a routine in your middleware that select * from this
table and returns the results in a named array or hash array
Just reading that MySQL AB has a new CEO
http://www.mysql.com/news/article-67.html. I was wondering if
anyone has any info. regarding the future direction of Mysql with
respect to the open source community. The news release mentions
stuff like value-add services and the pursuit of sound
business
If you are familiar with perl, try using DBD::ODBC module to pull
the data out of Access and use the DBD mysql modules to write the
data to mysql. You will have to set up the table structure in
mysql to match your Access.
-Original Message-
From: Ute Hoffmann [mailto:[EMAIL PROTECTED]]
If you are going to be processing Excel files regularly and don't
want to manually export each one into CSV, try the perl method.
The module is called Spreadsheet::ParseExcel, I needed to
manually install IO::Scalar first to get it to work though.
-Original Message-
From: Artem Koutchine
I've noticed some people seem to be forgetting about their
middleware when approaching a programming challenge. In many
cases, information to and from the database is processed using C,
java, perl, php, etc. These languages can do pre and post
processing of data. I have found this approach is e
I don't think that works across platformsits better to use
the mysqldump command.
Brian
-Original Message-
From: René Tegel [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 14, 2001 5:09 PM
To: rozakdemir; [EMAIL PROTECTED]
Subject: Re: win to linux
use ftp to copy your database/t
You may also want to check CPAN for Spreadsheet::ParseExcel. I haven't dug
into it too deep yet, but it looks like it can parse native .xsl data.
Brian
-Original Message-
From: Ken Menzel [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 19, 2001 11:08 AM
To: Joe Ferrara; [EMAIL PROTECT
I noticed a little quirk when searching the manual...it seems that sometimes
when doing consecutive searches, the root directory disappears in the "href"
tags for the results:
for example resulting link will look like this:
http://p/e/Perl_support_problems.html
instead of something like
lause.
-Original Message-
From: Scott Baker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 16, 2001 5:34 PM
To: Brian Kaney; mySQL Mailing List
Subject: Re: SELECT WHERE fieldtype
You have to select a certain row, there is no way to say all rows that are
NOT an int.
At 04:33 PM 1/16
Is there a way to SELECT FROM table WHERE field_type IS (NOT) 'something'.
For example, 'something' could be TIMESTAMP, INT, FLOAT, AUTO_INCREMENT,
etc...I looked through the manual and archives to no avail.
You can specify field order with the LOAD DATA
command...then you'll never have to worry about the
order of the table columns.
LOAD DATA INFILE 'x' INTO table (field3,field1,field2)
double check the LOAD DATA syntax in the manual.
Brian
--- Marcus Ouimet <[EMAIL PROTECTED]> wrote:
> OK, I am re
You can specify field order with the LOAD DATA
command...then you'll never have to worry about the
order of the table columns.
LOAD DATA INFILE 'x' INTO table (field3,field1,field2)
double check the LOAD DATA syntax in the manual.
Brian
--- Marcus Ouimet <[EMAIL PROTECTED]> wrote:
> OK, I am re
If the manual was written any better, you'd put all those book publishers
out of business. The reason this list has such a high volume of traffic
might not be ambiguity of the online manual, rather the popularity of MySQL.
The contents of the manual are more than sufficient, but the search could
13 matches
Mail list logo
