Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
What Happens If Unique Value Constraints Are Violated
What Happens If Unique Value Constraints Are Violated? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements
✍: FYIcenter.com
If you are inserting a new record that has values violating a unique constraint, you will get an error. Note that primary key column has a unique value constraint by default. The following tutorial exercise gives you some good examples:
mysql> INSERT INTO fyi_links (url) VALUES ('www.other.com'); ERROR 1062 (23000): Duplicate entry '0' for key 1 mysql> INSERT INTO fyi_links VALUES (101, 'sql.fyicenter.com', NULL, 0, '2006-04-30'); ERROR 1062 (23000): Duplicate entry '101' for key 1
2007-05-11, 4935👍, 0💬
Popular Posts:
How To Analyze Tables with "mysqlcheck"? - MySQL FAQs - Administrator Tools for Managing MySQL Serve...
How To Calculate Expressions with SQL Statements? - MySQL FAQs - Introduction to SQL Basics There is...
What is the difference between Class and structure’s ? Following are the key differences between the...
.NET INTERVIEW QUESTIONS - How to prevent my .NET DLL to be decompiled? By design .NET embeds rich M...
What is NullPointerException and how to handle it? When an object is not initialized, the default va...