Click here to Skip to main content
15,905,071 members
Home / Discussions / Database
   

Database

 
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 
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 
Ohh I see, thank you.

But why MySQL accept this query

SQL
CREATE TABLE IF NOT EXISTS `tbl_sample`
(
  `tbl_sample_id` INT UNSIGNED NOT NULL,
  `tracked_id` INT UNSIGNED NOT NULL,
  -- other columns goes here,
  PRIMARY KEY (`tbl_sample_id`, `tracked_id`)
)ENGINE = MyISAM


what are you referring about "design-error"? do you mean the design standard or the DBMS itself?

Thank you
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 
QuestionKnowing if connection failed to sql server in C# Pin
pluss425-Aug-15 21:46
pluss425-Aug-15 21:46 
AnswerRe: Knowing if connection failed to sql server in C# Pin
Jörgen Andersson25-Aug-15 22:25
professionalJörgen Andersson25-Aug-15 22:25 
SuggestionRe: Knowing if connection failed to sql server in C# Pin
Richard Deeming26-Aug-15 2:20
mveRichard Deeming26-Aug-15 2:20 
GeneralRe: Knowing if connection failed to sql server in C# Pin
Jörgen Andersson26-Aug-15 2:43
professionalJörgen Andersson26-Aug-15 2:43 
GeneralRe: Knowing if connection failed to sql server in C# Pin
pluss426-Aug-15 8:08
pluss426-Aug-15 8:08 

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.