Is there a way to re-read the variables in my.cnf without having to re-start
the server. I realize that I could manually change most of the variables,
but being lazy as I am, having the server just re-read its settings would be
idea.
Thanks,
Eric
--
MySQL General Mailing List
For list archive
I'm attempting to put an image into a BLOB field. I'm using Visual Basic 6
with ADO, although I wouldn't think that's making a difference.
I create a string that contains the binary representation of the file. At
this point the string is 5064 characters long. I call mysql_escape_string
and the
res me to alter the application everytime I change the
table, which I don't always want to do.
> -Original Message-
> From: Henrik Schröder [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 29, 2004 3:07 PM
> To: 'Eric J. Janus'; 'MySQL'
> Subject: RE: IN
tterley [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 29, 2004 2:25 PM
> To: 'Eric J. Janus'; 'MySQL'
> Subject: RE: INSERT ... SELECT question
> Importance: Low
>
>
> Oh, if only there were views!! That would make this easy. Maybe soon
> (*please*). :
ion, but I was hoping that MySQL had
something built in to make this easier.
Thanks,
Eric
> -Original Message-
> From: Matt Chatterley [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 29, 2004 2:11 PM
> To: 'Eric J. Janus'; 'MySQL'
> Subject: RE: INSERT ..
I have a table with just about 100 columns, and I would like to duplicate a
row exactly, except for one column, which is the AUTO_INCREMENT column.
Using 'INSERT INTO tbl_name SELECT * FROM tbl_name WHERE id_col = 1' doesn't
work, because it produces the following error: 'ERROR 1062: Duplicate ent
