mysql-error Questions
7
Hello im having a hard time with this stored procedure. I'm getting the error:
Result consisted of more than one row.
Here is my stored procedure:
DELIMITER $$
DROP PROCEDURE IF EXISTS `dss`.`COST...
Nickel asked 11/2, 2010 at 6:32
6
Solved
I was using mysql 5.6.11. It usually turned down and show me this:
2005 - Unknown MySQL server host 'localhost'(11001).
Currently my resolution is to turn off the network, then it returns to norm...
Period asked 16/5, 2013 at 6:24
2
Solved
Everywhere I look it seems MySQL stored procedures can do transactions. Yet when I declare my stored function
create function test( a int )
returns int
MODIFIES SQL DATA
BEGIN
START TRANSACTION ;
...
Tournai asked 6/6, 2013 at 18:49
2
Solved
I'm trying to create the following stored procedure in phpMyAdmin. But, I keep getting this error: #1313 - RETURN is only allowed in a FUNCTION
CREATE PROCEDURE IS_POINT_IN_POLYGON()
BEGIN
DECLARE ...
Sherrer asked 26/8, 2011 at 1:22
3
Solved
I'm using mysqldump to share databases dumps, but I'm having an issue with triggers. The command does not add "drop" or "replace" lines with the triggers, making people who alre...
Uranium asked 22/12, 2016 at 10:54
2
Solved
delimiter $$
CREATE TRIGGER REDUCE_NOTE_COUNT
AFTER DELETE ON iv_notes
FOR EACH ROW BEGIN
DECLARE supplierid int(11);
DECLARE customerid int(11);
SELECT supplierid ,customerid FROM iv_documents ...
Oidium asked 18/9, 2012 at 9:49
4
Solved
I have book and store_order tables.
I want to make trigger(but it contain error):
DELIMITER $$
CREATE TRIGGER t1
BEFORE DELETE ON store_order
FOR EACH ROW
BEGIN
UPDATE book SET number = numb...
Trotta asked 1/6, 2015 at 15:36
6
Solved
I tried to create a trigger with OLD.num and NEW.num as shown below:
CREATE TRIGGER my_trigger
AFTER INSERT ON test FOR EACH ROW
SET @old_num = OLD.num, @new_num = NEW.num;
-- ↑ Here -- ↑ Here
Bu...
Replay asked 16/7, 2013 at 15:53
2
Solved
I have trouble defining a trigger for a MySQL database. I want to change a textfield before inserting a new row (under a given condition). This is what I have tried:
CREATE TRIGGER add_bcc
BEFORE I...
Ezraezri asked 22/1, 2009 at 16:14
4
Solved
I have browsed around and other solutions don't seem to be working for me here. I keep getting a 'No return found for function' error when trying to create this function in MySQL. Any idea why?
CRE...
Ballman asked 17/9, 2012 at 1:11
3
Solved
I want to allow LOAD DATA command for the john mysql user. So I logged into mysql terminal as root and issued the following statement:
GRANT FILE ON johndatabase.* TO 'john'@'localhost';
But I got...
Calculous asked 25/11, 2012 at 15:0
1
© 2022 - 2024 — McMap. All rights reserved.