Over a million developers have joined DZone.

Making MySQL Executable Scripts.

DZone's Guide to

Making MySQL Executable Scripts.

· ·
Free Resource
Use "here document" statements to build complex script files with embedded SQL statements via the mysql utility.

#! /usr/bin/env bash

# execute some bash scripting commands here

mysql mydatabase <

Note that being in a bash script means that you can expand $-variables inside the SQL code directly.  This is, however, not advised unless you can be sure that only trusted, competent people will run your code.  Otherwise you'll be facing SQL injection attacks.

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}