奇怪的重定向问题

kejunlqp

#!/bin/sh
printf "create table\n"

BTABLE_NAME=t_acct_safe_b_${2}
TTABLE_NAME=t_acct_safe_t_${2}
BQQTABLE_NAME=t_acct_safe_bqq_${2}

/usr/local/mysql/bin/mysql -uroot $1 <<!
    drop table if exists ${BTABLE_NAME};

    create table ${BTABLE_NAME}(
        fault_code int,
        forder int,
        fapp_id int,
        fuser_ip int unsigned,
        fapp_ip int unsigned,
        fuin int unsigned,
        ftran_amt float,
        ftran_time int unsigned
    );

    drop table if exists ${TTABLE_NAME};

    create table ${TTABLE_NAME}(
        forder int,
        fapp_id int,
        fuser_ip int unsigned,
        fapp_ip int unsigned,
        fuin int unsigned,
        ftran_amt float,
        fbalance float,
        ftran_time int unsigned
    );

    drop table if exists ${BQQTABLE_NAME};

    create table ${BQQTABLE_NAME}(
        fault_code int,
        forder int,
        fapp_id int,
        fuser_ip int unsigned,
        fapp_ip int unsigned,
        fuin int unsigned,
        providefuin int,
        ftran_amt float,
        fbalance float,
        ftran_time int unsigned,
        value1 int,
        value2 int,
        value3 int,
        value4 int
    ) TYPE=MyISAM;

!
奇怪了。怎么会在<<后面出现! 而最后居然也是以!结束的。why??

[ 本帖最后由 kejunlqp 于 2007-10-19 14:48 编辑 ]

wdavid

Search "here documents" in Shell section.