home.social

#databasearchitecture — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #databasearchitecture, aggregated by home.social.

  1. When using a #MySQL database, is it possible in one go, when adding a new column to an existing table, to use one default value for existing columns (initial migration, so to speak), but another for every new row going forward (real default)?

    Scenario: I want to set the value in pre-existing columns to true, but in all subsequent rows to false by default.

    #amCoding #amProgramming #softwareDevelopment #softwareEngineering #databaseEngineering #databaseArchitecture #dbms #SQL