mysql存储过程 语法报错

Question

就是根据schedule表的时间和当前时间进行比较，然后更新order表的state值 

delimiter $$
DROP PROCEDURE IF EXISTS update_order_state
CREATE PROCEDURE update_order_state()
	BEGIN
	    UPDATE `order`,`schedule` SET order_state = 1 
            WHERE `order`.schedule_id = `schedule`.schedule_id 
            AND schedule_start_time < current_timestamp;
	END$$
delimiter;

报错：

> 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 'CREATE PROCEDURE update_order_state()
    BEGIN
        UPDATE `order`,`schedule` SET o' at line 2

Answer 1

UPDATE 后面是表名