MySQL: Add sequence column based on another field

by

Create a trigger:

CREATE TRIGGER trg_mytable_bi
BEFORE INSERT ON mytable
FOR EACH ROW
BEGIN
      DECLARE nseq INT;
      SELECT  COALESCE(MAX(seq), 0) + 1
      INTO    nseq
      FROM    mytable
      WHERE   account = NEW.account;
      SET NEW.seq = nseq;
END;

More Related Contents:

  1. Php mysql tabs don’t output [closed]
  2. Update Mysql except when field not null
  3. How can I prevent SQL injection in PHP?
  4. UTF-8 all the way through
  5. SQL injection that gets around mysql_real_escape_string()
  6. jQuery Validate remote method usage to check if username already exists
  7. PDO get the last ID inserted
  8. Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0
  9. Warning: mysqli_connect(): (HY000/2002): No such file or directory
  10. How do I import a .sql file in mysql database using PHP?
  11. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  12. mysql query result in php variable
  13. mysql_real_escape_string is undefined
  14. Unknown database error in PHP but it exists in PHPMyAdmin
  15. Can I blindly replace all mysql_ functions with mysqli_?
  16. How do detect that transaction has already been started?
  17. return multiple response data in one response
  18. CakePHP Database connection “Mysql” is missing, or could not be created
  19. How to get primary key of table?
  20. MySQL Alter Table Add Field Before or After a field already present
  21. mysql error ‘TYPE=MyISAM’
  22. Storing datetime as UTC in PHP/MySQL
  23. How can I do a migration in laravel 5.5?
  24. Best way to store IP in database?
  25. Which is fastest in PHP- MySQL or MySQLi?
  26. SQL Query with binary data (PHP and MySQL)
  27. How to get last inserted id from table MySQL [duplicate]
  28. How can I list data in sections by an ID, with a while loop in PHP? [closed]
  29. Save array in mysql database
  30. find in set in laravel ? example

Leave a Comment