Questions about mysql-5.7
Read more about mysql-5.7
python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
Kill a procedure triggered by an event automatically
There is a procedure called "daily_feed" as follows:
CREATE /* DEFINER=`micro_bi`@`%` */ PROCEDURE `microservices_bi`.`DAILY_FEED`()
BEGIN
DROP TABLE IF EXISTS abc;
CREATE TABLE abc AS
SELE...
milad bahari javan
Votes: 0
Answers: 0
MySQL 5.7 - Performance of stored procedure
Following on from a question I posted a couple of weeks back, the original question has been resolved but I've got some follow up questions relating to performance.
Firstly, here's an example of the s...
Jason
Votes: 0
Answers: 1
How to use LEFT JOIN and limit result to one row based on a count
Let's say i have 3 tables:
Table 'post'
id
title
0
titleA
1
titleB
2
titleC
Table 'comment'
id
id_post
text
0
1
blaa
1
3
blbb
2
5
blcc
Table 'like'
id
id_comment
vo...
hbdev
Votes: 0
Answers: 2
Cant create procedure in MySql 5.7
I'm racking my head, I can't figure out what the problem is. This SQL code does not work on MySQL 5.7
CREATE PROCEDURE sp_create_message (queue_name VARCHAR(50), data TEXT)
DETERMINISTIC
BEGIN
SE...
TheAvengerCat
Votes: 0
Answers: 1