Re: how to create unique key for long varchar?

2013-11-05 Thread Li Li
.2 if url really exists, don't need insert anything 2.3 generate a special md5 for this url starts with ,maybe 1 and insert it 2.4 commit transaction On Wed, Nov 6, 2013 at 10:56 AM, Li Li wrote: > I prefer your solution in that it's something like Optimistic Loc

Re: how to create unique key for long varchar?

2013-11-05 Thread Li Li
isode (Nov 05), Li Li said: >> I want to create a table with a long varchar column, maybe it's the url. >> according to dns spec, the url's max length is fixed. but I have >> to deal with url having long params such as >> a.html?q=aaa

how to create unique key for long varchar?

2013-11-04 Thread Li Li
hi all I want to create a table with a long varchar column, maybe it's the url. according to dns spec, the url's max length is fixed. but I have to deal with url having long params such as a.html?q=&fl= I want the url is unique whe