Search results for query: *

Thanks.

What is the simplest way to transfer a complete MySQL database from one machine to another?

That explains it! My system is at version 3.23.49, although somebody told me it should work from 3.23.2. Upgrade required, I think. Thanks.

If no implementations actually enforce the full standard then it would probably be a waste of money. Thanks for your help anyway. Should I be able to use the CAST function in MySQL? Somebody I know is telling me I should, but I keep getting errors whichever way I try it.

Ok. I see what you mean now - edit the source code of MySQL itself. No thanks :-) I'm going to do what you say and modularize my code - in fact I would anyway, even without this issue. The specific difficulty I've been having is as follows. When I so a query like SELECT * FROM TAB01 WHERE...

I don't understand. Are you saying there IS a way to ensure ANSI standards are enforced or are you saying you can only make the code portable by editing it?

Is it possible to configure mySQL in such a way that it only processes ANSI standard SQL, and produces an error for anything else? I'd like to do this with a view to ensuring that code is portable to other platforms.