phpMyAdmin trigger gui checking age
up vote
1
down vote
favorite
I want to check whether age is greater than 18 years before inserting the record to 'employees' table. I'm using phpMyAdmin gui trigger tool. But it gives following error when I type this script in Definition section.
BEGIN
IF (DATEDIFF(CURRENT_DATE(),NEW.birth_date) < 6570) THEN
RAISEERROR('Age is less than 18 years!',16,1)
ROLLBACK
END IF
END
Please help me to resolve this.
mysql triggers phpmyadmin database-trigger raiserror
edited Nov 22 at 9:15
Madhur Bhaiya
18.7k62236
asked Nov 22 at 3:57
Binod Madhubashitha
184
add a comment |
up vote
1
down vote
favorite
I want to check whether age is greater than 18 years before inserting the record to 'employees' table. I'm using phpMyAdmin gui trigger tool. But it gives following error when I type this script in Definition section.
BEGIN
IF (DATEDIFF(CURRENT_DATE(),NEW.birth_date) < 6570) THEN
RAISEERROR('Age is less than 18 years!',16,1)
ROLLBACK
END IF
END
Please help me to resolve this.
mysql triggers phpmyadmin database-trigger raiserror
edited Nov 22 at 9:15
Madhur Bhaiya
18.7k62236
asked Nov 22 at 3:57
Binod Madhubashitha
184
RAISEERRORandROLLBACKare a TSQL (Microsoft SQL Server) thing. Are you sure that you are using MySQL ?
– Madhur Bhaiya
Nov 22 at 5:20
what can I use instead of ROLEBACK and RAISERROR in mySQL? However without those lines it gives the error
– Binod Madhubashitha
Nov 22 at 9:05
Because these are not Standard SQL thing. Every RDBMS has its own syntax for Triggers.
– Madhur Bhaiya
Nov 22 at 9:06
Can you suggest me the correct mySQL code for above purpose?
– Binod Madhubashitha
Nov 22 at 9:07
add a comment |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
I want to check whether age is greater than 18 years before inserting the record to 'employees' table. I'm using phpMyAdmin gui trigger tool. But it gives following error when I type this script in Definition section.
BEGIN
IF (DATEDIFF(CURRENT_DATE(),NEW.birth_date) < 6570) THEN
RAISEERROR('Age is less than 18 years!',16,1)
ROLLBACK
END IF
END
Please help me to resolve this.
mysql triggers phpmyadmin database-trigger raiserror
edited Nov 22 at 9:15
Madhur Bhaiya
18.7k62236
asked Nov 22 at 3:57
Binod Madhubashitha
184
I want to check whether age is greater than 18 years before inserting the record to 'employees' table. I'm using phpMyAdmin gui trigger tool. But it gives following error when I type this script in Definition section.
BEGIN
IF (DATEDIFF(CURRENT_DATE(),NEW.birth_date) < 6570) THEN
RAISEERROR('Age is less than 18 years!',16,1)
ROLLBACK
END IF
END
Please help me to resolve this.
mysql triggers phpmyadmin database-trigger raiserror
mysql triggers phpmyadmin database-trigger raiserror
edited Nov 22 at 9:15
Madhur Bhaiya
18.7k62236
asked Nov 22 at 3:57
Binod Madhubashitha
184
edited Nov 22 at 9:15
Madhur Bhaiya
18.7k62236
asked Nov 22 at 3:57
Binod Madhubashitha
184
edited Nov 22 at 9:15
Madhur Bhaiya
18.7k62236
edited Nov 22 at 9:15
Madhur Bhaiya
18.7k62236
edited Nov 22 at 9:15
Madhur Bhaiya
18.7k62236
18.7k62236
asked Nov 22 at 3:57
Binod Madhubashitha
184
asked Nov 22 at 3:57
Binod Madhubashitha
184
asked Nov 22 at 3:57
Binod Madhubashitha
184
184
RAISEERRORandROLLBACKare a TSQL (Microsoft SQL Server) thing. Are you sure that you are using MySQL ?
– Madhur Bhaiya
Nov 22 at 5:20
what can I use instead of ROLEBACK and RAISERROR in mySQL? However without those lines it gives the error
– Binod Madhubashitha
Nov 22 at 9:05
Because these are not Standard SQL thing. Every RDBMS has its own syntax for Triggers.
– Madhur Bhaiya
Nov 22 at 9:06
Can you suggest me the correct mySQL code for above purpose?
– Binod Madhubashitha
Nov 22 at 9:07
add a comment |
RAISEERRORandROLLBACKare a TSQL (Microsoft SQL Server) thing. Are you sure that you are using MySQL ?
– Madhur Bhaiya
Nov 22 at 5:20
what can I use instead of ROLEBACK and RAISERROR in mySQL? However without those lines it gives the error
– Binod Madhubashitha
Nov 22 at 9:05
Because these are not Standard SQL thing. Every RDBMS has its own syntax for Triggers.
– Madhur Bhaiya
Nov 22 at 9:06
Can you suggest me the correct mySQL code for above purpose?
– Binod Madhubashitha
Nov 22 at 9:07
RAISEERROR and ROLLBACK are a TSQL (Microsoft SQL Server) thing. Are you sure that you are using MySQL ?– Madhur Bhaiya
Nov 22 at 5:20
RAISEERROR and ROLLBACK are a TSQL (Microsoft SQL Server) thing. Are you sure that you are using MySQL ?– Madhur Bhaiya
Nov 22 at 5:20
what can I use instead of ROLEBACK and RAISERROR in mySQL? However without those lines it gives the error
– Binod Madhubashitha
Nov 22 at 9:05
what can I use instead of ROLEBACK and RAISERROR in mySQL? However without those lines it gives the error
– Binod Madhubashitha
Nov 22 at 9:05
Because these are not Standard SQL thing. Every RDBMS has its own syntax for Triggers.
– Madhur Bhaiya
Nov 22 at 9:06
Because these are not Standard SQL thing. Every RDBMS has its own syntax for Triggers.
– Madhur Bhaiya
Nov 22 at 9:06
Can you suggest me the correct mySQL code for above purpose?
– Binod Madhubashitha
Nov 22 at 9:07
Can you suggest me the correct mySQL code for above purpose?
– Binod Madhubashitha
Nov 22 at 9:07
add a comment |
1 Answer
1
active
oldest
votes
up vote
1
down vote
accepted
RAISEERROR and ROLLBACK are used in TSQL (Microsoft SQL Server) syntax.
In the case of MySQL, we use SIGNAL .. SET MESSAGE_TEXT .. to throw an exception inside the Trigger:
BEGIN
IF (DATEDIFF(CURRENT_DATE(),NEW.birth_date) < 6570) THEN
-- Throw Exception
SIGNAL SQLSTATE '45000'
SET MESSAGE_TEXT = 'Age is less than 18 years!';
END IF; -- A semicolon (delimiter) is missing here
END
To signal a generic SQLSTATE value, use '45000', which means
“unhandled user-defined exception.”
The error values that are accessible after SIGNAL executes are the
SQLSTATE value raised by the SIGNAL statement and the MESSAGE_TEXT and
MYSQL_ERRNO items.
answered Nov 22 at 9:12
Madhur Bhaiya
18.7k62236
1
Thank you very much!
– Binod Madhubashitha
Nov 22 at 9:32
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
1
down vote
accepted
RAISEERROR and ROLLBACK are used in TSQL (Microsoft SQL Server) syntax.
In the case of MySQL, we use SIGNAL .. SET MESSAGE_TEXT .. to throw an exception inside the Trigger:
BEGIN
IF (DATEDIFF(CURRENT_DATE(),NEW.birth_date) < 6570) THEN
-- Throw Exception
SIGNAL SQLSTATE '45000'
SET MESSAGE_TEXT = 'Age is less than 18 years!';
END IF; -- A semicolon (delimiter) is missing here
END
To signal a generic SQLSTATE value, use '45000', which means
“unhandled user-defined exception.”
The error values that are accessible after SIGNAL executes are the
SQLSTATE value raised by the SIGNAL statement and the MESSAGE_TEXT and
MYSQL_ERRNO items.
answered Nov 22 at 9:12
Madhur Bhaiya
18.7k62236
1
Thank you very much!
– Binod Madhubashitha
Nov 22 at 9:32
add a comment |
up vote
1
down vote
accepted
RAISEERROR and ROLLBACK are used in TSQL (Microsoft SQL Server) syntax.
In the case of MySQL, we use SIGNAL .. SET MESSAGE_TEXT .. to throw an exception inside the Trigger:
BEGIN
IF (DATEDIFF(CURRENT_DATE(),NEW.birth_date) < 6570) THEN
-- Throw Exception
SIGNAL SQLSTATE '45000'
SET MESSAGE_TEXT = 'Age is less than 18 years!';
END IF; -- A semicolon (delimiter) is missing here
END
To signal a generic SQLSTATE value, use '45000', which means
“unhandled user-defined exception.”
The error values that are accessible after SIGNAL executes are the
SQLSTATE value raised by the SIGNAL statement and the MESSAGE_TEXT and
MYSQL_ERRNO items.
answered Nov 22 at 9:12
Madhur Bhaiya
18.7k62236
1
Thank you very much!
– Binod Madhubashitha
Nov 22 at 9:32
add a comment |
up vote
1
down vote
accepted
up vote
1
down vote
accepted
RAISEERROR and ROLLBACK are used in TSQL (Microsoft SQL Server) syntax.
In the case of MySQL, we use SIGNAL .. SET MESSAGE_TEXT .. to throw an exception inside the Trigger:
BEGIN
IF (DATEDIFF(CURRENT_DATE(),NEW.birth_date) < 6570) THEN
-- Throw Exception
SIGNAL SQLSTATE '45000'
SET MESSAGE_TEXT = 'Age is less than 18 years!';
END IF; -- A semicolon (delimiter) is missing here
END
To signal a generic SQLSTATE value, use '45000', which means
“unhandled user-defined exception.”
The error values that are accessible after SIGNAL executes are the
SQLSTATE value raised by the SIGNAL statement and the MESSAGE_TEXT and
MYSQL_ERRNO items.
answered Nov 22 at 9:12
Madhur Bhaiya
18.7k62236
RAISEERROR and ROLLBACK are used in TSQL (Microsoft SQL Server) syntax.
In the case of MySQL, we use SIGNAL .. SET MESSAGE_TEXT .. to throw an exception inside the Trigger:
BEGIN
IF (DATEDIFF(CURRENT_DATE(),NEW.birth_date) < 6570) THEN
-- Throw Exception
SIGNAL SQLSTATE '45000'
SET MESSAGE_TEXT = 'Age is less than 18 years!';
END IF; -- A semicolon (delimiter) is missing here
END
To signal a generic SQLSTATE value, use '45000', which means
“unhandled user-defined exception.”
The error values that are accessible after SIGNAL executes are the
SQLSTATE value raised by the SIGNAL statement and the MESSAGE_TEXT and
MYSQL_ERRNO items.
answered Nov 22 at 9:12
Madhur Bhaiya
18.7k62236
answered Nov 22 at 9:12
Madhur Bhaiya
18.7k62236
answered Nov 22 at 9:12
Madhur Bhaiya
18.7k62236
answered Nov 22 at 9:12
Madhur Bhaiya
18.7k62236
18.7k62236
1
Thank you very much!
– Binod Madhubashitha
Nov 22 at 9:32
add a comment |
1
Thank you very much!
– Binod Madhubashitha
Nov 22 at 9:32
1
1
Thank you very much!
– Binod Madhubashitha
Nov 22 at 9:32
Thank you very much!
– Binod Madhubashitha
Nov 22 at 9:32
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53423662%2fphpmyadmin-trigger-gui-checking-age%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
RAISEERRORandROLLBACKare a TSQL (Microsoft SQL Server) thing. Are you sure that you are using MySQL ?– Madhur Bhaiya
Nov 22 at 5:20
what can I use instead of ROLEBACK and RAISERROR in mySQL? However without those lines it gives the error
– Binod Madhubashitha
Nov 22 at 9:05
Because these are not Standard SQL thing. Every RDBMS has its own syntax for Triggers.
– Madhur Bhaiya
Nov 22 at 9:06
Can you suggest me the correct mySQL code for above purpose?
– Binod Madhubashitha
Nov 22 at 9:07