Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

MYSQL Question

Comment:

Hi: im practicing MYSQL. i have a question regarding that. how can i assign primary key for 2 columns(composite primary key) with CREATE command. EX: EMP_ID,EMP_NAME, EMP_DOB,EMP_SAL; NOW I WANT TO MAKE EMP_ID & EMP_NAME AS COMPOSITE PRIMARY KEY. any help is greatly appreciated. thank u Nirav

Reply:

To form a primary key from two concantenated fields, just put them in parenthesis separated by a comma. I.E. PRIMARY KEY (EMP_ID, EMP_NAME) I'm actually using SSQL on a mainframe, but the syntax should be the same regardless.

0

Can anyone explain

Pro*C question

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I'm new to both PHP and MySQL. I've created a simple web database where users can store specific information for different contacts. Of this information that a user can submit is: Desk phonenumber, ho...

Summary: is there a maximum entries that I can enter in a table? because I'm trying to create with a mysql_query(CREATE TABLE etc), it seem to create only a maximum of 8 entries.... ...

Summary: i am trying to retrieve data from a table that i have stored in a database on mysql using php. The database is called test and the table is called personnel. i have tried a php script and i got an...