MySQL Forums
Forum List  »  Stored Procedures

Unknown database 'new'
Posted by: Jassim Rahma
Date: July 24, 2019 09:32AM

Hi,

I am trying below simple stored procedure but getting this error:

Error Code: 1049. Unknown database 'new'


This is my stored procedure:

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_ping`(IN param_id INT, IN param_address VARCHAR(255), IN param_name VARCHAR(255), IN param_time BIGINT, IN param_ttl INT, IN param_fragment BIT, IN param_reply INT)
BEGIN
INSERT INTO monitor (monitor_guid, host_id, host_address, host_name, roundtrip_time, ttl, dont_fragment, reply_length)
VALUES (UUID(), param_id, param_address, param_name, param_time, param_ttl, param_fragment, param_reply);
END

Options: ReplyQuote


Subject
Views
Written By
Posted
Unknown database 'new'
1090
July 24, 2019 09:32AM
407
July 24, 2019 11:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.