Arch Linux

axelmangr

Member

Registered: 2004-08-27

Posts: 34

mysql and variable table name

Hello all!

I have a small question concerning mysql! I would like to create a stored procedure (or function, still havent decided what I really need) that will take as input the teable name from which to select all columns. something like "select * from variable_that_came_as_input" Is there anyone who can help me out on that? I've been browsing the net and haven't found anything similar...

thanx a lot
axelmangr

Bobonov

Member

From: Roma - Italy

Registered: 2003-05-07

Posts: 295

Re: mysql and variable table name

As far as I can remeber till mysql5 ther is no stored procedure.
If you realy need them you can use postgress instead.

axelmangr

Member

Registered: 2004-08-27

Posts: 34

Re: mysql and variable table name

As far as I can remeber till mysql5 ther is no stored procedure.
If you realy need them you can use postgress instead.

Yes you are right. but I am using mysql 5 and I 've seen it done, so there is a way...
thanx anyway
axelmangr