Mi problema reside en que tengo una bd en MySQL - 5.5.20 y la exporto y necesito poder importarla desde MySQL - 5.0.45 , pero al hacerlo me salta este error:
Código SQL:
Ver originalconsulta SQL:
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Base de datos: `db`
--
DELIMITER $$--
-- Procedimientos
--
CREATE DEFINER =`root` @`localhost`PROCEDURE`Count_Articulos_by_Marca` (IN in_idMarca INT ) BEGIN SELECT COUNT( idArticulos )AS COUNT
FROM articulos
WHERE marcas_idMarcas = in_idMarca;
MySQL ha dicho:
#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 $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `Count_Articulos_by_Mar' at line 1
Solucion?? gracias!