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, 5213👍, 0💬
Popular Posts:
How To Return the Second 5 Rows? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries If yo...
What is page thrashing? Some operating systems (such as UNIX or Windows in enhanced mode) use virtua...
Can Java object be locked down for exclusive use by a given thread? Yes. You can lock an object by p...
Can Two Forms Be Nested? - XHTML 1.0 Tutorials - Understanding Forms and Input Fields Can two forms ...
Describe different elements in Static Chart diagrams ? Package: - It logically groups element of a U...