Posts by Lucas William • 11 points
3 posts
-
0
votes2
answers51
viewsA: How to loop Mysql based on a query
I ended up solving this problem the following way: Note: I am using Mysql 5.6 DELIMITER | CREATE EVENT aggr_all_details_of_orders ON SCHEDULE EVERY 5 MINUTE STARTS NOW() ON COMPLETION NOT PRESERVE…
-
0
votes1
answer40
viewsA: Ajax is not returning json in the html table
I think the problem may be in your header, try this: $.ajax({ url: "http://exemplo/exemplo/exemplo/exemplo/exemplo/", headers: { 'Content-Type': 'application/json' }, dataType: 'json', type: 'get',…
-
1
votes2
answers51
viewsQ: How to loop Mysql based on a query
I wonder if it is possible to create an event in the Mysql database, where every 5 minutes the database makes a query, where it returns all the order ids and based on each id I perform another query…