MySQL: set field default value to other column

by

As documented under Data Type Default Values:

The DEFAULT value clause in a data type specification indicates a default value for a column. With one exception, the default value must be a constant; it cannot be a function or an expression. This means, for example, that you cannot set the default for a date column to be the value of a function such as NOW() or CURRENT_DATE. The exception is that you can specify CURRENT_TIMESTAMP as the default for a TIMESTAMP column. See Section 11.3.5, “Automatic Initialization and Updating for TIMESTAMP”.

Instead, you can define an insertion trigger:

CREATE TRIGGER foo BEFORE INSERT ON TSM_TRANSACTION_TBL FOR EACH ROW
  IF NEW.REMAINING IS NULL THEN
    SET NEW.REMAINING := NEW.MAX_VALUE - NEW.BOOKED_UNITS;
  END IF;;

More Related Contents:

  1. How to change MySQL data directory?
  2. CURRENT_DATE/CURDATE() not working as default DATE value
  3. Why can’t a text column have a default value in MySQL?
  4. Return a default value if single row is not found
  5. How do I specify unique constraint for multiple columns in MySQL?
  6. Select all columns except one in MySQL?
  7. MYSQL OR vs IN performance
  8. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  9. MySQL Conditional Insert
  10. grant remote access of MySQL database from any IP address
  11. Should MySQL have its timezone set to UTC?
  12. MySQL JOIN ON vs USING?
  13. SQL – Update multiple records in one query
  14. How to store IPv6-compatible address in a relational database
  15. MySQL: View with Subquery in the FROM Clause Limitation
  16. MySql export schema without data
  17. Scaling solutions for MySQL (Replication, Clustering)
  18. MySQL show status – active or total connections?
  19. mysql check if numbers are in a comma separated list
  20. mySQL DataSource on Visual Studio 2012
  21. MySQL update case help
  22. limiting the rows to where the sum a column equals a certain value in MySQL
  23. Dump a mysql database to a plaintext (CSV) backup from the command line
  24. Mysql select distinct
  25. How would I use ON DUPLICATE KEY UPDATE in my CodeIgniter model?
  26. GROUP_CONCAT equivalent in Django
  27. Transpose rows into columns in MySQL
  28. Case Expression vs Case Statement
  29. Can’t connect to RDS instance from EC2 instance
  30. “General error: 1005 Can’t create table” Using Laravel Schema Build and Foreign Keys

Leave a Comment