Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $nnomer = "lux";
- const SQL_INSERT_MAIN = '
- INSERT INTO main (namenomer, datestart, dateend, color) values (?, ?, ?, ?)
- ';
- $addmt = $pdo->prepare(SQL_INSERT_MAIN);
- $add = $addmt->execute([$nnomer, $datestart, $dateend, $color]);
- select case when m.id_color = c.max_id then 1 else m.id_color + 1 end case
- from main m
- left join (select max(id) as max_id from color) c on 1 = 1
- order by id desc limit 1
- CREATE TRIGGER tr_main_bi BEFORE INSERT ON main
- FOR EACH ROW
- BEGIN
- DECLARE CONTINUE HANDLER FOR NOT FOUND
- SET NEW.`color` = col1;
- SELECT
- IF(mn.`color` = col6, col1, mn.`color` + 1)
- FROM
- main mn
- WHERE
- mn.`namenomer` = NEW.`namenomer` AND
- mn.`id` = (SELECT MAX(mx.`id`) FROM main mx WHERE mx.`namenomer` = NEW.`namenomer`)
- INTO
- NEW.`color`;
- END;
- INSERT INTO main (namenomer, datestart, dateend) values (?, ?, ?)
Add Comment
Please, Sign In to add comment