/    Sign up×
Community /Pin to ProfileBookmark

SQL at certain time

Copy linkTweet thisAlerts:
Jul 02.2006

Hi,
Is it possible to write a piece of SQL and then insert it into the PHPmyADMIN SQL box so that the piece of SQL will run automatically every night at a certain time doing what I set?

Thanks.

to post a comment
PHP

3 Comments(s) ↴

Copy linkTweet thisAlerts:
@MicahCarrickJul 02.2006 — Not that I know of, however, you can setup up a cron job to do it from you using the mysql command line or a php script.
Copy linkTweet thisAlerts:
@metrostarsauthorJul 02.2006 — Hi,

Thanks for that. But is it possible, using cron, to run some SQL in PHPmyADMIN?

Thanks again.
Copy linkTweet thisAlerts:
@MicahCarrickJul 02.2006 — No, not that I could think of... it almost doesn't even make sense... phpMyAdmin is a web-based interface to the database where as a cron job is likely running on the same server as the database and running on the backend... the server running the cron might not even have any GUI libraries installed.

You could achieve the same result, it just wouldn't be through phpMyAdmin.
×

Success!

Help @metrostars spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 5.5,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,

tipper: @Samric24,
tipped: article
amount: 1000 SATS,
)...