mysql - How To Update a Sql Table On Regular Interval -

-

i have data table in sql database , want update entries in table on 1 day(regular) interval. how can it

you can try event scheduler in sql

create event myevent on schedule @ current_timestamp + interval 1 hour update myschema.mytable set mycol = mycol + 1;

i hope may useful you...

since dont know scenario..


Comments

Post a Comment

Popular posts from this blog

html - jquery - p element wont show after I hid it -

-
im trying build website , ive ran problem. got 4 pictures , whenever want click on picture, want show text. wont show, did link console log , shows working. can me this? thanks in advance! css <img class ="porfoto" title="tekstroy" id ="roy" src="img/roy.png"> <img class ="porfoto" title="tekstkinmen" id ="kinmen" src="img/kinmen.png"> <img class ="porfoto" title="tekstboris" id ="boris" src="img/boris.png"> <img class ="porfoto" title="tekstelse" id ="else" src="img/else.png"> <p id="tekstroy">hallo </p> <p id="tekstkinmen">hallo2<p> <p id="tekstboris">hallo3</p> <p id="tekstelse">hallo4</p> js $("#tekstroy").hide(); $("#tekstkinmen").hide(); $("#tekstboris").hi...
Read more

python - BeautifulSoup: How to get the nearest tag -

-
i have xml file following data <year>2013</year> <yousavespend>2500</yousavespend> <yourmpgvehicle> <avgmpg>32.261695541</avgmpg> <citypercent>43</citypercent> <highwaypercent>57</highwaypercent> </yourmpgvehicle> <year>2013</year> <yousavespend>3000</yousavespend> <yourmpgvehicle> <avgmpg>33.383275416</avgmpg> <citypercent>49</citypercent> <highwaypercent>51</highwaypercent> </yourmpgvehicle> <year>2012</year> <yousavespend>2500</yousavespend> <yourmpgvehicle> <avgmpg>36.210640188</avgmpg> <citypercent>32</citypercent> <highwaypercent>68</highwaypercent> </yourmpgvehicle> i want use beautifulsoup return list of avgmpg year 2013? how can that? my current effort has been: for item in soupedcaravgmpgpage.findall('year'): listofyears.append(''...
Read more

mysql - Trying to get RmySQL to work but not understanding bash's export or filesystem conventions -

-
i trying install rmysql on mac (mavericks) , errors out when try build source, saying: configuration error: not find mysql installation include and/or library directories. manually specify location of mysql libraries , header files , re-run r cmd install. instructions: define , export 2 shell variables pkg_cppflags , pkg_libs include directory header files (*.h) , libraries, example (using bourne shell syntax): export pkg_cppflags="-i" export pkg_libs="-l -lmysqlclient" re-run r install command: r cmd install rmysql_.tar.gz i tried follow instructions entering: export pkg_cppflags="-i/usr/local/mysql/include" export pkg_libs="-l/usr/local/mysql/lib -lmysqlclient" but when re-run rmysql still doesn't work. moreover, if type $pkg_libs to see variable holds, -bash: -l/usr/local/mysql/lib: no such file or directory' i know /usr/local/mysql/lib exi...
Read more