I have a large number of tables that have been created through the years,
and I wish to obtain the SQL statements used to create them. I can go
through and do it all by hand, but that would take forever. Is there a way
to run a script against the database that will generate them for me? If it
miss
I'm using the C API to return a record which has a field that contains
(somewhat) binary data. It's been properly mysql_escape_string()ed. I'm
using a 3.23.4x server & client.
When I do a:
select data into outfile 'out' from table where id='1';
from the mysql client, I get what I expect in the
t "reply to all")
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 11:34 AM
To: Hihn Jason; '[EMAIL PROTECTED]'
Subject: RE: Problems with UPDATE in v3.23.49 (is this a bug)
No, this is NOT a bug.
According to the manual (you rea
March 26 issue of PC Mag has a comparison of database engines, including
oracle, mysql and sql server (ack).
-Original Message-
From: Steve Rapaport [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 11:33 AM
To: [EMAIL PROTECTED]
Subject: Re: MySQL Power ?
I'm currently running
I have a table whose schema contains:
id INTEGER AUTO_INCREMENT,
gen_time TIMESTAMP,
rec_time TIMESTAMP,
repeats INTEGER DEFAULT 0,
PRIMARY KEY (id),
INDEX (rec_time))
When I do an:
UPDATE table SET repeats=repeats+1
gen_time gets updated as well:
mysql> select id, gen_time, rec_time, repea