Click here to Skip to main content
14,736,049 members
Home » Discussions » Database
   

Database

 
SuggestionRe: More than interesting... Pin
Richard Deeming8-Jan-18 8:22
mveRichard Deeming8-Jan-18 8:22 
GeneralRe: More than interesting... Pin
Jörgen Andersson8-Jan-18 10:03
professionalJörgen Andersson8-Jan-18 10:03 
GeneralRe: More than interesting... Pin
Richard Deeming9-Jan-18 2:26
mveRichard Deeming9-Jan-18 2:26 
GeneralRe: More than interesting... Pin
Jörgen Andersson9-Jan-18 9:39
professionalJörgen Andersson9-Jan-18 9:39 
AnswerRe: More than interesting... Pin
jschell1-Jan-18 8:04
Memberjschell1-Jan-18 8:04 
GeneralRe: More than interesting... Pin
Kornfeld Eliyahu Peter1-Jan-18 9:23
professionalKornfeld Eliyahu Peter1-Jan-18 9:23 
GeneralRe: More than interesting... Pin
ZurdoDev8-Jan-18 9:05
professionalZurdoDev8-Jan-18 9:05 
QuestionTrigger value > ? write in different table Pin
brian121026-Dec-17 14:44
Memberbrian121026-Dec-17 14:44 
https://stackoverflow.com/questions/...rts-new-data-t
 
I tried the link above but receiving a syntax error, my is easier then that one.
I have datetime, temperature, and humidity written in a table called tempdata.
I would like to have trigger that if value is above 65 for temperature (float), write to a different table or database called test. 
Then email out when test is modified. 
 
I've been trying phpmyadmin because I'm not good with command line. 
 
I have phpmyadmin 4.5.4
mysql ver 14.14 distrib 5.7.20
python 2.7.12
Ubuntu mate 1.16.2
Gnome 2
Raspberry pi 2
 
Thank You





CREATE TRIGGER TemperatureHigh
AFTER INSERT 
ON RawTemperature FOR EACH ROW
BEGIN
      IF (new.temperature > 65 
      THEN
        INSERT INTO `test`;
        
      END IF;
END

AnswerRe: Trigger value > ? write in different table Pin
Victor Nijegorodov26-Dec-17 23:13
MemberVictor Nijegorodov26-Dec-17 23:13 
AnswerRe: Trigger value > ? write in different table Pin
Richard MacCutchan26-Dec-17 23:41
mveRichard MacCutchan26-Dec-17 23:41 
Rant[REPOST] Trigger value > ? write in different table Pin
Richard Deeming8-Jan-18 8:24
mveRichard Deeming8-Jan-18 8:24 
Questiondata between 1st jan to December 31st of previous year query --no hard coded dates. Pin
sai.201226-Dec-17 11:51
Membersai.201226-Dec-17 11:51 
AnswerRe: data between 1st jan to December 31st of previous year query --no hard coded dates. Pin
Victor Nijegorodov26-Dec-17 23:06
MemberVictor Nijegorodov26-Dec-17 23:06 
AnswerRe: data between 1st jan to December 31st of previous year query --no hard coded dates. Pin
Chris Quinn27-Dec-17 1:01
MemberChris Quinn27-Dec-17 1:01 
AnswerRe: data between 1st jan to December 31st of previous year query --no hard coded dates. Pin
jschell1-Jan-18 8:11
Memberjschell1-Jan-18 8:11 
Rant[REPOST] data between 1st jan to December 31st of previous year query --no hard coded dates. Pin
Richard Deeming8-Jan-18 8:27
mveRichard Deeming8-Jan-18 8:27 
QuestionOLE DB Data Types to C# Data Type Mapping Pin
User9874325-Dec-17 18:55
professionalUser9874325-Dec-17 18:55 
AnswerRe: OLE DB Data Types to C# Data Type Mapping Pin
Richard MacCutchan25-Dec-17 21:55
mveRichard MacCutchan25-Dec-17 21:55 
AnswerRe: OLE DB Data Types to C# Data Type Mapping Pin
Mycroft Holmes25-Dec-17 22:33
professionalMycroft Holmes25-Dec-17 22:33 
GeneralRe: OLE DB Data Types to C# Data Type Mapping Pin
User9874325-Dec-17 23:57
professionalUser9874325-Dec-17 23:57 
GeneralRe: OLE DB Data Types to C# Data Type Mapping Pin
jschell26-Dec-17 8:39
Memberjschell26-Dec-17 8:39 
GeneralRe: OLE DB Data Types to C# Data Type Mapping Pin
User9874314-Jan-18 11:44
professionalUser9874314-Jan-18 11:44 
SuggestionRe: OLE DB Data Types to C# Data Type Mapping Pin
Richard Deeming8-Jan-18 8:38
mveRichard Deeming8-Jan-18 8:38 
GeneralRe: OLE DB Data Types to C# Data Type Mapping Pin
User9874314-Jan-18 11:50
professionalUser9874314-Jan-18 11:50 
QuestionT-SQL and denomalization of Parent and Child hierarchy Tables Pin
Member 1358789920-Dec-17 22:41
MemberMember 1358789920-Dec-17 22:41 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.