It seems that mysqldump on mysql 5.0 does not export my stored
procedures.
How do I dump these out so that other people can load them into their
copies of my database?
Matt
--
A better way of running series of SAS programs:
http://overlook.homelinux.net/wilsonwiki/SasAndMakefiles
--
MySQL G
I'm writing a stored procedure that gets a VARCHAR(45) as a parameter.
Inside my stored procedure, I want to create a table with a name based
on that parameter.
For example, if I do
call my_sp('XXX');
I want the stored procedure to create a table named foo_XXX.
I don't know how to do this. He
I've spent the last month building a fairly elaborate database with lots
of foreign keys.
I want to draw a diagram that maps the relationships between all the
tables, but I haven't found any software that can do that.
Does anyone have any suggestions? I want to draw a picture with a box
for eac
I wrote a fairly large query that summarizes our sales into monthly
totals by business unit, then left joins on some other information from
a bunch of other tables.
Running the query takes a long time.
I'm considering whether to store my summary data as a table, like this:
create table monthly_t
