#!/bin/bash
MYSQL="/usr/bin/mysql"
password="service123" #数据库密码
database="nova"
user="root" #用户
$MYSQL $database -u$user -p$password <<EOF
use nova;
SET FOREIGN_KEY_CHECKS=0;
delete from instances; #sql语句慎重执行
SET FOREIGN_KEY_CHECKS=1;
EOF