[RESOLVED] Peculier , MySQL stored procedure inserting data of VARCHAR as 0 and 1

[make me rain]

With MySQL
i have a stored procedure which writes the data into table, and it does But the VARCHAR is getting stored as 0 and 1
here is my stored procedure

CREATE DEFINER = `root`@`localhost` PROCEDURE `ACC_AP_Proofing`(IP_ACCID_FK SMALLINT(4) , IP_FTPpath VARCHAR(125) ,IP_description VARCHAR(25) , IP_Deo VARCHAR(100))
BEGIN
 
#ACC_AP_Proofin
 
INSERT INTO acc_proofing (
acc_proofing.ACCID_FK,
acc_proofing.FTPpath,
acc_proofing.description,
acc_proofing.Deo ,
acc_proofing.docid_pk ) VALUES (
acc_proofing.ACCID_FK = IP_ACCID_FK,
acc_proofing.FTPpath = IP_FTPpath,
acc_proofing.description = IP_description,
acc_proofing.Deo = IP_Deo ,
acc_proofing.docid_pk = NULL
);
 
 
END;

What is going wrong please

[jmcilhinney]

Your VALUES clause is wrong. You are mixing up an INSERT with an UPDATE statement, where you do assign a value to a column. In your INSERT statement, you have already specified the columns in the first set of parentheses. The VALUES clause should contain ONLY the values:

INSERT INTO acc_proofing (
acc_proofing.ACCID_FK,
acc_proofing.FTPpath,
acc_proofing.description,
acc_proofing.Deo ,
acc_proofing.docid_pk ) VALUES (
IP_ACCID_FK,
IP_FTPpath,
IP_description,
IP_Deo ,
NULL
);

The reason you were getting 0 or 1 would be that your attempt at assignment was being interpreted as comparison and the result of that would be a Boolean value, 1 for True if the column was equal to the value and 0 for False if it wasn't.

[make me rain]

Oh my god
Thanks sir