MySQL Forums
Forum List  »  Stored Procedures

stored procedure for insert mysql 5.5
Posted by: YSAAC RAMIREZ
Date: December 22, 2015 12:52PM

consulta SQL:

CREATE PROCEDURE `empr00100si` ( IN _empresaid VARCHAR( 15 ) , IN _empresa VARCHAR( 65 ) , IN _nombsocial VARCHAR( 65 ) , IN _direccion VARCHAR( 65 ) , IN _ciudad VARCHAR( 65 ) , IN _provincia VARCHAR( 65 ) , IN _pais VARCHAR( 65 ) , IN _cp VARCHAR( 15 ) , IN _sucursal VARCHAR( 65 ) , IN _telefono VARCHAR( 17 ) , IN _fax VARCHAR( 17 ) , IN _email VARCHAR( 31 ) , IN _web VARCHAR( 31 ) , IN _fechaini DATETIME, IN _usuarioid VARCHAR( 15 ) , IN _fecha DATETIME, IN _lema VARCHAR( 65 ) ) BEGIN INSERT INTO `erpcooperativa`.`empr00100` (

`EMPRESAID` ,
`EMPRESA` ,
`NOMBSOCIAL` ,
`DIRECCION` ,
`CIUDAD` ,
`PROVINCIA` ,
`PAIS` ,
`CP` ,
`SUCURSAL` ,
`TELEFONO` ,
`FAX` ,
`EMAIL` ,
`WEB` ,
`FECHAINI` ,
`USUARIOID` ,
`FECHA` ,
`LEMA`
)
VALUES (
_EMPRESAID, _EMPRESA, _NOMBSOCIAL, _DIRECCION, _CIUDAD, _PROVINCIA, _PAIS, _CP, _SUCURSAL, _TELEFONO, _FAX, _EMAIL, _WEB, _FECHAINI, _USUARIOID, _FECHA, _LEMA
);

MySQL ha dicho: Documentación

#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 '' at line 40

Options: ReplyQuote


Subject
Views
Written By
Posted
stored procedure for insert mysql 5.5
2710
December 22, 2015 12:52PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.