Comments on: MySQL wrapper script: variables from the command line https://quoderat.megginson.com/2011/06/21/mysql-wrapper-script-variables-from-the-command-line/ Open information and technology. Fri, 14 Mar 2014 21:26:29 +0000 hourly 1 http://wordpress.com/ By: Aurelia https://quoderat.megginson.com/2011/06/21/mysql-wrapper-script-variables-from-the-command-line/#comment-5831 Fri, 14 Mar 2014 21:26:29 +0000 http://quoderat.megginson.com/?p=528#comment-5831 also has major influences in building a civilization
in India. The various books that Craig ‘felt inspired to
write’ are available at. “”ISRAEL’S ROUTINE shelling of the
Gaza coast was heavier and louder than usual yesterday.

]]> By: www.youtube.com https://quoderat.megginson.com/2011/06/21/mysql-wrapper-script-variables-from-the-command-line/#comment-5814 Fri, 14 Mar 2014 14:25:47 +0000 http://quoderat.megginson.com/?p=528#comment-5814 When you purchase a new bag to make your travel
in a tote plan workable, consider buying an unusual color or
pattern to make your bag distinctive from all the other black bags seen circling
on conveyor belts. Even guys who know all the tips to attract women and
have practiced their dating skills for years can have a hard time keeping
a conversation alive and entertaining. To know more information about
How to Attract Girls and How To Approach A Woman visit Sinnsofattraction.

]]> By: Indian Suits for wedding https://quoderat.megginson.com/2011/06/21/mysql-wrapper-script-variables-from-the-command-line/#comment-5153 Tue, 31 Dec 2013 17:36:26 +0000 http://quoderat.megginson.com/?p=528#comment-5153 Men can not imagine the way things look like based on
the colors and patterns through imagination. For many pickers, vintage Nike clothing is still a lucrative market alongside vintage Hawaiian shirts, vintage
Levis and vintage Levi jackets. They cost less than new items
– a piece of clothing in a charity shop, car
boot sale or second hand clothing website will almost certainly cost a fraction of it’s original new price.

]]> By: plumber pompano beach florida https://quoderat.megginson.com/2011/06/21/mysql-wrapper-script-variables-from-the-command-line/#comment-5095 Wed, 11 Dec 2013 09:17:52 +0000 http://quoderat.megginson.com/?p=528#comment-5095 obviously like your web-site however you havfe to check the spelling on quite a
feew of your posts. A number of them are rife with spelling
issues and I to find it very bothersome to tell the truth on the
othe hand Iwill surely come back again.

]]> By: Adriana https://quoderat.megginson.com/2011/06/21/mysql-wrapper-script-variables-from-the-command-line/#comment-5093 Tue, 10 Dec 2013 16:14:39 +0000 http://quoderat.megginson.com/?p=528#comment-5093 WOW jut what I was searching for. Came here by swarching for
what tto bring to file taxes

]]> By: palm beach county accountants https://quoderat.megginson.com/2011/06/21/mysql-wrapper-script-variables-from-the-command-line/#comment-5092 Tue, 10 Dec 2013 05:36:30 +0000 http://quoderat.megginson.com/?p=528#comment-5092 Wow, wonderful blog format! How long have you been running a blog for?
you make blogging glanjce easy. The overall look
of your site is wonderful, as smartly as the content material!

]]> By: SteveChervitzTrutane (@trutane) https://quoderat.megginson.com/2011/06/21/mysql-wrapper-script-variables-from-the-command-line/#comment-4254 Sat, 23 Mar 2013 00:06:45 +0000 http://quoderat.megginson.com/?p=528#comment-4254 You CAN pass variables from the command-line [1], but you have to source your .sql script instead of feeding it via STDIN. Run the mysql command like this:

mysql -h HOST -u USER -pPASS -e “set @type = ‘foo’; source getstuff.sql;”

Don’t forget the semicolons.

The sad part of this story is that you CANNOT use variables for a table, column, or database name or part of such a name[2]. Rats! That would be quite useful, wouldn’t it?

References:
1. http://stackoverflow.com/questions/10229324/pass-parameter-to-mysql-script-command-line
2. http://dev.mysql.com/doc/refman/5.5/en/user-variables.html

]]> By: Jamie McNaught https://quoderat.megginson.com/2011/06/21/mysql-wrapper-script-variables-from-the-command-line/#comment-4253 Mon, 11 Mar 2013 14:36:51 +0000 http://quoderat.megginson.com/?p=528#comment-4253 Sadly this doesn’t seem to work if you want to specify the database name as a variable. e.g. CREATE DATABASE @DBNAME. Having to resort to using sed. 😦

]]> By: Marcel https://quoderat.megginson.com/2011/06/21/mysql-wrapper-script-variables-from-the-command-line/#comment-4139 Thu, 11 Oct 2012 17:03:57 +0000 http://quoderat.megginson.com/?p=528#comment-4139 If mysql prompts for a password, the input does not get fed to mysql correctly apparently.

]]> By: deepwinter https://quoderat.megginson.com/2011/06/21/mysql-wrapper-script-variables-from-the-command-line/#comment-4134 Fri, 20 Jul 2012 01:57:24 +0000 http://quoderat.megginson.com/?p=528#comment-4134 Useful script. Do you have it on github ??

]]>