Re: FLUSH syntax query

2005-01-08 Thread Gleb Paharenko
Hello. Yes. Karam Chand <[EMAIL PROTECTED]> wrote: > So if I use FLUSH MASTERS and FLUSH SLAVES, it will > have the same effect with new versions of MySQL too. > > Karam > --- Gleb Paharenko <[EMAIL PROTECTED]> wrote: > >> Hello. >> >> > Also, from which version of MySQL LOCAL a

Re: FLUSH syntax query

2005-01-06 Thread Karam Chand
So if I use FLUSH MASTERS and FLUSH SLAVES, it will have the same effect with new versions of MySQL too. Karam --- Gleb Paharenko <[EMAIL PROTECTED]> wrote: > Hello. > > > Also, from which version of MySQL LOCAL and > > NO_WRITE_TO_BINLOG options supported? > 4.1.1 > > RESET MASTER and RESET SL

Re: FLUSH syntax query

2005-01-06 Thread Gleb Paharenko
Hello. > Also, from which version of MySQL LOCAL and > NO_WRITE_TO_BINLOG options supported? 4.1.1 RESET MASTER and RESET SLAVE were named FLUSH MASTER and FLUSH SLAVES before MySQL 3.23.26. Karam Chand <[EMAIL PROTECTED]> wrote: > Hello, > > From the MySQL docs: > > http://dev.

FLUSH syntax query

2005-01-05 Thread Karam Chand
Hello, >From the MySQL docs: http://dev.mysql.com/doc/mysql/en/FLUSH.html What does FLUSH MASTER and FLUSH SLAVES does? Its not documented? Also, from which version of MySQL LOCAL and NO_WRITE_TO_BINLOG options supported? Regards, Karam __ Do Yo

Re: Syntax Query Help DECRYPT

2003-09-19 Thread Paul DuBois
At 1:08 PM -0600 9/19/03, Stout, Jeff wrote: I have added data into MySQL server 4.0.15 INSERT INTO userdata (userid, password) VALUES ('user', AES_ENCRYPT ("user","password") I'm having trouble doing the decrypt SELECT userid, password (AES_DECRYPT) FROM userdat

Syntax Query Help DECRYPT

2003-09-19 Thread Stout, Jeff
I have added data into MySQL server 4.0.15 INSERT INTO userdata (userid, password) VALUES ('user', AES_ENCRYPT ("user","password") I'm having trouble doing the decrypt SELECT userid, password (AES_DECRYPT) FROM userdata blah blah blah S

RE: Syntax query

2002-05-13 Thread Jay Blanchard
[snip] +-++-+ | artist | area | magic | +-++-+ | Joe Bloggs | AZ*IN*TX | childrens | +-++-+ | Fred Smith | All| close-up| +-++-

Syntax query

2002-05-13 Thread Graham Nichols
Hi, I have a directory of professional magicians, consisting of a MySQL table like this: +-++-+ | artist | area| magic | +-++-+ | Joe Bloggs | AZ*IN*TX | childrens | +-

Re: [QUERY] Problem with Syntax/Query. Need Help Please.

2001-11-17 Thread Tore Van Grembergen
9:02 AM Subject: [QUERY] Problem with Syntax/Query. Need Help Please. > G'Day All. > > I'm trying to do the following in a query, in mySQL. > All my previous years of SQL has been on MS-SQL, and i'm having some little > problems with tricky sql statements. > > **

[QUERY] Problem with Syntax/Query. Need Help Please.

2001-11-16 Thread Pure Krome
G'Day All. I'm trying to do the following in a query, in mySQL. All my previous years of SQL has been on MS-SQL, and i'm having some little problems with tricky sql statements. * i'm trying to insert a new record if the name doesn't exist in the table. If i insert, return ID, else return 0 *