Mixing
Problem to gather previlages from server while using EVENTS(service provider say no possiblity to On). Can I...
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I was used events to insert my query to every hour finding average(that was calculated by the number of customer cames today and their respective total arrives from the beginning). Events successfully run and insert every hour needed values successfully on my localhost. But the main problem is to load the event into Server Db because our service provider refused to ON Superprevilages. Now I need to find another solution instead of event
this is my query on the event can we try any other way?
CREATE EVENT average_visiter
ON SCHEDULE
EVERY 1 DAY
STARTS '2014-04-30 00:20:00' ON COMPLETION PRESERVE ENABLE
DO
INSERT INTO `test_table`( `res_id`, `b_id`, `total_visit`, `tota_count`)
SELECT res_id,b_id,sum(total_visit),count(cust_phone) FROM
`customer_ledger` WHERE cust_phone IN (SELECT cust_phone FROM
customer_ledger where DATE(last_visit)=CURRENT_DATE()-1) GROUP BY res_id,b_id
I need to put the same Insert query on any other way automatically. I don't have enough knowledge in triggers and stored procedure. Remember I need everyday details separately to show in the table
php mysql
asked Jan 3 at 6:08
RamRam
397
add a comment |
I was used events to insert my query to every hour finding average(that was calculated by the number of customer cames today and their respective total arrives from the beginning). Events successfully run and insert every hour needed values successfully on my localhost. But the main problem is to load the event into Server Db because our service provider refused to ON Superprevilages. Now I need to find another solution instead of event
this is my query on the event can we try any other way?
CREATE EVENT average_visiter
ON SCHEDULE
EVERY 1 DAY
STARTS '2014-04-30 00:20:00' ON COMPLETION PRESERVE ENABLE
DO
INSERT INTO `test_table`( `res_id`, `b_id`, `total_visit`, `tota_count`)
SELECT res_id,b_id,sum(total_visit),count(cust_phone) FROM
`customer_ledger` WHERE cust_phone IN (SELECT cust_phone FROM
customer_ledger where DATE(last_visit)=CURRENT_DATE()-1) GROUP BY res_id,b_id
I need to put the same Insert query on any other way automatically. I don't have enough knowledge in triggers and stored procedure. Remember I need everyday details separately to show in the table
php mysql
asked Jan 3 at 6:08
RamRam
397
add a comment |
I was used events to insert my query to every hour finding average(that was calculated by the number of customer cames today and their respective total arrives from the beginning). Events successfully run and insert every hour needed values successfully on my localhost. But the main problem is to load the event into Server Db because our service provider refused to ON Superprevilages. Now I need to find another solution instead of event
this is my query on the event can we try any other way?
CREATE EVENT average_visiter
ON SCHEDULE
EVERY 1 DAY
STARTS '2014-04-30 00:20:00' ON COMPLETION PRESERVE ENABLE
DO
INSERT INTO `test_table`( `res_id`, `b_id`, `total_visit`, `tota_count`)
SELECT res_id,b_id,sum(total_visit),count(cust_phone) FROM
`customer_ledger` WHERE cust_phone IN (SELECT cust_phone FROM
customer_ledger where DATE(last_visit)=CURRENT_DATE()-1) GROUP BY res_id,b_id
I need to put the same Insert query on any other way automatically. I don't have enough knowledge in triggers and stored procedure. Remember I need everyday details separately to show in the table
php mysql
asked Jan 3 at 6:08
RamRam
397
I was used events to insert my query to every hour finding average(that was calculated by the number of customer cames today and their respective total arrives from the beginning). Events successfully run and insert every hour needed values successfully on my localhost. But the main problem is to load the event into Server Db because our service provider refused to ON Superprevilages. Now I need to find another solution instead of event
this is my query on the event can we try any other way?
CREATE EVENT average_visiter
ON SCHEDULE
EVERY 1 DAY
STARTS '2014-04-30 00:20:00' ON COMPLETION PRESERVE ENABLE
DO
INSERT INTO `test_table`( `res_id`, `b_id`, `total_visit`, `tota_count`)
SELECT res_id,b_id,sum(total_visit),count(cust_phone) FROM
`customer_ledger` WHERE cust_phone IN (SELECT cust_phone FROM
customer_ledger where DATE(last_visit)=CURRENT_DATE()-1) GROUP BY res_id,b_id
I need to put the same Insert query on any other way automatically. I don't have enough knowledge in triggers and stored procedure. Remember I need everyday details separately to show in the table
php mysql
php mysql
asked Jan 3 at 6:08
RamRam
397
asked Jan 3 at 6:08
RamRam
397
asked Jan 3 at 6:08
RamRam
397
asked Jan 3 at 6:08
RamRam
397
asked Jan 3 at 6:08
RamRam
397
397
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
I was used a trigger instead of Event
USE feetobristo;
DELIMITER $$
DROP TRIGGER IF EXISTS feetobristo.customer_ledger_AFTER_INSERT$$
USE `feetobristo`$$
CREATE DEFINER=`feeto`@`localhost` TRIGGER feetobristo.customer_ledger_AFTER_INSERT
AFTER INSERT ON customer_ledger FOR EACH ROW
BEGIN
INSERT INTO test_table( res_id, b_id, total_visit, tota_count)
SELECT res_id,b_id,sum(total_visit),count(cust_phone) FROM
customer_ledger WHERE cust_phone IN (SELECT cust_phone FROM
customer_ledger where DATE(last_visit)=CURRENT_DATE()) GROUP BY res_id,b_id;
END$$
DELIMITER ;
it was worked now fine ta-ta
answered Jan 3 at 7:24
RamRam
397
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54017130%2fproblem-to-gather-previlages-from-server-while-using-eventsservice-provider-say%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I was used a trigger instead of Event
USE feetobristo;
DELIMITER $$
DROP TRIGGER IF EXISTS feetobristo.customer_ledger_AFTER_INSERT$$
USE `feetobristo`$$
CREATE DEFINER=`feeto`@`localhost` TRIGGER feetobristo.customer_ledger_AFTER_INSERT
AFTER INSERT ON customer_ledger FOR EACH ROW
BEGIN
INSERT INTO test_table( res_id, b_id, total_visit, tota_count)
SELECT res_id,b_id,sum(total_visit),count(cust_phone) FROM
customer_ledger WHERE cust_phone IN (SELECT cust_phone FROM
customer_ledger where DATE(last_visit)=CURRENT_DATE()) GROUP BY res_id,b_id;
END$$
DELIMITER ;
it was worked now fine ta-ta
answered Jan 3 at 7:24
RamRam
397
add a comment |
I was used a trigger instead of Event
USE feetobristo;
DELIMITER $$
DROP TRIGGER IF EXISTS feetobristo.customer_ledger_AFTER_INSERT$$
USE `feetobristo`$$
CREATE DEFINER=`feeto`@`localhost` TRIGGER feetobristo.customer_ledger_AFTER_INSERT
AFTER INSERT ON customer_ledger FOR EACH ROW
BEGIN
INSERT INTO test_table( res_id, b_id, total_visit, tota_count)
SELECT res_id,b_id,sum(total_visit),count(cust_phone) FROM
customer_ledger WHERE cust_phone IN (SELECT cust_phone FROM
customer_ledger where DATE(last_visit)=CURRENT_DATE()) GROUP BY res_id,b_id;
END$$
DELIMITER ;
it was worked now fine ta-ta
answered Jan 3 at 7:24
RamRam
397
add a comment |
I was used a trigger instead of Event
USE feetobristo;
DELIMITER $$
DROP TRIGGER IF EXISTS feetobristo.customer_ledger_AFTER_INSERT$$
USE `feetobristo`$$
CREATE DEFINER=`feeto`@`localhost` TRIGGER feetobristo.customer_ledger_AFTER_INSERT
AFTER INSERT ON customer_ledger FOR EACH ROW
BEGIN
INSERT INTO test_table( res_id, b_id, total_visit, tota_count)
SELECT res_id,b_id,sum(total_visit),count(cust_phone) FROM
customer_ledger WHERE cust_phone IN (SELECT cust_phone FROM
customer_ledger where DATE(last_visit)=CURRENT_DATE()) GROUP BY res_id,b_id;
END$$
DELIMITER ;
it was worked now fine ta-ta
answered Jan 3 at 7:24
RamRam
397
I was used a trigger instead of Event
USE feetobristo;
DELIMITER $$
DROP TRIGGER IF EXISTS feetobristo.customer_ledger_AFTER_INSERT$$
USE `feetobristo`$$
CREATE DEFINER=`feeto`@`localhost` TRIGGER feetobristo.customer_ledger_AFTER_INSERT
AFTER INSERT ON customer_ledger FOR EACH ROW
BEGIN
INSERT INTO test_table( res_id, b_id, total_visit, tota_count)
SELECT res_id,b_id,sum(total_visit),count(cust_phone) FROM
customer_ledger WHERE cust_phone IN (SELECT cust_phone FROM
customer_ledger where DATE(last_visit)=CURRENT_DATE()) GROUP BY res_id,b_id;
END$$
DELIMITER ;
it was worked now fine ta-ta
answered Jan 3 at 7:24
RamRam
397
answered Jan 3 at 7:24
RamRam
397
answered Jan 3 at 7:24
RamRam
397
answered Jan 3 at 7:24
RamRam
397
397
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54017130%2fproblem-to-gather-previlages-from-server-while-using-eventsservice-provider-say%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
