Databases
StackOverflow2013
Postsdbo
POCant able to export mysql data to godaddy server - showing syntax error
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCant able to export mysql data to godaddy server - showing syntax error
    primarykey
    data
    text
    <p>This is my procedure:</p> <pre><code>CREATE DEFINER=`root`@`localhost` PROCEDURE `RPTtempreceipts`( IN vRCPTNO VARCHAR(20)) BEGIN DECLARE vBNo VARCHAR(20); DECLARE vPtyCde INTEGER DEFAULT 0; DECLARE vWMC VARCHAR(20); DECLARE vPrdCde VARCHAR(10); DECLARE vBcde CHAR(5); DECLARE vSAPLID INTEGER DEFAULT 0; -- Assign Values SELECT T.BNo,T.pty_code,T.WMC,T.PrdCde,T.Bcde INTO vBNo,vPtyCde,vWMC,vPrdCde,vBcde FROM tbltransaction T INNER JOIN tbltransreceipts TR ON T.BNo=TR.BNo WHERE TR.RcptNO=vRCPTNO; SELECT SAPLID INTO vSAPLID FROM tblcust_prd_wor WHERE pty_code=vPtyCde; -- Select Queries are configured as for Typed Dataset under DT's SELECT * FROM tbltrans WHERE BNo=vBNo; SELECT * FROM tbltransrcpt WHERE RNo=vRCPTNO; END </code></pre> <p>Showing following error:</p> <blockquote> <p>Error Code : 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 'DECLARE vPtyCde INTEGER' at line 1 (328 ms taken)</p> <p>Error Code : 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 'DECLARE vWMC VARCHAR(20)' at line 1 (312 ms taken)</p> <p>Error Code : 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 'DECLARE vPrdCde VARCHAR(10)' at line 1 (328 ms taken)</p> <p>Error Code : 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 'DECLARE vBcde CHAR(5)' at line 1 (313 ms taken)</p> <p>Error Code : 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 'DECLARE vSAPLID INTEGER DEFAULT 0' at line 1 (297 ms taken)</p> <p>Error Code : 1327 Undeclared variable: vBNo (312 ms taken)</p> <p>Error Code : 1327 Undeclared variable: vSAPLID (297 ms taken)</p> </blockquote> <p>I am confused with this because its working fine in localhost. now i finished the project and like to upload the db to server. But these errors stopped me to proceed further... Please help me.</p> <p>Regards, Sensa.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USSensa
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCant able to export mysql data to godaddy server - showing syntax error
      1. USChetter Hummin
      1. VTFavorite
    1. COAren't MySql vars prefixed with '@'? http://dev.mysql.com/doc/refman/5.1/en/user-variables.html
      singulars
      1. POCant able to export mysql data to godaddy server - showing syntax error
      1. USR. Valbuena
    2. COIs it required to have this line: CREATE DEFINER=`root`@`localhost` may i delete this "DEFINER=`root`@`localhost`" and just keep CREATE
      singulars
      1. POCant able to export mysql data to godaddy server - showing syntax error
      1. USSensa
    3. COThe problem is with DEFINER. DEFINER CLASS is handling previledges. So, please let me know how to remove DEFINER in stored procedure.
      singulars
      1. POCant able to export mysql data to godaddy server - showing syntax error
      1. USSensa
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload