每天在计算机启动MYSQL服务时创建mySQL表 [英] mySQL table create daily when computer start the MYSQL service

问题描述

我想每天在特定数据库中创建该表.该表将在每天启动计算机时创建.此事件我没有处理所有这些由mysql服务启动时自动创建的MYSQL处理的事情. "h2_lin">解决方案

您可以使用mySQL Events安排此类重复性任务.
参见 http://dev.mysql.com/tech-resources/articles/mysql-events.html [^ ]

您可以使用crontab/Windows调度程序解决您的问题.
启动计算机后，调度一个运行mysql批处理作业的作业，该批处理作业执行需要的SQL语句.

i want create the table in the particular database daily.this table will be created when the each day starting of the computer.this event i am not handling these all things handle by MYSQL created automatically when mysql service started

解决方案

You could use mySQL Events to schedule such a repetitive task.
See http://dev.mysql.com/tech-resources/articles/mysql-events.html[^].

You can use crontab/Windows scheduler to solve you problem.
When the computer is started, scheduler a job that runs a mysql batch job that performs the SQL statements need.

这篇关于每天在计算机启动MYSQL服务时创建mySQL表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！