Guest User

Untitled

a guest
Jan 16th, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. $nnomer = "lux";
  2. const SQL_INSERT_MAIN = '
  3. INSERT INTO main (namenomer, datestart, dateend, color) values (?, ?, ?, ?)
  4. ';
  5. $addmt = $pdo->prepare(SQL_INSERT_MAIN);
  6. $add = $addmt->execute([$nnomer, $datestart, $dateend, $color]);
  7.  
  8. select case when m.id_color = c.max_id then 1 else m.id_color + 1 end case
  9. from main m
  10. left join (select max(id) as max_id from color) c on 1 = 1
  11. order by id desc limit 1
  12.  
  13. CREATE TRIGGER tr_main_bi BEFORE INSERT ON main
  14. FOR EACH ROW
  15. BEGIN
  16. DECLARE CONTINUE HANDLER FOR NOT FOUND
  17. SET NEW.`color` = col1;
  18.  
  19. SELECT
  20. IF(mn.`color` = col6, col1, mn.`color` + 1)
  21. FROM
  22. main mn
  23. WHERE
  24. mn.`namenomer` = NEW.`namenomer` AND
  25. mn.`id` = (SELECT MAX(mx.`id`) FROM main mx WHERE mx.`namenomer` = NEW.`namenomer`)
  26. INTO
  27. NEW.`color`;
  28. END;
  29.  
  30. INSERT INTO main (namenomer, datestart, dateend) values (?, ?, ?)
Add Comment
Please, Sign In to add comment