sql - Mysql: How do you create a table with multiple primary keys? -

-

मेरे पास यह स्थिति है:

(तालिका वेतन )

आप एकाधिक प्राथमिक कुंजी के साथ एक तालिका कैसे बना सकते हैं? 

  तालिका वेतन बनाना (dep_id छोटी-छोटी ऑटो_इनक्रियम प्राथमिक कुंजी, emp_id छोटी-छोटी ऑटो_इनक्रिमेंट प्राथमिक कुंजी, bla varchar (20 ));

अगर मैं उपरोक्त कोड की कोशिश करता हूं तो मुझे एक त्रुटि मिलती है किसी भी विचार?

एक तालिका में केवल एक प्राथमिक कुंजी हो सकती है हालांकि, प्राथमिक कुंजी में कई कॉलम शामिल हो सकते हैं, उदाहरण के लिए 

  सब्सक्राइबर के वेतन (डिपाइड स्किलिंग अनअंसेंटेड नल, ए_आईड स्माललिंग अनसैंटेड नल, ब्लॉ VARCHAR (20), प्राइमरी की (डिपा_आईडी, एएनआईडी) ));

Comments

Post a Comment

Popular posts from this blog

ios - Form Sheet content disappearing -

-
Image
I am trying to apply a form sheet. Looks like this on the storyboard: App background only when I run Appears and everything else is hidden. I am presenting a form sheet using model sheets - I am working with the form sheet and I (WREGLR Regular) size. Why is this happening?
Read more

Lists in scheme -

-
I am trying to write a function in the plan that takes every item list and class in the list, then returns the list As is (list xyz) . However, I'm not sure how to write a code that would do this. So far, I have (defined (category = list list) (cond [(empty? List) false) [and (list (SQL) (first A-list)) (Square-list) (The rest is a list)))]) but it returns to the list (cons y (cons z empty)) What can I do to return it to the list only in (list xyz) ? Thanks! You're almost there - make sure you type cons and List (The text book explains this section 13. You can find copies online). Conflict The first element for the 'rest' part and (usually) one (potentially empty) list as an example, (Opposition 1 blank) Number 1 as its first element and the empty list is in the form of 'rest' (Opposition 1 (Opposition 2 Empty)) No. 1 before Element, and (Opposition 2 empty) is in the form of 'rest'. List is just a simple shorth...
Read more

List View in C# -

-
I have a ListView in my C # and I want to select an item based on the number I give . Is it possible? Example: If my list adds, multiplied and divides as elements in the list, so if I give 2, then it has to be multiplied. All this should be programmatically If this is ListItem value 2 - I just had to go with it: _listView.SelectedValue = "2"; Or maybe more correct: _listView.SelectedValue = _input.ToString ();
Read more