miffe Posted December 18, 2006 Share Posted December 18, 2006 MS Access has the advantage of storing SQL queries in the same DB, MySQL does not offer this. Would it be valid to create a table called 'SQLQueries' and store queries as VarChars ?+ What if the queries are 255+ characters long? How can I extend the length of the field?Thanks,Miffe Link to comment Share on other sites More sharing options...
jesh Posted December 19, 2006 Share Posted December 19, 2006 Are you talking about Stored Procedures? http://dev.mysql.com/doc/refman/5.0/en/sto...procedures.html Link to comment Share on other sites More sharing options...
justsomeguy Posted December 19, 2006 Share Posted December 19, 2006 You can use the text datatype if you want to store text longer then 255 characters. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now