Click here to Skip to main content
15,442,754 members
Home / Discussions / Database
   

Database

 
AnswerRe: MYSQL TABLE RECORDS TO ARRAY Pin
Eddy Vluggen15-Feb-15 8:18
professionalEddy Vluggen15-Feb-15 8:18 
AnswerRe: MYSQL TABLE RECORDS TO ARRAY Pin
sanket16415-Feb-15 17:43
Membersanket16415-Feb-15 17:43 
QuestionSSRS report is not fitting withing Margins Pin
indian14313-Feb-15 13:39
Memberindian14313-Feb-15 13:39 
QuestionEdit SSRS report file Pin
indian14312-Feb-15 14:08
Memberindian14312-Feb-15 14:08 
AnswerRe: Edit SSRS report file Pin
Member 1102161912-Feb-15 19:07
MemberMember 1102161912-Feb-15 19:07 
AnswerRe: Edit SSRS report file Pin
Chris Quinn13-Feb-15 0:25
MemberChris Quinn13-Feb-15 0:25 
GeneralRe: Edit SSRS report file Pin
indian14313-Feb-15 13:36
Memberindian14313-Feb-15 13:36 
QuestionMYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 2:28
MemberKipkoechE12-Feb-15 2:28 
is it possible to create a view in mysql with ranking row?
I tried the following:
CREATE VIEW MYVIEW AS SELECT `SAdmNo`, `Average`, CASE WHEN @PREVRANK=`Average` THEN @CURRANK WHEN @PREVRANK :=`Average` THEN @CURRANK :=@CURRANK+1 END AS RANK FROM `total_termaverage_view`, (SELECT @CURRANK :=0,@PREVRANK :=NULL)R ORDER BY `Average` DESC ;

and got the following:#1351 - View's SELECT contains a variable or parameter
AnswerRe: MYSQL RANKING IN A VIEW Pin
Richard Deeming12-Feb-15 3:26
mveRichard Deeming12-Feb-15 3:26 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 4:06
MemberKipkoechE12-Feb-15 4:06 
GeneralRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 4:20
professionalGuyThiebaut12-Feb-15 4:20 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 4:27
MemberKipkoechE12-Feb-15 4:27 
QuestionRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 4:33
professionalGuyThiebaut12-Feb-15 4:33 
GeneralRe: MYSQL RANKING IN A VIEW Pin
Richard Deeming12-Feb-15 4:34
mveRichard Deeming12-Feb-15 4:34 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 4:53
MemberKipkoechE12-Feb-15 4:53 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 5:03
MemberKipkoechE12-Feb-15 5:03 
GeneralRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 5:18
professionalGuyThiebaut12-Feb-15 5:18 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 5:23
MemberKipkoechE12-Feb-15 5:23 
GeneralRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 5:28
professionalGuyThiebaut12-Feb-15 5:28 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 6:05
MemberKipkoechE12-Feb-15 6:05 
QuestionAdd allowance to employee table is wrong or true according to my case Pin
ahmed_sa11-Feb-15 21:52
Memberahmed_sa11-Feb-15 21:52 
AnswerRe: Add allowance to employee table is wrong or true according to my case Pin
David Mujica12-Feb-15 3:49
MemberDavid Mujica12-Feb-15 3:49 
AnswerRe: Add allowance to employee table is wrong or true according to my case Pin
Mycroft Holmes12-Feb-15 12:01
professionalMycroft Holmes12-Feb-15 12:01 
QuestionTriggers Pin
Member 1116162511-Feb-15 19:19
MemberMember 1116162511-Feb-15 19:19 
AnswerRe: Triggers Pin
Kornfeld Eliyahu Peter11-Feb-15 19:37
professionalKornfeld Eliyahu Peter11-Feb-15 19:37 

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.