How do I handle schema migrations

Handling schema migrations effectively is crucial for maintaining the integrity of your database as your application evolves. Below is a basic overview and an example of how to implement schema migrations in MySQL.

<?php // Example of a MySQL schema migration script $mysqli = new mysqli('localhost', 'user', 'password', 'database'); // Check connection if ($mysqli->connect_error) { die("Connection failed: " . $mysqli->connect_error); } // SQL command to alter the table $sql = "ALTER TABLE users ADD COLUMN age INT"; // Execute the query if ($mysqli->query($sql) === TRUE) { echo "Table users updated successfully"; } else { echo "Error updating table: " . $mysqli->error; } $mysqli->close(); ?>

schema migrations MySQL migrations database schema management SQL schema updates

Related Questions

How do I avoid rehashing overhead with std::set in multithreaded code?

How do I find elements with custom comparators with std::set for embedded targets?

How do I erase elements while iterating with std::set for embedded targets?

How do I provide stable iteration order with std::unordered_map for large datasets?

How do I reserve capacity ahead of time with std::unordered_map for large datasets?

How do I erase elements while iterating with std::unordered_map in multithreaded code?

How do I provide stable iteration order with std::map for embedded targets?

How do I provide stable iteration order with std::map in multithreaded code?

How do I avoid rehashing overhead with std::map in performance-sensitive code?

How do I merge two containers efficiently with std::map for embedded targets?