Can we create the table with more than 2 Long datatype fields in MYSQL ?

[hanu@mumbai]

The above condition is the must. I want to create table with more than one LONG datatype and declare the two LONG fields as a Primary Key also. (Option is we create the table in PL/SQL or MYSQL with ORACLE10g features are also used). how can i create the table & primary key ?

[dhvrm]

MySQL doesn't have a LONG datatype. It has a LONGTEXT data type and a LONGBLOB data type, either of which would correspond to a LONG in PL/SQL.

Assuming, therefore, you want to create a table that has three columns: two LONGTEXT columns which will be combined to a single primary key, and a third INT column with a length of 11:

CREATE TABLE mytable
column1 LONGTEXT,
column2 LONGTEXT,
column3 INT(11)
PRIMARY KEY (column1, column2) ;

[bow4bass]

two long fields isnt your problem, u cant have two primary keys for one table

make one primary and index the other for searching