Prilikom uploada baze jednog wordpress site na server na internetu dobijem poruku:
Code:
Code:
Pogreška
SQL upit: Dokumentacija
--
-- Baza podataka: `test`
--
DELIMITER $$--
-- Postupci
--
DROP PROCEDURE IF EXISTS `test_multi_sets` $$ CREATE DEFINER = `root`@`localhost` PROCEDURE `test_multi_sets` ( ) DETERMINISTIC BEGIN SELECT USER( ) AS first_col;
MySQL je poručio: Dokumentacija
#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 'DELIMITER $$
DROP PROCEDURE IF EXISTS `test_multi_sets`$$
CREATE DEFINER=`root`@' at line 1
Kod u blizini delimitera je:
DELIMITER $$
--
-- Postupci
--
CREATE DEFINER=`root`@`localhost` PROCEDURE `test_multi_sets`()
DETERMINISTIC
begin
select user() as first_col;
select user() as first_col, now() as second_col;
select user() as first_col, now() as second_col, now() as third_col;
end$$
DELIMITER;
-- --------------------------------------------------------
Da li bih mogao ispraviti sintaxu da uploadam ovu bazu na server, ako je premalo informacija, recite šta treba pa ću napisati.
Hvala.