innodb_autoinc_lock_mode and replication mode

I couldn't find much information on innodb_autoinc_lock_mode and implications on mixed mode replication. Does the same caution for innodb_autoinc_lock_mode=2 and statement-based replication apply to mixed mode replication? Kyong -- MySQL General Mailing List For list archives: http://lists.mysql

RE: prime number table

The data isn't in the .frm; That only holds the structure of the table. Your data is in the .MYD file of the same name, and indexes are in the .MYI file. -Original Message- From: Elim PDT [mailto:e...@pdtnetworks.net] Sent: Friday, September 17, 2010 11:29 AM To: mysql@lists.mysql.com S

RE: Update record count

>-Original Message- >From: Shawn Green (MySQL) [mailto:shawn.l.gr...@oracle.com] >Sent: Thursday, September 16, 2010 9:51 PM >To: Jerry Schwartz >Cc: mysql@lists.mysql.com >Subject: Re: Update record count > >On 9/16/2010 5:12 PM, Jerry Schwartz wrote: >> I should be able to figure this out

prime number table

I got a file of the list of the 1st 1270607 prime numbers (the 1270607th prime is 1999, beat the $227 book at http://www.amazon.com/prime-numbers-Carnegie-institution-Washington/dp/B0006AH1S8). the file is an output of a python script. the file size is about 12Mb. Then I created a simeple

Re: Add & Arrange New Column

alter table "mytable" add id int not null primary key auto_increment first; I hope it can help you. -- João Cândido de Souza Neto "Carlos Mennens" escreveu na mensagem news:aanlktikfc89rhercrg5pr9yxfv8semvdv4kp9r67n...@mail.gmail.com... >I have an existing table with a few columns I created

Add & Arrange New Column

I have an existing table with a few columns I created a few months ago. Sadly I left out the column I would like to use for my Primary Key and wanted to know what is the best way to add a column to an existing table but also I want the column to appear first before any other columns since it's the

Re: SHA1 returns binary value

Use UNHEX(SHA1('abc')) to get the string value On Sep 17, 2010, at 5:38 PM, Tompkins Neil wrote: > Hi > > Why when I run the command (MySQL 5.1) SELECT SHA1('abc'); is it returned as > a binary value and not a string value ? > > Cheers > Neil -- MySQL General Mailing List For list archives: h

Re: Encryption with MYSQL

Simply base64-encode the returned binary string before offering it to your client. On Fri, Sep 17, 2010 at 1:22 PM, Tompkins Neil wrote: > Hi, > > I need to encrypt a string like 'hello world', using a passkey. But I also > need to be able to decrypt the encrypted phrase using the same passkey.

SHA1 returns binary value

Hi Why when I run the command (MySQL 5.1) SELECT SHA1('abc'); is it returned as a binary value and not a string value ? Cheers Neil

Encryption with MYSQL

Hi, I need to encrypt a string like 'hello world', using a passkey. But I also need to be able to decrypt the encrypted phrase using the same passkey. I noticed in MySQL there are functions like AES_ENCRYPT()

Re: Need restart mysql when time changed

This is a correct description of behaviour. Did you have a question ? :-) On Fri, Sep 17, 2010 at 5:52 AM, win.a wrote: > I fond my mysql db os time was not correct so i sync with ntpdate > ,when testing my app which depend on the date was not the current os > time .After restarting Mysql ,the

Re: Update record count

On Fri, Sep 17, 2010 at 3:51 AM, Shawn Green (MySQL) < shawn.l.gr...@oracle.com> wrote: > > So if 10 rows of A match your conditions, 1 row from B match your > conditions, and 10 rows from C match your conditions, then this query > produces 10*1*10 total row combinations. > Umm. It's friday, so I

Re: Capitalize Input via Auto Complete?

On Thu, Sep 16, 2010 at 2:35 PM, Todd Lyons wrote: > On Wed, Sep 15, 2010 at 6:50 AM, Johan De Meersman > wrote: > > > >> I commonly set up a tunnel to the SSH server at the office and then > >> another tunnel from that server to my development rig, so I can run > >> MySQL WB at home on my datab