rd Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Daniel Crompton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, 01 June, 2003 14:00
Subject: Re: Advice on improving our current method
> SET @rank:=5;
>
> UPDATE music SET
er Make Chart # an Index
> Martin
> - Original Message -
> From: "Don Read" <[EMAIL PROTECTED]>
> To: "Daniel Crompton" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Sunday, June 01, 2003 1:54 PM
> Subject: RE: Advice on im
let the DB manage the sequencing before and after Make Chart # an Index
Martin
- Original Message -
From: "Don Read" <[EMAIL PROTECTED]>
To: "Daniel Crompton" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, June 01, 2003 1:54 PM
Subject: RE:
OK, here's a lengthy answer:
I don't use MySQLCC, so I'm assuming that it has a way that you can
enter and run SQL statements.
Say our top 10 songs are:
mysql [test]> SELECT * FROM musicchart ORDER BY chartnumber LIMIT 10;
+-+--++
> SET @rank:=5;
>
> UPDATE music SET chart=0 WHERE [EMAIL PROTECTED];
> UPDATE music SET chart=chart+1 WHERE chart<@rank;
>
Thanks Don
Unfortunately though i think we need to be able to make the changes in
something we can see which is why we are using mysqlcc.
With mysqlcc any of us can simply
On 01-Jun-2003 Daniel Crompton wrote:
>
> If for example we move song number 5 up to number 1, we then have to
> manually change the
> ' Chart Number' of all the ones below it, i.e. changing the old number
> 1 to a number 2,
> number 2 to a number 3, number 4 to a number 5 etc.
>
> Ideally
Hi,
I'm not to familiar with MySQL, but as far as I can seem, you might want to
look at programming.
I.e a program in C++ or Perl, or Visual Basic.
Anthony
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can anyone advise how we should improve this method of updating our database.
We have a Music chart it is a table with 3 columns
Chart Number (ie, 1,2,3,4,5,6,7,8,9,10..)
Artist (Artists Name)
Title (Title of Song)
Each week we login using mysql control center to make changes to the chart pos
