[thelist] MySQL Tables for weblog

rudy r937 at interlog.com
Sat Mar 16 12:15:01 CST 2002


> ... trying to figure out how to undo what I've done on a couple of sites

hey, don't fret it, don't fix them until they're broken

> What would happen if you were to move a table from one db to another,
> for example, and you dropped the data into the new table with the
> previously auto-numbered column set to say a basic int column...

so far so good

> ... then change it afterward to an auto-increment again?

you can't always do that (sequences in oracle being one exception, since
they aren't "automatic")

a suitable permalink would be a datetime string like 20020316131105 -- you
wouldn't even need a separate column

but don't change your design until you are forced to


rudy




More information about the thelist mailing list