Skip to content

Procedures can't being executed in top file #2

@rusminto

Description

@rusminto

Hi,
In my sql file, there are a procedure to reset data like :

DELETE TABLE aa;
ALTER TABLE aa AUTO_INCREMENT = 1;

After I export my database to sql file, my procedure was on top of file (before create table). Due to it's location, my procedure can't be imported with message :

SqlError: (conn=1534, no: 1146, SQLState: 42S02) Table 'db.aa' doesn't exist

But after i try to put it on bottom of file, my procedure was created safely. Can you make procedure and function creation being executed after table creation ? Cheers.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions