Member Avatar for tryingtofindout 
1.
      CREATE TABLE details (
   2.
      s_no int NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3.
       
   4.
      content1sno varchar(50) NOT NULL,
   5.
       
   6.
      content1name varchar(50) NOT NULL
   7.
       
   8.
      content2sno varchar(50) NOT NULL,
   9.
       
  10.
      content2name varchar(50) NOT NULL,
  11.
       
  12.
      content3sno varchar(50) NOT NULL,
  13.
       
  14.
      content3name varchar(50) NOT NULL,
  15.
       
  16.
      ) type=MyISAM;
Edited by tryingtofindout because: n/a
  • 1 Contributor
  • 1 Reply
  • 72 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by tryingtofindout
Member Avatar for tryingtofindout

Here in this sql query s_no is declared as primary key, so it is unique.
There is no chance of adding the same serial no again in s_no. Apart from that it is given as auto increment, so absolutely no chance of having same serial no again

What i need here is content1sno, content2sno, content3sno should also be unique;;;it will have both integers and characters 'varchar';;

For example:
If in insert operation, the following value is inserted
content1sno=QW78
content2sno=WE23
content3sno=12AB

In the second insert operation, if the value 12AB is given as input to content1sno=12AB. It should display an error as the same value is given as input to content3sno already.


In the php, during insert operation it should check the database if the value going to be inserted is unique for this three


content1sno=QW78
content2sno=WE23
content3sno=12AB

this three should be unique!!


Why i need this is, it will help me in search operation.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.