Click here to Skip to main content
15,850,214 members
Home / Discussions / Database
   

Database

 
QuestionRe: Powershell backup and restore SQLscripts Pin
Eddy Vluggen3-Sep-15 9:28
professionalEddy Vluggen3-Sep-15 9:28 
QuestionAbout Triggers Pin
dili12341-Sep-15 21:18
dili12341-Sep-15 21:18 
AnswerRe: About Triggers Pin
GuyThiebaut1-Sep-15 23:18
professionalGuyThiebaut1-Sep-15 23:18 
GeneralRe: About Triggers Pin
dili12347-Sep-15 21:28
dili12347-Sep-15 21:28 
QuestionComposite Key Pin
Gilbert Consellado31-Aug-15 23:26
professionalGilbert Consellado31-Aug-15 23:26 
AnswerRe: Composite Key Pin
Eddy Vluggen1-Sep-15 0:02
professionalEddy Vluggen1-Sep-15 0:02 
GeneralRe: Composite Key Pin
Gilbert Consellado1-Sep-15 0:39
professionalGilbert Consellado1-Sep-15 0:39 
GeneralRe: Composite Key Pin
Eddy Vluggen1-Sep-15 1:18
professionalEddy Vluggen1-Sep-15 1:18 
Gilbert Consellado wrote:
But why MySQL accept this query
..because it defines a single key, which happens to consist of two fields. It is still a single primary key.

Gilbert Consellado wrote:
what are you referring about "design-error"?
I mean that there can only be one "primary".

Having multiple fields in a primary key is quite common. Yes, a larger key has a slight performance penalty; it has to check more data than in a single field, and any index containing the key will also grow.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

GeneralRe: Composite Key Pin
Gilbert Consellado1-Sep-15 1:38
professionalGilbert Consellado1-Sep-15 1:38 
GeneralRe: Composite Key Pin
Eddy Vluggen1-Sep-15 2:37
professionalEddy Vluggen1-Sep-15 2:37 
GeneralRe: Composite Key Pin
Gilbert Consellado1-Sep-15 4:04
professionalGilbert Consellado1-Sep-15 4:04 
GeneralRe: Composite Key Pin
Eddy Vluggen1-Sep-15 4:33
professionalEddy Vluggen1-Sep-15 4:33 
GeneralRe: Composite Key Pin
Tim Carmichael1-Sep-15 3:15
Tim Carmichael1-Sep-15 3:15 
GeneralRe: Composite Key Pin
Gilbert Consellado1-Sep-15 4:08
professionalGilbert Consellado1-Sep-15 4:08 
GeneralRe: Composite Key Pin
Tim Carmichael1-Sep-15 4:59
Tim Carmichael1-Sep-15 4:59 
AnswerRe: Composite Key Pin
Wendelius1-Sep-15 4:07
mentorWendelius1-Sep-15 4:07 
GeneralRe: Composite Key Pin
Gilbert Consellado1-Sep-15 4:41
professionalGilbert Consellado1-Sep-15 4:41 
GeneralRe: Composite Key Pin
Wendelius1-Sep-15 20:32
mentorWendelius1-Sep-15 20:32 
AnswerRe: Composite Key Pin
Mycroft Holmes1-Sep-15 13:54
professionalMycroft Holmes1-Sep-15 13:54 
QuestionKnowing if connection failed to sql server in C# Pin
pluss425-Aug-15 22:46
pluss425-Aug-15 22:46 
AnswerRe: Knowing if connection failed to sql server in C# Pin
Jörgen Andersson25-Aug-15 23:25
professionalJörgen Andersson25-Aug-15 23:25 
SuggestionRe: Knowing if connection failed to sql server in C# Pin
Richard Deeming26-Aug-15 3:20
mveRichard Deeming26-Aug-15 3:20 
GeneralRe: Knowing if connection failed to sql server in C# Pin
Jörgen Andersson26-Aug-15 3:43
professionalJörgen Andersson26-Aug-15 3:43 
GeneralRe: Knowing if connection failed to sql server in C# Pin
pluss426-Aug-15 9:08
pluss426-Aug-15 9:08 
Questionquestion for my new project Pin
turion8722-Aug-15 6:09
turion8722-Aug-15 6:09 

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.