What's the syntax in MySQL for the execution of SQL commands from a script?
What? You need to open a connection to the backend and pass it the SQL. There may be some command line utilities that do this (accepting SQL as an argument to the program) but I'm not really sure what you're wanting here.
No, I am at the command line in MySQL and need to simply execute text file containing a series of SQL commands.
Pop back out to the command line in the OS and use mysql dbname < filename.txt. Works for me everytime, 'cept when I make a sintax error.
is there any way to execute directly from the command line of MySQL without poping out to the command line of the os?
You are basically asking for MySQL to do a stored procedure. That isn't supported, yet.
See docs for more details.
Is there any timeline on when MySQL will be able to do this? It is rather trivial to implement but also useful once it is.
