Quote:
Originally Posted by DanCanDo
That's kewl how yu did that. I use MySQL along with Navicat, but something I've done in
the past with navicat is an option to simply right click on a table or table row and dump it
to an sql file, then source it back in to another db. I wonder if I can pull that off with the
tak db.
|
this isn't too old, but maybe on the internet it is...
if you can export as a text csv or text anythign with a specific delimiter, it's very easy to use a spreadshet program to alter format. if the columns are in a different order or whatever, it's easy to adjust it.
if anything has a consistent chagne you can even use a column on another worksheet to make the change with a formula and a few clicks. i guess same as a sql command after the fact, too, but maybe in some situations useful.