Re: MS SQL to MySQL select

2008-06-15 Thread Martijn Tonies
Hey, > In order for me to achive the goal of migrating a MS SQL based application > to web based php / mysql I need to understand a little bit MS SQL syntax and > MySQL counterpart expression. If is not too much to ask one of you guys > could "translate" this MS SQL select to MySQL? Here's the cha

Re: enable and disable keys

2008-06-15 Thread Krishna Chandra Prajapati
try csplit to break the files into small chunks On Fri, Jun 13, 2008 at 12:21 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > How do i split file during ENABLE KEYS > > > On 6/13/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: >> >> increase bulk_insert_buffer_size and if possible split th

Re: Very slow inserts into InnoDB tables

2008-06-15 Thread Nick Adams
hdparm -Tt /dev/sdX ? Ian Simpson wrote: That's pretty much what I've been doing to get that the drive is running at 100% bandwidth. What I'd like is something that just gives the bandwidth of the device in terms of Mb/s: you can probably work it out using that iostat command, seeing how mu

Re: Function Still Not Working

2008-06-15 Thread Jesse
you not ADD Binary, you need to "remove" BINARY ... ;-) Sorry, I misunderstood. convert the string to latin1 or utf8 o.s.s. "LOWER() (and UPPER()) are ineffective when applied to binary strings (BINARY, VARBINARY, BLOB). To perform lettercase conversion, convert the string to a non-binary s