Sfrgttk

Where is the fallacy here?

Why do phishing e-mails use faked e-mail addresses instead of the real one?

Don't know what I’m looking for regarding removable HDDs?

Is there a math equivalent to the conditional ternary operator?

How can atoms be electrically neutral when there is a difference in the positions of the charges?

Toast materialize

Why can't we make a perpetual motion machine by using a magnet to pull up a piece of metal, then letting it fall back down?

The need of reserving one's ability in job interviews

Sometimes a banana is just a banana

Graphing random points on the XY-plane

How to mitigate "bandwagon attacking" from players?

What could trigger powerful quakes on icy world?

How can I create a Table like this in Latex?

Reason why dimensional travelling would be restricted

Can a space-faring robot still function over a billion years?

Citing contemporaneous (interlaced?) preprints

Is the withholding of funding notice allowed?

What is this waxed root vegetable?

A right or the right?

What should the omniscient narrator call a character?

Real life puzzle: Unknown alphabet or shorthand

How to evaluate the limit where something is raised to a power of x?

Can throughput exceed the bandwidth of a network

Inverse of the covariance matrix of a multivariate normal distribution

Create trigger that Find, Parse and Insert to another table After inserting on table

Prevent record from being inserted in the table in After TriggerHow to commit transaction on an after update event trigger?How to get currently inserted rows and sum them within Mysql trigger before insertCreating SQL Server triggers to copy a record from one table and populate anothertrigger to delete records with same value from another table after inserting record in another tableDoes after insert trigger cause delay?MySQL trigger before insert replace the data with relational tableTwo Interconnected MySql Trigger on two different TablesProblems with insert trigger and primary keyMysql trigger to update if date match and insert if no match all BEFORE INSERT

0

I want to create a trigger that will insert to another table after inserting on my table.

Scenario:
I will insert on my inbox table.
Then, on my inbox table there is a field named Msg.
Next, I want to parse the Msg before inserting it.
The data is: su:11:2016-07-18:2:125~1, 124~100

    CREATE TRIGGER account_insert AFTER INSERT ON inbox FOR EACH ROW

BEGIN

    SELECT 

    SPLIT_STR(Msg, ':', '1') AS u,

    SPLIT_STR(Msg, ':', '2') AS o,

    SPLIT_STR(Msg, ':', '3') AS dt,

    SPLIT_STR(Msg, ':', '4') AS t

FROM inbox ORDER BY Datestamp DESC



INSERT ON account (trx_id, user_id, outlet_id, date_captured) VALUES(t, u, o, dt)



END; 

So the output must be like this:

trx_id = 2

user_id = su

outlet_id =11

date_captured = 2016-07-18

I cannot run this on MySQL.

mysql trigger

share|improve this question

edited Jul 20 '16 at 8:31

Philᵀᴹ

25.5k65591

asked Jul 20 '16 at 8:12

John MichaelJohn Michael

1

bumped to the homepage by Community♦ 4 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

0

I want to create a trigger that will insert to another table after inserting on my table.

Scenario:
I will insert on my inbox table.
Then, on my inbox table there is a field named Msg.
Next, I want to parse the Msg before inserting it.
The data is: su:11:2016-07-18:2:125~1, 124~100

    CREATE TRIGGER account_insert AFTER INSERT ON inbox FOR EACH ROW

BEGIN

    SELECT 

    SPLIT_STR(Msg, ':', '1') AS u,

    SPLIT_STR(Msg, ':', '2') AS o,

    SPLIT_STR(Msg, ':', '3') AS dt,

    SPLIT_STR(Msg, ':', '4') AS t

FROM inbox ORDER BY Datestamp DESC



INSERT ON account (trx_id, user_id, outlet_id, date_captured) VALUES(t, u, o, dt)



END; 

So the output must be like this:

trx_id = 2

user_id = su

outlet_id =11

date_captured = 2016-07-18

I cannot run this on MySQL.

mysql trigger

share|improve this question

edited Jul 20 '16 at 8:31

Philᵀᴹ

25.5k65591

asked Jul 20 '16 at 8:12

John MichaelJohn Michael

1

bumped to the homepage by Community♦ 4 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

I want to create a trigger that will insert to another table after inserting on my table.

Scenario:
I will insert on my inbox table.
Then, on my inbox table there is a field named Msg.
Next, I want to parse the Msg before inserting it.
The data is: su:11:2016-07-18:2:125~1, 124~100

    CREATE TRIGGER account_insert AFTER INSERT ON inbox FOR EACH ROW

BEGIN

    SELECT 

    SPLIT_STR(Msg, ':', '1') AS u,

    SPLIT_STR(Msg, ':', '2') AS o,

    SPLIT_STR(Msg, ':', '3') AS dt,

    SPLIT_STR(Msg, ':', '4') AS t

FROM inbox ORDER BY Datestamp DESC



INSERT ON account (trx_id, user_id, outlet_id, date_captured) VALUES(t, u, o, dt)



END; 

So the output must be like this:

trx_id = 2

user_id = su

outlet_id =11

date_captured = 2016-07-18

I cannot run this on MySQL.

mysql trigger

share|improve this question

edited Jul 20 '16 at 8:31

Philᵀᴹ

25.5k65591

asked Jul 20 '16 at 8:12

John MichaelJohn Michael

1

    CREATE TRIGGER account_insert AFTER INSERT ON inbox FOR EACH ROW

BEGIN

    SELECT 

    SPLIT_STR(Msg, ':', '1') AS u,

    SPLIT_STR(Msg, ':', '2') AS o,

    SPLIT_STR(Msg, ':', '3') AS dt,

    SPLIT_STR(Msg, ':', '4') AS t

FROM inbox ORDER BY Datestamp DESC



INSERT ON account (trx_id, user_id, outlet_id, date_captured) VALUES(t, u, o, dt)



END; 

trx_id = 2

user_id = su

outlet_id =11

date_captured = 2016-07-18

share|improve this question

edited Jul 20 '16 at 8:31

Philᵀᴹ

25.5k65591

asked Jul 20 '16 at 8:12

John MichaelJohn Michael

1

share|improve this question

edited Jul 20 '16 at 8:31

Philᵀᴹ

25.5k65591

asked Jul 20 '16 at 8:12

John MichaelJohn Michael

1

edited Jul 20 '16 at 8:31

Philᵀᴹ

25.5k65591

edited Jul 20 '16 at 8:31

Philᵀᴹ

25.5k65591

asked Jul 20 '16 at 8:12

John MichaelJohn Michael

1

asked Jul 20 '16 at 8:12

John MichaelJohn Michael

1

1 Answer
1

active

oldest

votes

0

There is no SPLIT_STR(). But a couple uses of SUBSTRING_INDEX() will do the trick.

share|improve this answer

answered Jul 20 '16 at 21:40

Rick JamesRick James

43.1k22259

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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
});


}
});

draft saved

draft discarded

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

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f144407%2fcreate-trigger-that-find-parse-and-insert-to-another-table-after-inserting-on-t%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

There is no SPLIT_STR(). But a couple uses of SUBSTRING_INDEX() will do the trick.

share|improve this answer

answered Jul 20 '16 at 21:40

Rick JamesRick James

43.1k22259

add a comment | 

0

There is no SPLIT_STR(). But a couple uses of SUBSTRING_INDEX() will do the trick.

share|improve this answer

answered Jul 20 '16 at 21:40

Rick JamesRick James

43.1k22259

add a comment | 

There is no SPLIT_STR(). But a couple uses of SUBSTRING_INDEX() will do the trick.

share|improve this answer

answered Jul 20 '16 at 21:40

Rick JamesRick James

43.1k22259

share|improve this answer

answered Jul 20 '16 at 21:40

Rick JamesRick James

43.1k22259

answered Jul 20 '16 at 21:40

Rick JamesRick James

43.1k22259

answered Jul 20 '16 at 21:40

Rick JamesRick James

43.1k22259