I have two databases, and I need to move data from one to another. The catch is they have a table with different set of columns. Here is how I need to rename columns in migration:
NULL -> ID (should be generated as I add records normally) NULL -> category_id (should be fixed, e.g. 3) date_art -> created_at title_art -> title short_art -> promo full_art -> content
Is it possible to accomplish by a single query?