Delete Stored Procedure

[liaml1]

Hello everyone,

Could someone tel me what is wrong with this stored procedure that I am trying to create in the MYSQL Administrator?

CREATE PROCEDURE `fjschema`.`sp_delete_tb_proprerty` (_id INTEGER)
BEGIN
DELETE `fjschema`.`tb_property`
WHERE ID = _id
END


I keep getting a 1064 error on line 4.

Any help would be appreciated.

Liam

 

[cLFlaVA]

you don't have a table.



*cLFlaVA
----------------------------
[tt]( <P> <B>)¹³ * (<P> <.</B>)[/tt]

[URL unfurl="true"]http://www.coryarthus.com/[/url]

 

[liaml1]

the table is tb_property.

How would you go about writing this delete stored procedure?

Liam