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

You can view the mysql manual online. Different viewing options are available at: http://www.mysql.com/documentation/index.html I downloaded the PDF file and have shortcut to it on my desktop. The create page is at: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#CREATE_TABLE

I posted the answer to your last posting. Look there. I might as well type it again. To create a concantenated Primary Key you type both fields inside parenthesis seaparated by a comma. Example: PRIMARY KEY (FIELD1, FIELD2) If this is your last statement then you need to add the second closing parenthesis. I'm actually using S\SQL in a mainframe environment, but this syntax should be the same on any system.