Shell Programming and Scripting

Hi guys,

i know how to run a single query using mysql embedded in a shell script as follows:

Code:

`mysql -umyuser -pmypass --host myhost database<<SQL
${query};
quit
SQL`

However, how would i be able to run several queries within the same connection?

The reason for this is i am creating TEMPORARY tables and MySql drops them when you close a connection, so i cant create one, close a connection and re-use it later...

If I understand correctly you can use something like this:

Code:

mysql -user<user> -p<pass> -h<host> database -e'
  statement one;
  statement two;
  ...
  statment n;
  '

Or, of course, put more than one statement in the here document in the example in your original post.

Thanks,

Can i do the following?

Code:

mysql -user<user> -p<pass> -h<host> database -e'
  statement one;\n
  statement two;\n
  ...
  statment n;
  '

Or, of course, put more than one statement in the here document in the example in your original post.[/QUOTE]

Notice the newlines? if i have tried it the way you say but the statements get wrapped around rather than going onto the next line...i.e.:

Code:

mysql -user<user> -p<pass> -h<host> database -e'
  statement one; statement two; statment n;
  '

Or, of course, put more than one statement in the here document in the example in your original post.[/QUOTE]

You need the newlines only for legibility, mysql accepts more than one statement on the same line
(the statements should be separated by semicolons).