Code:
USE proglanguage;
DROP PROCEDURE IF EXISTS p_new_lang;
DELIMITER //
CREATE PROCEDURE p_new_lang
(new_lang VARCHAR(50), new_ver VARCHAR(25), new_flavor VARCHAR(50), new_usedlibs TEXT, new_used_os VARCHAR (50), new_revision VARCHAR(50))
BEGIN
-- Check if language and flavor version already exists
IF (new_lang = t_languages.lang AND new_flavor = t_languages.flavor) THEN
-- Update table with new Info if language and flavor already exists
UPDATE t_languages
SET
ver=t_languages.ver+'/ '+new_ver,
used_os=t_languages.used_os+'/ '+new_used_os,
revision=t_languages.revision+'/ '+new_revision
WHERE lang=new_lang;
--Check if the table already has used libs input
IF (t_languages.usedlibs IS NULL) THEN
UPDATE t_languages SET usedlibs=new_usedlibs WHERE lang=new_lang;
ELSE
UPDATE t_languages SET usedlibs=t_languages.usedlibs+', '+new_usedlibs WHERE t_languages.lang=new_lang;
END IF;
-- If language doesn't exist insert it into the table
ELSE
IF (new_usedlibs IS NULL) THEN
INSERT INTO t_languages
(lang, ver, flavor, used_os, revision) VALUES
(new_lang, new_ver, new_flavor, new_used_os, new_revision);
ELSE
INSERT INTO t_languages
(lang, ver, flavor, usedlibs, used_os, revision) VALUES
(new_lang, new_ver, new_flavor, new_usedlibs, new_used_os, new_revision);
END IF;
END IF;
END //
DELIMITER ;
Oben steh alles was ich für die Prozedur geschrieben habe, Ich kriege allerdings immernoch den Fehler
Code:
ERROR 1109 (42S02): Unknown table 't_languages' in field list
Meine Derzeitigen Tabellen sind
Code:
+------------------------+
| Tables_in_proglanguage |
+------------------------+
| t_commands |
| t_languages |
+------------------------+
Schonmal danke im voraus!
PS: EVENTUELL FRAGE ICH NOCH AUF ANDEREN FOREN, FALLS ES DAZU KOMMT LINKE ICH DIESE