Click here to Skip to main content
14,302,218 members
   

Database

 
AnswerRe: peak hours query Pin
S Douglas4-Mar-13 9:49
professionalS Douglas4-Mar-13 9:49 
QuestionProblem closing patient file! Pin
Jassim Rahma2-Mar-13 21:34
memberJassim Rahma2-Mar-13 21:34 
AnswerRe: Problem closing patient file! Pin
Joezer BH2-Mar-13 21:50
professionalJoezer BH2-Mar-13 21:50 
GeneralRe: Problem closing patient file! Pin
Jassim Rahma2-Mar-13 22:24
memberJassim Rahma2-Mar-13 22:24 
GeneralRe: Problem closing patient file! Pin
Joezer BH2-Mar-13 22:29
professionalJoezer BH2-Mar-13 22:29 
AnswerRe: Problem closing patient file! Pin
Sandeep Mewara2-Mar-13 21:59
mentorSandeep Mewara2-Mar-13 21:59 
GeneralRe: Problem closing patient file! Pin
Jassim Rahma2-Mar-13 22:26
memberJassim Rahma2-Mar-13 22:26 
GeneralRe: Problem closing patient file! Pin
Sandeep Mewara2-Mar-13 22:44
mentorSandeep Mewara2-Mar-13 22:44 
Jassim Rahma wrote:
`created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

This is the issue. You have set the field 'create_date' to be updated to current timestamp on any update - Wrong and not needed in your case.

Just keep it:
-- If you are not updating this field on record creation
 `created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON INSERT CURRENT_TIMESTAMP,

-- If you are updating the field on record creation
`created_date` timestamp DEFAULT NULL,

Pick that you need and apply.

As per other comment of MySQL, you can use NOW()
Sandeep Mewara
Microsoft ASP.NET MVP 2012 & 2013

[My Blog]: Sandeep Mewara's Tech Journal!
[My Latest Article]: HTML5 Quick Start Web Application

AnswerRe: Problem closing patient file! Pin
gvprabu3-Mar-13 22:18
membergvprabu3-Mar-13 22:18 
QuestionSQLExpress scripted install Pin
loctrice2-Mar-13 0:26
professionalloctrice2-Mar-13 0:26 
AnswerRe: SQLExpress scripted install Pin
loctrice2-Mar-13 2:35
professionalloctrice2-Mar-13 2:35 
Generaldatabase Pin
Kapilkp1-Mar-13 0:16
memberKapilkp1-Mar-13 0:16 
GeneralRe: database Pin
Richard MacCutchan1-Mar-13 0:58
protectorRichard MacCutchan1-Mar-13 0:58 
GeneralHomework Pin
David Mujica1-Mar-13 3:31
memberDavid Mujica1-Mar-13 3:31 
GeneralRe: Homework Pin
Richard MacCutchan1-Mar-13 3:33
protectorRichard MacCutchan1-Mar-13 3:33 
GeneralRe: database Pin
Mycroft Holmes1-Mar-13 11:57
memberMycroft Holmes1-Mar-13 11:57 
QuestionRestrict user to delete database object in SQL SERVER 2005 Pin
LTMKH28-Feb-13 19:49
memberLTMKH28-Feb-13 19:49 
AnswerRe: Restrict user to delete database object in SQL SERVER 2005 Pin
Eddy Vluggen1-Mar-13 5:01
mveEddy Vluggen1-Mar-13 5:01 
AnswerRe: Restrict user to delete database object in SQL SERVER 2005 Pin
gvprabu2-Mar-13 1:56
membergvprabu2-Mar-13 1:56 
GeneralRe: Restrict user to delete database object in SQL SERVER 2005 Pin
LTMKH28-Mar-13 5:20
memberLTMKH28-Mar-13 5:20 
QuestionHelp for RSA ...plzzz Pin
shahbaz_llm28-Feb-13 7:19
membershahbaz_llm28-Feb-13 7:19 
Questionsql server table records to sqlite Pin
jojoba201127-Feb-13 18:23
memberjojoba201127-Feb-13 18:23 
AnswerRe: sql server table records to sqlite Pin
_Damian S_27-Feb-13 18:35
professional_Damian S_27-Feb-13 18:35 
QuestionRe: sql server table records to sqlite Pin
jojoba201127-Feb-13 18:40
memberjojoba201127-Feb-13 18:40 
AnswerRe: sql server table records to sqlite Pin
_Damian S_27-Feb-13 18:51
professional_Damian S_27-Feb-13 18: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.