USERNAME="root"

PASSWORD="***"

 

DBNAME="luntek_icplatform_test"  #数据库名称

TABLENAME="timer" #数据库中表的名称

 

#创建数据库

create_db_sql="create database IF NOT EXISTS ${DBNAME}"

mysql -u${USERNAME} -p${PASSWORD} -e "${create_db_sql}"

 

#创建表

create_table_sql="CREATE TABLE IF NOT EXISTS timer  (
  id int(11) NOT NULL AUTO_INCREMENT,
  date datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic"

mysql -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${create_table_sql}"

 

#插入数据
mysql -u${USERNAME} -p${PASSWORD} $DBNAME -e "insert into $TABLENAME  (date) values (NOW());"
exit 0

原文来自于https://blog.csdn.net/qq_42910468/article/details/110931368