Stored Procedures

[tvunix10]

I moved a database and stored procedure from Host Gator to here for testing. The pocedure takes 2 strings and returns results fine on HG but on x10 it returns zero rows. Are stored procedures allowed? Anyone else experience this?

 

[tvunix10]

I created another simple stored procedure that copies one of my tables into a temp table and returns all the rows from the temp table. That works, so looks likes stored procedures work. Maybe a mysql version issue?

 

[essellar]

...or MySQL vs MariaDB (which is actually what's in use here).

 

[tvunix10]

I figured it out! In my sproc I had "engine=memory" on a whim I changed that to "engine=InnoDB" and it started working as expected.