Re: Designing Table for Both Global and Local Indices

Hi, Try to make a table for each company with only one integer field than insert a record and use the id to populate the other table. You can also delete periodically records from there companies tables. Santino At 21:48 -0500 23-11-2007, David T. Ashley wrote: Hi, I am developing a large dat

Re: Unusual sort

On 24-nov-2007, at 0:29, Jim wrote: I have a table containing web site host names, most of them having both a "name.com" and "www.name.com" version, that I'd like sorted in the following manner: axxx.com www.axxx.com bxxx.com www.bxxx.com wxxx.com www.wxxx.com zxxx.com www.zxxx.com Any wa

RE: IMAGES/PICTURES-MYSQL

Hi! I have seen in this page http://www.blobstreaming.org/ but i think that it´s quite difficult. I want to put only the url of the image, and as you said the pictures o images might be in the server folder, but what is the folder? Thanks. -- View this message in context: http://www.nabble.com

RE: Unusual sort

Hi Jim it seems that you cannot create an index with a function soyou will need to establish a separate 12 character column which has all of the URL entries insertedalphabetically in ascending order (fully padded with www. prefix)backup your DBALTER TABLE table ADD TwelveCharacterURL CHAR(12)

RE: Unusual sort

Hi, One thought, it might a good idea to make a trigger/procedure that inserts the seprate index field, so you can forget about it from here on. -Original Message- From: Martin Gainty [mailto:[EMAIL PROTECTED] Sent: Saturday, November 24, 2007 11:18 AM To: Jim; mysql@lists.mysql.com Su

Default result

Is there anything I am missing that will allow me to return a default row if the sought after row is not found? For example : Select * from table1 where column1=1234 If 1234 is not found, row1 would be returned instead. If 1234 is found then that is the row returned. Thanks Steffan -

Re: Default result

In the last episode (Nov 24), Steffan A. Cline said: > Is there anything I am missing that will allow me to return a default row if > the sought after row is not found? > > For example : > > Select * from table1 where column1=1234 > > If 1234 is not found, row1 would be returned instead. > If 12

Incrementing a "Private" Integer Space

I have a table with two integer fields (call them p and q). When I insert a record with a known p, I want to choose q to be one larger than the largest q with that p. What is the best and most efficient way to do this? For example, let's say the table contains (p,q): 1,1 1,2 1,3 2,1 2,2 2,3 2.4

Re: Incrementing a "Private" Integer Space

David T. Ashley wrote: I have a table with two integer fields (call them p and q). When I insert a record with a known p, I want to choose q to be one larger than the largest q with that p. What is the best and most efficient way to do this? For example, let's say the table contains (p,q):