SQL Custom Upload Question

[Mapantz]

Is it possible for CMX to insert data in to two different table names at the same interval?

I had an idea I wanted to try out, but I am already using seconds/minutes interval in the custom uploads.

[BigOkie]

Is it possible for CMX to insert data in to two different table names at the same interval?

I had an idea I wanted to try out, but I am already using seconds/minutes interval in the custom uploads.

I don't think it would be CMX's function to do this; if you're using a custom can you string two insert statements into the same command? I don't know. Now I need to research this. Not saying this couldn't be done but it's not up to CMX I would think. It's up to MySQL and the ability to concatenate insert statements to do this.

EDIT: It appears you can't do this (concatenate insert commands) however you do it as a transaction. I'm sure that keeping the semicolons where they need to be for this could work, but I don't have enough tables to do this. Here's what I found as an example:

Code: Select all

BEGIN;
INSERT INTO users (username, password)
  VALUES('test', 'test');
INSERT INTO profiles (userid, bio, homepage) 
  VALUES(LAST_INSERT_ID(),'Hello world!', 'http://www.stackoverflow.com');
COMMIT;

Don't use line breaks and just make it all one line keeping the semicolons where they are and I would think it could work.

It would look something like this:

Code: Select all

BEGIN; INSERT INTO users (username, password) VALUES('test', 'test'); INSERT INTO profiles (userid, bio, homepage) VALUES(LAST_INSERT_ID(),'Hello world!', 'http://www.stackoverflow.com'); COMMIT;

[picca]

What about using mysql trigger (https://dev.mysql.com/doc/refman/5.7/en ... igger.html)?

If you use phpMyAdmin to manage your mysql database you can use "Trigger" function:

For example...
AFTER "Realtime" get updated -> INSERT new data in "Lastime" table.


(Sorry for my bad english)

[mcrossley]

You can just put two insert statements in the Custom SQL field - just make sure you put a semi-colon after the first statement and before the second.
I used to do that, I had an Insert and a Delete in the Custom SQL field.

[freddie]

You can just put two insert statements in the Custom SQL field - just make sure you put a semi-colon after the first statement and before the second.
I used to do that, I had an Insert and a Delete in the Custom SQL field.

That is exactly what I do for my ExtraRealtime table that contains my grass temperature and depth temperature from my Ecowitt sensors. it does work.

[Mapantz]

You can just put two insert statements in the Custom SQL field - just make sure you put a semi-colon after the first statement and before the second.
I used to do that, I had an Insert and a Delete in the Custom SQL field.

Bingo!

Working a treat.

Thank you for the replies.