When writing scripts for running MySQL in batch mode, it is often desired to be able to change the SQL queries on-the-fly so that we can use the script to solve more generic problems.

For example, I need to use my script for different storage engines and table names and I want to be able to do it at runtime instead of manually changing my script every time.

Here is how I do it:

I have a template file which is my script but with the variables having generic names. In this case, I have considered plugin_name as the storage engine name , and table_name as the table name.

Consider the following script:

# automation-script-template
# Mixing shell commands and SQL queries in batch mode- demo script

# Replace variables: plugin_name, table_name with appropriate names- done automatically by …

When writing scripts for running MySQL in batch mode, it is often desired to be able to change the SQL queries on-the-fly so that we can use the script to solve more generic problems.

For example, I need to use my script for different storage engines and table names and I want to be able to do it at runtime instead of manually changing my script every time.

Here is how I do it:

I have a template file which is my script but with the variables having generic names. In this case, I have considered plugin_name as the storage engine name , and table_name as the table name.

Consider the following script:

# automation-script-template
# Mixing shell commands and SQL queries in batch mode- demo script

# Replace variables: plugin_name, table_name with appropriate names- done automatically by …

The MySQL Telecom sales team is a global team, but it happens to be organized under the EMEA region of the MySQL sales department. Since the EMEA region is having a staff meeting in Dublin this week, it means also we in the telecom team are gathered here. A good opportunity to meet your globally dispersed collagues.

Zack Urlocker was the special guest star from headquarters. He presented a freudian-slip-slide saying that MySQL 5.1 will be released GA in July 2009. After lots of laughter he concessed that maybe engineering can pull it of faster, like maybe July 2008.

Another hot topic Zack talked about was to review how the integration with Sun is going...

...we concluded at least some of us are adapting just fine :-)

The MySQL Telecom sales team is a global team, but it happens to be organized under the EMEA region of the MySQL sales department. Since the EMEA region is having a staff meeting in Dublin this week, it means also we in the telecom team are gathered here. A good opportunity to meet your globally dispersed collagues.

Zack Urlocker was the special guest star from headquarters. He presented a freudian-slip-slide saying that MySQL 5.1 will be released GA in July 2009. After lots of laughter he concessed that maybe engineering can pull it of faster, like maybe July 2008.

Another hot topic Zack talked about was to review how the integration with Sun is going...

...we concluded at least some of us are adapting just fine :-)

Progress acquires IONA. Red Hat announces quarterly earnings. Optaros raises new round of funding. (and more)

Progress Software Corporation to Acquire IONA Technologies, Progess Software / IONA Technologies (Press Release)

Red Hat Reports First Quarter Results, Red Hat (Press Release)

Optaros Closes $12 Million in Series C Financing Co-Led by .406 Ventures & Globespan Capital Partners, Optaros (Press Release)

Sourcefire, Inc. Responds to Barracuda Networks …

Yesterday I blogged about the MySQL Challenge to limit rows accessed. Sheeri had some great comments about the subject, but didn't know either why the first 4 rows were not counted in my original solution:

mysql> explain select actor_id from actor where actor_id % 5 = 0 and actor_id < 26;

*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: actor
type: range
possible_keys: PRIMARY
key: PRIMARY
key_len: 2
ref: NULL
rows: 20
Extra: Using where; Using index

mysql>

I've been thinking about this some more, and wondered what would happen if I tried this query:

mysql> select actor_id from actor where actor_id …

Yesterday I blogged about the MySQL Challenge to limit rows accessed. Sheeri had some great comments about the subject, but didn't know either why the first 4 rows were not counted in my original solution:

mysql> explain select actor_id from actor where actor_id % 5 = 0 and actor_id < 26;

*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: actor
type: range
possible_keys: PRIMARY
key: PRIMARY
key_len: 2
ref: NULL
rows: 20
Extra: Using where; Using index

mysql>

I've been thinking about this some more, and wondered what would happen if I tried this query:

mysql> select actor_id from actor where actor_id …

We were chatting with Jeremy Cole today and he brought to my attention last version of MySQL Community Eddition (5.0.51) was released in November 2007 - over 7 months ago. MySQL 5.0.51a and MySQL 5.0.51b security fixes were released but these can't be considered proper releases.

If we look at the old Kaj's Announcement we can see there suppose to be 2 yearly binary releases (which are overdue) and 4 predictable yearly source releases, which we have not seen either.

Though, Honestly, I do not care that much any more. I have adapted my ways not to go to dev.mysql.com for MySQL downloads any more but go to …

Quite a few Blog postings pop up recently, let me outline two of them.

Gerry Narvaja talks about multi-page printing by using the MySQL Workbench community edition utilizing the PDF output. Find his posting here.

Weizh posted a nice step-by-step tutorial on how to use Workbench to show differences between two databases. Find it here.

Both workflows get you what you want by using the Community Edition. For those of you who want everything on a silver plate there is the Standard Edition of course, which simplifies these tasks even more.

On a side note: To get more information about the printing topic Gerry …

I just finished the third of four week-long residence weeks for school. One more to go and I'll get some semblance of a life back...my wife can't wait. "The Opposable Mind" by Roger Martin was one of the books we had to read as prep for the week. Roger is dean of the Rotman School of Management at the University of Toronto. Roger is one of the most prominent and prolific supporters of integrative thinking. What is integrative thinking? "Integrative Thinking is the ability to constructively face the tensions of opposing models, and instead of choosing one at the expense... READ MORE