1. From the manual

2. A shell script example

    #!/bin/sh

    # Create Linux SIG Database
  
    # mSQL Home
    MSQLHOME=/usr/local/Hughes
  
    # Load the schema
  
    $MSQLHOME/bin/msql sluugls << EOF
            drop table meetings
            \p\g
        
            create table meetings (
                    meetingDate             date,
                    topic                   char(80),
                    attendence              int
            )
            \p\g
    EOF
  
    # Load data
    $MSQLHOME/bin/msql sluugls << EOF

    insert into meetings values ( '21-Dec-1995', 'Linux Emulators & other nifty Linux apps', 27 )\g
    insert into meetings values ( '16-Nov-1995', 'Building a Linux System from Scratch - Part II', 33 )\g
    insert into meetings values ( '19-Oct-1995', 'Filesystem Structure Standard
Building a Linux System from Scratch - Part I', 29 )\g
    insert into meetings values ( '21-Sep-1995', 'Creating a Linux Boot/Root Diskette
LaTeX', 24 )\g
    insert into meetings values ( '17-Aug-1995', 'Linux Frontiers by Matt Welsh', 70 )\g
    insert into meetings values ( '20-Jul-1995', 'The bash & tcsh shells', 37 )\g

    EOF