MySQL Forums
Forum List  »  Stored Procedures

Re: Dynamic SQL. Is it possible?
Posted by: peter.hamilton-scott
Date: November 04, 2005 04:45PM

Roland, thanks for the excellent narrative and whilst reading it some questions came to mind.

1. How do I know which version I have installed? I downloaded the latest of everything from the MySql site. I have Administrator 1.1.4 and Query Browser 1.1.17. Are these ok? I noticed that if I enter status in the MySql command prompt, it lists 5.0.15-nt so I think that's what you are referring to?

2. In the example above, you use @sql_text as a global user variable. Is that variable of your own choosing? What is its datatype defined as?

3. In your assignment statements you use := were I've only seen = used. I know it sounds dumb, but are they just different syntax styles for the same thing?

4. In my Query Browser 1.1.17, I can see tables and procedures, but I can't edit triggers. Instead I have to edit them outside of Query Browser and add them by file into MySql. I'm thinking that maybe triggers never made it in time for Query Browser because they are new additions so they missed the boat so to speak?

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
3461
November 04, 2005 01:40AM
2641
November 04, 2005 03:51AM
2669
November 04, 2005 08:51AM
2398
November 23, 2005 10:50AM
2348
November 23, 2005 02:18PM
2427
November 04, 2005 08:54AM
6604
November 04, 2005 03:40PM
2463
November 04, 2005 05:21PM
Re: Dynamic SQL. Is it possible?
2531
November 04, 2005 04:45PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.