-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Mark Rages wrote:
> On Thu, Jun 05, 2003 at 09:06:43PM -0400, O'K Web Design wrote: > >>Hi >> >> You are not defining num so you are adding 1 to 0 to get 1 and you >>already have that record. Sounds like you need an autoincrement field. >>Mike > > > I don't need an autoincrement field. In my actual application, the num > is a sequence index that determines the order of some rows. When I want > to reorder the rows, I need to change a series of numbers in this way. > > In my example I'm trying to take the table from one valid state to > another valid state... if this syntax is wrong, how can I do it? > How about UPDATE ... ORDER BY num DESC ??? Do the opposite, if you're moving your rows 'down'. See http://www.mysql.com/doc/en/UPDATE.html -Mark - -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, SW Dev. Manager - J2EE/Windows /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA <___/ www.mysql.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+3/IwtvXNTca6JD8RAj5cAJ9fDPfy9WT07D/xltk9ooxUke4CdACeLuU6 EJG1xLn6UYl6ZxGjVqKqUk8= =DbtX -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
