forked from aktheultimate/Social_Media
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathTrigger_cmd.txt
More file actions
60 lines (55 loc) · 4.57 KB
/
Trigger_cmd.txt
File metadata and controls
60 lines (55 loc) · 4.57 KB
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
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
mysql> DELIMITER //
mysql> Create Trigger before_ins_contactNo
BEFORE INSERT ON userstable FOR EACH ROW
BEGIN
IF NEW.contactNo < 0 THEN SET NEW.contactNo = NULL;
END IF;
END //
mysql> use social
Database changed
mysql> select * from userstable;
+-----------------+----------+---------------------------+-----------+---------+----------+------------+
| username | password | email | firstName | midName | LastName | contactNo |
+-----------------+----------+---------------------------+-----------+---------+----------+------------+
| Ajay | Ajay | ajay@gmail.com | Ajay | NULL | NULL | NULL |
| Akash | Akash | akash@gmail.com | Akash | NULL | NULL | NULL |
| Alex | Alex | Alex@gmail.com | Alex | NULL | NULL | NULL |
| Amrut | Amrut | amrut@gmail.com | Amrut | NULL | NULL | NULL |
| Batman | Manbat | akash.21911057@viit.ac.in | firstName | NULL | NULL | 3432 |
| CaptainLambda | dfd | asd@gmail.com | QWE | QWE | NULL | 1231232312 |
| CaptainLambdad | ddd | hehe@gmail.com | QWE | QWE | NULL | 1231232312 |
| Hello | Hello | ak.gamingside@gmail.com | Herobrine | NULL | NULL | NULL |
| Soniya | Soniya | soniya@gmail.com | Soniya | NULL | NULL | NULL |
| wealthfligdht | | wewe@gmail.com | wewe | | NULL | 1111111 |
| wealthflight.in | | aaa@gmail.com | asdasd | | NULL | 1231231931 |
| whan | whan | whan@gmail.com | HHIHIHI | | NULL | 1231234444 |
| Yl | Password | aksgh@gmail.com | YO | NULL | NULL | NULL |
| Yolo | Password | aksh@gmail.com | YO | NULL | NULL | NULL |
| Yyl | Password | aksgsh@gmail.com | YfO | NULL | NULL | NULL |
+-----------------+----------+---------------------------+-----------+---------+----------+------------+
15 rows in set (0.00 sec)
mysql> INSERT INTO userstable (username, password, email, firstName, contactNo) VALUES ('Ynnel', 'RDR2', 'R2D2@gmail.com', 'LENNY', -1);
Query OK, 1 row affected (0.01 sec)
mysql> select * from userstable;
+-----------------+----------+---------------------------+-----------+---------+----------+------------+
| username | password | email | firstName | midName | LastName | contactNo |
+-----------------+----------+---------------------------+-----------+---------+----------+------------+
| Ajay | Ajay | ajay@gmail.com | Ajay | NULL | NULL | NULL |
| Akash | Akash | akash@gmail.com | Akash | NULL | NULL | NULL |
| Alex | Alex | Alex@gmail.com | Alex | NULL | NULL | NULL |
| Amrut | Amrut | amrut@gmail.com | Amrut | NULL | NULL | NULL |
| Batman | Manbat | akash.21911057@viit.ac.in | firstName | NULL | NULL | 3432 |
| CaptainLambda | dfd | asd@gmail.com | QWE | QWE | NULL | 1231232312 |
| CaptainLambdad | ddd | hehe@gmail.com | QWE | QWE | NULL | 1231232312 |
| Hello | Hello | ak.gamingside@gmail.com | Herobrine | NULL | NULL | NULL |
| Soniya | Soniya | soniya@gmail.com | Soniya | NULL | NULL | NULL |
| wealthfligdht | | wewe@gmail.com | wewe | | NULL | 1111111 |
| wealthflight.in | | aaa@gmail.com | asdasd | | NULL | 1231231931 |
| whan | whan | whan@gmail.com | HHIHIHI | | NULL | 1231234444 |
| Yl | Password | aksgh@gmail.com | YO | NULL | NULL | NULL |
| Ynnel | RDR2 | R2D2@gmail.com | LENNY | NULL | NULL | NULL |
| Yolo | Password | aksh@gmail.com | YO | NULL | NULL | NULL |
| Yyl | Password | aksgsh@gmail.com | YfO | NULL | NULL | NULL |
+-----------------+----------+---------------------------+-----------+---------+----------+------------+
16 rows in set (0.00 sec)
mysql>