Click here to Skip to main content
15,894,540 members
Home / Discussions / Database
   

Database

 
AnswerRe: How to decide between mysql and SQL server? Pin
Per Söderlund13-May-16 3:00
Per Söderlund13-May-16 3:00 
GeneralRe: How to decide between mysql and SQL server? Pin
kmllev13-May-16 17:11
kmllev13-May-16 17:11 
AnswerRe: How to decide between mysql and SQL server? Pin
Out of Memory13-May-16 4:53
Out of Memory13-May-16 4:53 
QuestionConfigure SQL 2008 R2 Remote Access Pin
Kevin Marois12-May-16 17:59
professionalKevin Marois12-May-16 17:59 
AnswerRe: Configure SQL 2008 R2 Remote Access Pin
Mycroft Holmes12-May-16 20:36
professionalMycroft Holmes12-May-16 20:36 
GeneralRe: Configure SQL 2008 R2 Remote Access Pin
Kevin Marois13-May-16 5:15
professionalKevin Marois13-May-16 5:15 
QuestionA performance question on SQL Server Active Passive failover Pin
Jörgen Andersson11-May-16 9:32
professionalJörgen Andersson11-May-16 9:32 
Questionview in which each column contains data from a different table Pin
Member 118403637-May-16 16:22
Member 118403637-May-16 16:22 
I am doing a student attendance project in php & mysql.
I have a monthly table for recording attendance of students. the first column in the table is the roll number which is common for all the tables and the dates of each month have a column of their own.
suppose if the attendance is of 5 months, I have 5 tables of the same repeated table.
I want to create a table or view that has columns for showing total of each month with the students roll number i.e. student roll number column, first month total column, second month total column, so on.
Can anyone please help me how to do it in mysql?
AnswerRe: view in which each column contains data from a different table Pin
Mycroft Holmes7-May-16 17:55
professionalMycroft Holmes7-May-16 17:55 
GeneralRe: view in which each column contains data from a different table Pin
Member 118403637-May-16 18:09
Member 118403637-May-16 18:09 
GeneralRe: view in which each column contains data from a different table Pin
Mycroft Holmes7-May-16 18:33
professionalMycroft Holmes7-May-16 18:33 
GeneralRe: view in which each column contains data from a different table Pin
Jörgen Andersson8-May-16 19:58
professionalJörgen Andersson8-May-16 19:58 
GeneralRe: view in which each column contains data from a different table Pin
Member 118403639-May-16 4:37
Member 118403639-May-16 4:37 
GeneralRe: view in which each column contains data from a different table Pin
Eddy Vluggen9-May-16 4:52
professionalEddy Vluggen9-May-16 4:52 
GeneralRe: view in which each column contains data from a different table Pin
Mycroft Holmes9-May-16 14:11
professionalMycroft Holmes9-May-16 14:11 
GeneralRe: view in which each column contains data from a different table Pin
CHill608-May-16 13:31
mveCHill608-May-16 13:31 
QuestionQuery Execution Time Management. Pin
Nasir Abbas5-May-16 7:27
Nasir Abbas5-May-16 7:27 
AnswerRe: Query Execution Time Management. Pin
Richard Deeming5-May-16 7:34
mveRichard Deeming5-May-16 7:34 
GeneralRe: Query Execution Time Management. Pin
Nasir Abbas5-May-16 19:41
Nasir Abbas5-May-16 19:41 
GeneralRe: Query Execution Time Management. Pin
Richard Deeming6-May-16 0:53
mveRichard Deeming6-May-16 0:53 
GeneralRe: Query Execution Time Management. Pin
Nasir Abbas8-May-16 23:32
Nasir Abbas8-May-16 23:32 
Questionaddition having null values in between Pin
Member 118403633-May-16 8:22
Member 118403633-May-16 8:22 
AnswerRe: addition having null values in between Pin
Tomas Takac3-May-16 8:59
Tomas Takac3-May-16 8:59 
GeneralRe: addition having null values in between Pin
Member 118403633-May-16 9:18
Member 118403633-May-16 9:18 
GeneralRe: addition having null values in between Pin
Tomas Takac3-May-16 9:51
Tomas Takac3-May-16 9:51 

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.