[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