Click here to Skip to main content
15,506,757 members
Home / Discussions / Database
   

Database

 
AnswerRe: MYSQL TABLE RECORDS TO ARRAY Pin
Eddy Vluggen15-Feb-15 9:18
professionalEddy Vluggen15-Feb-15 9:18 
AnswerRe: MYSQL TABLE RECORDS TO ARRAY Pin
sanket16415-Feb-15 18:43
sanket16415-Feb-15 18:43 
QuestionSSRS report is not fitting withing Margins Pin
indian14313-Feb-15 14:39
indian14313-Feb-15 14:39 
QuestionEdit SSRS report file Pin
indian14312-Feb-15 15:08
indian14312-Feb-15 15:08 
AnswerRe: Edit SSRS report file Pin
Member 1102161912-Feb-15 20:07
Member 1102161912-Feb-15 20:07 
AnswerRe: Edit SSRS report file Pin
Chris Quinn13-Feb-15 1:25
Chris Quinn13-Feb-15 1:25 
GeneralRe: Edit SSRS report file Pin
indian14313-Feb-15 14:36
indian14313-Feb-15 14:36 
QuestionMYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 3:28
KipkoechE12-Feb-15 3: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 4:26
mveRichard Deeming12-Feb-15 4:26 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 5:06
KipkoechE12-Feb-15 5:06 
GeneralRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 5:20
professionalGuyThiebaut12-Feb-15 5:20 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 5:27
KipkoechE12-Feb-15 5:27 
QuestionRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 5:33
professionalGuyThiebaut12-Feb-15 5:33 
GeneralRe: MYSQL RANKING IN A VIEW Pin
Richard Deeming12-Feb-15 5:34
mveRichard Deeming12-Feb-15 5:34 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 5:53
KipkoechE12-Feb-15 5:53 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 6:03
KipkoechE12-Feb-15 6:03 
GeneralRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 6:18
professionalGuyThiebaut12-Feb-15 6:18 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 6:23
KipkoechE12-Feb-15 6:23 
GeneralRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 6:28
professionalGuyThiebaut12-Feb-15 6:28 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 7:05
KipkoechE12-Feb-15 7:05 
QuestionAdd allowance to employee table is wrong or true according to my case Pin
ahmed_sa11-Feb-15 22:52
ahmed_sa11-Feb-15 22:52 
AnswerRe: Add allowance to employee table is wrong or true according to my case Pin
David Mujica12-Feb-15 4:49
David Mujica12-Feb-15 4:49 
AnswerRe: Add allowance to employee table is wrong or true according to my case Pin
Mycroft Holmes12-Feb-15 13:01
professionalMycroft Holmes12-Feb-15 13:01 
QuestionTriggers Pin
Member 1116162511-Feb-15 20:19
Member 1116162511-Feb-15 20:19 
AnswerRe: Triggers Pin
Kornfeld Eliyahu Peter11-Feb-15 20:37
professionalKornfeld Eliyahu Peter11-Feb-15 20: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.