Click here to Skip to main content
15,945,603 members
Home / Discussions / Database
   

Database

 
GeneralRe: What should be the choice.. MongoDB or Sql Server? Pin
Eddy Vluggen3-Sep-15 10:08
professionalEddy Vluggen3-Sep-15 10:08 
GeneralRe: What should be the choice.. MongoDB or Sql Server? Pin
Jörgen Andersson3-Sep-15 9:16
professionalJörgen Andersson3-Sep-15 9:16 
GeneralRe: What should be the choice.. MongoDB or Sql Server? Pin
Schatak3-Sep-15 20:30
professionalSchatak3-Sep-15 20:30 
GeneralRe: What should be the choice.. MongoDB or Sql Server? Pin
jschell11-Sep-15 12:17
jschell11-Sep-15 12:17 
GeneralRe: What should be the choice.. MongoDB or Sql Server? Pin
Herman<T>.Instance23-Sep-15 0:21
Herman<T>.Instance23-Sep-15 0:21 
QuestionPowershell backup and restore SQLscripts Pin
Stephen Holdorf2-Sep-15 13:01
Stephen Holdorf2-Sep-15 13:01 
QuestionRe: Powershell backup and restore SQLscripts Pin
Eddy Vluggen3-Sep-15 8:28
professionalEddy Vluggen3-Sep-15 8:28 
QuestionAbout Triggers Pin
dili12341-Sep-15 20:18
dili12341-Sep-15 20:18 
This is my first time of creating a trigger..I tried to create trigger using mysql to count how many "2007" data are in the table when inserting new record but it not working properly it wont display how 2007 data are in my table.......

My table have more than 50 data...

CREATE TRIGGER No_of_Publisher_year Before Insert ON Book FOR EACH ROW SET @Count_No=New.Copyright;
SET @Count_NO=0;
INSERT INTO Book VALUES(14,'Programming Perl','978-0-201-70073-2','WI','2007-12-11',25.23,2,2007);
SELECT Count(@Count_NO) AS 'No_of_publisher_in_year_2007' FROM Book WHERE Copyright=2007
AnswerRe: About Triggers Pin
GuyThiebaut1-Sep-15 22:18
professionalGuyThiebaut1-Sep-15 22:18 
GeneralRe: About Triggers Pin
dili12347-Sep-15 20:28
dili12347-Sep-15 20:28 
QuestionComposite Key Pin
Gilbert Consellado31-Aug-15 22:26
professionalGilbert Consellado31-Aug-15 22:26 
AnswerRe: Composite Key Pin
Eddy Vluggen31-Aug-15 23:02
professionalEddy Vluggen31-Aug-15 23:02 
GeneralRe: Composite Key Pin
Gilbert Consellado31-Aug-15 23:39
professionalGilbert Consellado31-Aug-15 23:39 
GeneralRe: Composite Key Pin
Eddy Vluggen1-Sep-15 0:18
professionalEddy Vluggen1-Sep-15 0:18 
GeneralRe: Composite Key Pin
Gilbert Consellado1-Sep-15 0:38
professionalGilbert Consellado1-Sep-15 0:38 
GeneralRe: Composite Key Pin
Eddy Vluggen1-Sep-15 1:37
professionalEddy Vluggen1-Sep-15 1:37 
GeneralRe: Composite Key Pin
Gilbert Consellado1-Sep-15 3:04
professionalGilbert Consellado1-Sep-15 3:04 
GeneralRe: Composite Key Pin
Eddy Vluggen1-Sep-15 3:33
professionalEddy Vluggen1-Sep-15 3:33 
GeneralRe: Composite Key Pin
Tim Carmichael1-Sep-15 2:15
Tim Carmichael1-Sep-15 2:15 
GeneralRe: Composite Key Pin
Gilbert Consellado1-Sep-15 3:08
professionalGilbert Consellado1-Sep-15 3:08 
GeneralRe: Composite Key Pin
Tim Carmichael1-Sep-15 3:59
Tim Carmichael1-Sep-15 3:59 
AnswerRe: Composite Key Pin
Wendelius1-Sep-15 3:07
mentorWendelius1-Sep-15 3:07 
GeneralRe: Composite Key Pin
Gilbert Consellado1-Sep-15 3:41
professionalGilbert Consellado1-Sep-15 3:41 
GeneralRe: Composite Key Pin
Wendelius1-Sep-15 19:32
mentorWendelius1-Sep-15 19:32 
AnswerRe: Composite Key Pin
Mycroft Holmes1-Sep-15 12:54
professionalMycroft Holmes1-Sep-15 12:54 

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.