Member Avatar for krthk_sg

hi ppl,i have a question.I have column which is a primary key.i have inserted a value also to it.Now again if i insert the same value it shouls not give a error.but instead continue.So how to go about it.like vb onerror is there any way that we can write the script in mysql or shell programming do reply quickly.

  • 3 Contributors
  • 2 Replies
  • 100 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by tinamary

Recommended Answers

All 2 Replies

Member Avatar for leelee

I have no idea what you're asking, sorry.

Member Avatar for tinamary

hi
primary keys are meant to be unique in database, if you want to insert the same value again in the column and not get errors, then you should use surrogate key.
"surrogate key is the substitution of the primary key"
so in order to include your value again in the table, please see to that the other columns , that non attribute key should have changes or which requires updatation and keep the old values in the table.
this method will not give any error for sure.

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.