How do I use Knex.js for database migrations in Node.js?

How do I use Knex.js for database migrations in Node.js?

To use Knex.js for migrations, first install Knex and a database driver. Then, initialize Knex with your database configuration.

What commands do I need to run to create a migration?

You can create a migration using the command: npx knex migrate:make migration_name. This will create a new migration file.

How do I run the migrations after creating them?

Run the migrations with the command: npx knex migrate:latest. This will apply all pending migrations to your database.

Can I roll back a migration if something goes wrong?

Yes, you can roll back the last batch of migrations using: npx knex migrate:rollback. This will undo the last migration.