You are not logged in.

#1 2004-08-30 21:11:45

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

Offline

#2 2004-08-31 06:55:52

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.

Offline

#3 2004-08-31 09:19:44

axelmangr
Member
Registered: 2004-08-27
Posts: 34

Re: mysql and variable table name

Bobonov wrote:

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

Offline

Board footer

Powered by FluxBB