При импорте бд получаю ошибку (через sypex dumper)
Код:
MySQL Error: 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\' at line 1 (/var/www/user/data/www/xxx/sxd/index.php:1594)
Если через PHPmyadmin то
Код:
delimiter ; ;
CREATE PROCEDURE `ft_job_search_filter_3` ( IN param_city VARCHAR( 255 ) , param_company_slug VARCHAR( 255 ) , param_title VARCHAR( 255 ) , from_limit INT( 5 ) , to_limit INT( 5 ) ) BEGIN SELECT pj.ID, pj.job_title, pj.job_slug, pj.employer_ID, pj.company_ID, pj.job_description, pj.city, pj.dated, pj.last_date, pj.is_featured, pj.sts, pc.company_name, pc.company_logo, pc.company_slug,
MATCH (
pj.job_title, pj.job_description
)
AGAINST (
param_title
) AS score
FROM pp_post_jobs pj
INNER JOIN pp_companies pc ON pc.ID = pj.company_ID
WHERE (
pj.job_title LIKE CONCAT( "%", param_title, "%" )
OR pj.job_description LIKE CONCAT( "%", param_title, "%" )
OR pj.required_skills LIKE CONCAT( "%", param_title, "%" )
)
AND pc.company_slug = param_company_slug
AND pj.city = param_city
AND pj.sts = 'active'
AND pc.sts = 'active'
ORDER BY score DESC
LIMIT from_limit, to_limit;
END ; ;
Ответ MySQL: Документация
#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 'from_limit, to_limit;
END' at line 10
Может кто нибудь помочь разобраться с этой проблемой? базу данных вышлю.
Очень нужно, как появится возможность, отблагодарю.