delete语句不释放磁盘
drop语句释放磁盘空间
可以用这种方法清除数据
HOSTNAME="192.168.111.84"
PORT="3306"
USERNAME="root"
PASSWORD=""
DBNAME="test_db_test"
TABLENAME="test_table_test"
#删除数据
delete_sql="delete from ${TABLENAME}"
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e"${delete_sql}"
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e"${select_sql}"