Click here to Skip to main content
16,016,076 members
Home / Discussions / Database
   

Database

 
GeneralRe: integration of flash to javadb Pin
Richard Deeming26-Feb-17 23:43
mveRichard Deeming26-Feb-17 23:43 
QuestionGetting data Pin
Member 1302296325-Feb-17 0:23
Member 1302296325-Feb-17 0:23 
AnswerRe: Getting data Pin
Richard MacCutchan25-Feb-17 20:48
mveRichard MacCutchan25-Feb-17 20:48 
Questionc# to call MySQL Update Stored Proc error Pin
jonmy24-Feb-17 0:00
jonmy24-Feb-17 0:00 
AnswerRe: c# to call MySQL Update Stored Proc error Pin
Richard Deeming24-Feb-17 0:26
mveRichard Deeming24-Feb-17 0:26 
GeneralRe: c# to call MySQL Update Stored Proc error Pin
jonmy24-Feb-17 0:37
jonmy24-Feb-17 0:37 
QuestionSave a Query as a View issue Pin
john_berman21-Feb-17 11:35
john_berman21-Feb-17 11:35 
AnswerRe: Save a Query as a View issue Pin
Richard Deeming21-Feb-17 12:04
mveRichard Deeming21-Feb-17 12:04 
Every column in a view needs to have a unique name. You've given all four columns the alias "a", which is obviously not unique.

Just remove the four As a alias from the SELECT part of the query, and you should be able to create a view.
SQL
SELECT DISTINCT
    b.event_id,
    b.user_ID,
    b.date,
    b.Time
FROM 
    quadrantids2017 AS a
    JOIN quadrantids2017 AS b
WHERE 
    a.`date` = b.`date`
AND 
    a.user_ID != b.user_ID
AND 
    time_to_sec(a.`Time`) - time_to_sec(b.`Time`) BETWEEN -30 AND 30

Alternatively, give each column a unique alias.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


QuestionTime Variance Query works - Sorry it needs a tweak Pin
john_berman21-Feb-17 9:48
john_berman21-Feb-17 9:48 
QuestionMySql Resource Pin
BobbyStrain20-Feb-17 14:12
BobbyStrain20-Feb-17 14:12 
AnswerRe: MySql Resource Pin
Peter Leow20-Feb-17 16:08
professionalPeter Leow20-Feb-17 16:08 
QuestionTricky Query that includes a time difference Pin
john_berman20-Feb-17 6:09
john_berman20-Feb-17 6:09 
AnswerRe: Tricky Query that includes a time difference Pin
Richard MacCutchan20-Feb-17 6:22
mveRichard MacCutchan20-Feb-17 6:22 
GeneralRe: Tricky Query that includes a time difference Pin
john_berman20-Feb-17 6:45
john_berman20-Feb-17 6:45 
GeneralRe: Tricky Query that includes a time difference Pin
Richard Deeming20-Feb-17 6:52
mveRichard Deeming20-Feb-17 6:52 
GeneralRe: Tricky Query that includes a time difference Pin
john_berman20-Feb-17 7:04
john_berman20-Feb-17 7:04 
GeneralRe: Tricky Query that includes a time difference Pin
john_berman20-Feb-17 7:06
john_berman20-Feb-17 7:06 
QuestionDatabase Design - Help Appreciated Pin
john_berman19-Feb-17 21:03
john_berman19-Feb-17 21:03 
AnswerRe: Database Design - Help Appreciated Pin
Mycroft Holmes19-Feb-17 21:38
professionalMycroft Holmes19-Feb-17 21:38 
GeneralRe: Database Design - Help Appreciated Pin
john_berman20-Feb-17 6:07
john_berman20-Feb-17 6:07 
QuestionDB Case Sensitivity, unexpected/surprising behaviour Pin
User 1106097918-Feb-17 1:17
User 1106097918-Feb-17 1:17 
AnswerRe: DB Case Sensitivity, unexpected/surprising behaviour Pin
Richard Deeming18-Feb-17 1:35
mveRichard Deeming18-Feb-17 1:35 
PraiseRe: DB Case Sensitivity, unexpected/surprising behaviour Pin
User 1106097918-Feb-17 1:40
User 1106097918-Feb-17 1:40 
GeneralRe: DB Case Sensitivity, unexpected/surprising behaviour Pin
User 1106097918-Feb-17 3:49
User 1106097918-Feb-17 3:49 
GeneralRe: DB Case Sensitivity, unexpected/surprising behaviour Pin
Richard Deeming18-Feb-17 8:30
mveRichard Deeming18-Feb-17 8:30 

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.