Re: Partitioning on a Substring of Varchar Column in Mysql

2012-09-22 Thread Adarsh Sharma
olve this issue. Thanks for your link also , it is very helpfull. Thanks > See tips in > http://mysql.rjweb.org/doc.php/ricksrots > > > > -Original Message----- > > From: Adarsh Sharma [mailto:eddy.ada...@gmail.com] > > Sent: Friday, September 21, 2012 5:09 AM > > To: my

RE: Partitioning on a Substring of Varchar Column in Mysql

2012-09-21 Thread Rick James
PARTITION, yet they have not determined that there will be any benefit. See tips in http://mysql.rjweb.org/doc.php/ricksrots > -Original Message- > From: Adarsh Sharma [mailto:eddy.ada...@gmail.com] > Sent: Friday, September 21, 2012 5:09 AM > To: mysql@lists.mysql.com > Sub

Re: Partitioning on a Substring of Varchar Column in Mysql

2012-09-21 Thread Adarsh Sharma
Just update the string needed function substring(id,9,6). On Fri, Sep 21, 2012 at 5:18 PM, Adarsh Sharma wrote: > Hi all, > > I created a partition on a timstamp column ( dt_dtamp ) in mysql-5.1.58 > testing table.But as all of us know that partitioned column need to be > primary key. > I have al

Partitioning on a Substring of Varchar Column in Mysql

2012-09-21 Thread Adarsh Sharma
Hi all, I created a partition on a timstamp column ( dt_dtamp ) in mysql-5.1.58 testing table.But as all of us know that partitioned column need to be primary key. I have already id column as primary key but my application cann't afford primary key ('id','dt_stamp') in a table. I thought & tried