JoelBieli
05.01.2015, 18:54
MySQL broblem

Hallo, ich wollte vor kurzen diesen Code in meiner Datenbank einfügen... USE ni262019_2_DB

CREATE PROCEDURE deleteEconomyPrices() TRUNCATE TABLE economy$$

CREATE PROCEDURE deleteOldGangs() DELETE FROM gangs WHERE active = 0$$

CREATE PROCEDURE resetLifeVehicles() UPDATE vehicles SET active= 0;$$

CREATE PROCEDURE deleteDeadVehicles() DELETE FROM vehicles WHERE alive = 0;$$

CREATE PROCEDURE deleteOldMessages() TRUNCATE TABLE messages$$

CREATE PROCEDURE deleteOldHouses() DELETE FROM houses WHERE owned = 0$$

CREATE PROCEDURE setEconomyPrices() NO SQL

und habe diesen Fehler bekommen...

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE PROCEDURE deleteEconomyPrices()

TRUNCATE TABLE economy$$

kann mir jemnad helfen?

 ...zum Beitrag
Antwort
von JoelBieli
07.01.2015, 16:11

Ich danke dir für deine Antwort doch das hat schrecklich wenig gebracht.... Als erstes bekam ich ...#1046 - No database selected also hab ich das hinzugefügt USE ni2620192DB

naja das endete so

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE PROCEDURE deleteEconomyPrices() 
    BEGIN
            TRUNCATE ' at line 3
...zur Antwort
JoelBieli
05.01.2015, 18:54
MySQL broblem

Hallo, ich wollte vor kurzen diesen Code in meiner Datenbank einfügen... USE ni262019_2_DB

CREATE PROCEDURE deleteEconomyPrices() TRUNCATE TABLE economy$$

CREATE PROCEDURE deleteOldGangs() DELETE FROM gangs WHERE active = 0$$

CREATE PROCEDURE resetLifeVehicles() UPDATE vehicles SET active= 0;$$

CREATE PROCEDURE deleteDeadVehicles() DELETE FROM vehicles WHERE alive = 0;$$

CREATE PROCEDURE deleteOldMessages() TRUNCATE TABLE messages$$

CREATE PROCEDURE deleteOldHouses() DELETE FROM houses WHERE owned = 0$$

CREATE PROCEDURE setEconomyPrices() NO SQL

und habe diesen Fehler bekommen...

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE PROCEDURE deleteEconomyPrices()

TRUNCATE TABLE economy$$

kann mir jemnad helfen?

 ...zum Beitrag
Antwort
von JoelBieli
05.01.2015, 20:05

Hier ist noch ein screen...

 ...zur Antwort
JoelBieli
05.01.2015, 18:54
MySQL broblem

Hallo, ich wollte vor kurzen diesen Code in meiner Datenbank einfügen... USE ni262019_2_DB

CREATE PROCEDURE deleteEconomyPrices() TRUNCATE TABLE economy$$

CREATE PROCEDURE deleteOldGangs() DELETE FROM gangs WHERE active = 0$$

CREATE PROCEDURE resetLifeVehicles() UPDATE vehicles SET active= 0;$$

CREATE PROCEDURE deleteDeadVehicles() DELETE FROM vehicles WHERE alive = 0;$$

CREATE PROCEDURE deleteOldMessages() TRUNCATE TABLE messages$$

CREATE PROCEDURE deleteOldHouses() DELETE FROM houses WHERE owned = 0$$

CREATE PROCEDURE setEconomyPrices() NO SQL

und habe diesen Fehler bekommen...

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE PROCEDURE deleteEconomyPrices()

TRUNCATE TABLE economy$$

kann mir jemnad helfen?

 ...zum Beitrag
Antwort
von JoelBieli
05.01.2015, 20:04

Ich habe alle Vorschläge ausprobiert doch es hat nichts gebracht... hier nochmal mit delimiter:

-- -- Database: ni2620192DB

-- Default Schema

DELIMITER $$

-- Procedures

-- Edit arma3 and root to match a user in MySQL

USE ni2620192DB

CREATE PROCEDURE deleteEconomyPrices() NO SQL TRUNCATE economy$$

CREATE PROCEDURE deleteOldGangs() DELETE FROM gangs WHERE active = 0$$

CREATE PROCEDURE resetLifeVehicles() UPDATE vehicles SET active= 0;$$

CREATE PROCEDURE deleteDeadVehicles() DELETE FROM vehicles WHERE alive = 0;$$

CREATE PROCEDURE deleteOldMessages() TRUNCATE TABLE messages$$

CREATE PROCEDURE deleteOldHouses() DELETE FROM houses WHERE owned = 0$$

CREATE PROCEDURE setEconomyPrices() NO SQL

 ...zur Antwort