Akina
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
mysql> CREATE TABLE test (id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, dt DATE);
Query OK, 0 rows affected (0.41 sec)
mysql> DELIMITER @@;
mysql> CREATE TRIGGER tr_bi
-> BEFORE INSERT ON test
-> FOR EACH ROW
-> BEGIN
-> IF new.dt < '2001-01-01' OR new.dt >= '2020-01-01' THEN
-> SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Wrong date entered.';
-> END IF;
-> END;
-> @@;
Query OK, 0 rows affected (0.11 sec)
mysql> DELIMITER ;
mysql> INSERT INTO test (dt) VALUES ('2010-01-01');
Query OK, 1 row affected (0.05 sec)
mysql> INSERT INTO test (dt) VALUES ('2030-01-01');
ERROR 1644 (45000): Wrong date entered.
mysql> INSERT INTO test (dt) VALUES ('2000-01-01');
ERROR 1644 (45000): Wrong date entered.
mysql> SELECT * FROM test;
+----+------------+
| id | dt |
+----+------------+
| 1 | 2010-01-01 |
+----+------------+
1 row in set (0.00 sec)
mysql>
Спасибо огромное. Почти отлично ((
При попытке создать тригер валится ошибка ((
10:44:54 CREATE TRIGGER tr_bi BEFORE INSERT ON test FOR EACH ROW BEGIN IF new.dt < '2001-01-01' OR new.dt >= '2020-01-01' THEN SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Wrong date entered.'; END IF; END; Error Code: 1054. Unknown column 'dt' in 'NEW' 0.000 sec
