Skip navigation links

MySQL Forums :: Constraints


Advanced Search

Announcements Last Post
• MySQL Connector/Python 1.0.10 has been released 05/07/2013 12:33AM
• MySQL Connector/J 5.1.25 has been released 05/06/2013 10:30AM
• MySQL Connector/C 6.1.0 has been released 05/02/2013 02:28PM
• MySQL Connector/ODBC 5.2.5 has been released 05/02/2013 02:26PM
• MySQL for Excel 1.1.1 (GA) has been released 04/26/2013 04:33PM
Pages:  1 2 Next
Current Page: 1 of 2
Subject Views Written By Posted
ocl constraint {Xor} check   127 feres feres 04/02/2013 03:27AM
Re: ocl constraint {Xor} check   60 Peter Brawley 04/02/2013 09:19AM
Re: ocl constraint {Xor} check   58 feres feres 04/02/2013 09:26AM
Error: 1557 SQLSTATE: 23000 (ER_FOREIGN_DUPLICATE_KEY) How to fix this issue?   168 Sebastian Schwaiger 03/14/2013 02:18AM
Re: Error: 1557 SQLSTATE: 23000 (ER_FOREIGN_DUPLICATE_KEY) How to fix this issue?   98 Peter Brawley 03/14/2013 05:16PM
Multiply column values   910 Anish Philip 11/08/2012 01:35PM
Re: Multiply column values   355 Devart Team 12/10/2012 01:34AM
Check constraint not working   1,028 Anish Philip 10/27/2012 05:28AM
Re: Check constraint not working   447 Devart Team 10/31/2012 03:08AM
Re: Check constraint not working   421 Anish Philip 10/31/2012 07:22AM
Re: Check constraint not working   527 Devart Team 10/31/2012 09:00AM
Re: Check constraint not working   661 Anish Philip 11/08/2012 01:03PM
Re: Check constraint not working   456 Anish Philip 10/28/2012 03:06PM
Re: Check constraint not working   451 Anish Philip 10/28/2012 03:10PM
Cardinality vs. distinct values   463 Nathan Aschoff 10/09/2012 06:56AM
Re: Cardinality vs. distinct values   197 Devart Team 10/31/2012 03:07AM
Index Type created not same as mentioned in documentation.   592 sachin vyas 08/07/2012 01:20AM
Re: Index Type created not same as mentioned in documentation.   246 Jonathan Stephens 10/09/2012 07:24AM
mysterious DDL failure for PK   416 Foam Pile 08/30/2012 11:12PM
Re: mysterious DDL failure for PK   372 Devart Team 08/31/2012 06:04AM
[solved] ERROR 1170: key length for index on textfield is specified but still this error   1,013 Sebastiaan Nieuwenhuis 05/30/2012 01:39AM
Re: ERROR 1170: key length for index on textfield is specified but still this error   581 Sebastiaan Nieuwenhuis 05/30/2012 01:50AM
duplicate index which has name of foreign key constraint   682 Prabhu Pilli 05/23/2012 06:00PM
Alter PRIMARY KEY   1,171 Auke Middendorp 02/11/2012 10:17AM
Re: Alter PRIMARY KEY   485 Devart Team 05/10/2012 01:28AM
On Functional Dependencies.   1,334 Juan Casanova 01/25/2012 10:26AM
Error 1062 duplicate entry   2,116 zahid quadri 09/29/2011 05:55AM
A Database Error Occurred   1,915 azamazim md noh 09/15/2011 02:49AM
check constraint for fix value in a column   2,588 zahid quadri 08/30/2011 12:40AM
Re: check constraint for fix value in a column   1,504 Devart Team 08/31/2011 12:48AM
Re: check constraint for fix value in a column   1,638 zahid quadri 09/02/2011 12:18AM
Re: check constraint for fix value in a column   1,284 Devart Team 09/02/2011 06:20AM
Re: check constraint for fix value in a column   858 zahid quadri 09/02/2011 06:43AM
Where clause for calculated column   1,503 Howard Cary Morris 08/15/2011 10:32PM
Selecting records that don't match a criteria   2,400 skasab2s skasab2s 07/06/2011 12:27PM
Re: Selecting records that don't match a criteria   751 Shashwat Tripathi 07/18/2011 05:20AM
Multiple column foreign key   1,773 Shashwat Tripathi 07/18/2011 04:54AM
Inconsistent DB - Foreign key constraint fails   2,445 Jan Wedel 05/30/2011 02:01AM
Re: Inconsistent DB - Foreign key constraint fails   991 Devart Team 05/31/2011 12:53AM
Re: Inconsistent DB - Foreign key constraint fails   1,037 Jan Wedel 05/31/2011 04:03AM
Re: Inconsistent DB - Foreign key constraint fails   947 Jan Wedel 05/31/2011 01:11AM
Date and Symbol constraint   1,791 JJJJJJJ JJJJJJJ 04/05/2011 01:19AM
Re: Date and Symbol constraint   773 alex moreno 04/05/2011 02:12PM
Unsigned, AutoIncrement   3,082 Winfried Palm 02/17/2011 07:44AM
Re: Unsigned, AutoIncrement   1,088 Devart Team 02/18/2011 12:13AM
Re: Unsigned, AutoIncrement   1,507 Winfried Palm 02/21/2011 07:18AM
Some sort of constraint needed   1,595 Eddie Lau 02/18/2011 10:11AM
Re: Some sort of constraint needed   872 Peter Brawley 02/18/2011 10:19AM
Re: Some sort of constraint needed   823 Eddie Lau 02/18/2011 11:47AM
This topic has been moved.:  Storing milliseconds in MySQL   10 kaustubh h 01/31/2011 10:45AM
FOREIGN KEY ON UPDATE CASCADE does NOT work with SELF REFERENCE   7,137 Luca Esculapio 10/26/2010 03:29PM
Re: FOREIGN KEY ON UPDATE CASCADE does NOT work with SELF REFERENCE   2,082 Devart Team 12/08/2010 01:37AM
foreign-key / import   2,415 Junior DBA 10/26/2010 11:04AM
Unique constraint on case insensitive varchar column?   7,087 Lifeng Wang 10/10/2010 09:23PM
Re: Unique constraint on case insensitive varchar column?   2,693 Devart Team 10/12/2010 01:09AM
Re: Unique constraint on case insensitive varchar column?   2,504 Lifeng Wang 10/14/2010 02:24PM
Re: Unique constraint on case insensitive varchar column?   2,182 Devart Team 10/15/2010 03:35AM
Re: Unique constraint on case insensitive varchar column?   3,821 Lifeng Wang 10/14/2010 02:15PM
Default value is not used   3,787 Kimberly Rowe 09/01/2010 12:48PM
Re: Default value is not used   1,529 Devart Team 09/02/2010 08:22AM
Re: Default value is not used   1,098 DBA Lead 09/17/2010 08:47AM
Re: Default value is not used   1,223 Devart Team 09/02/2010 01:06AM
Re: Default value is not used   1,194 Kimberly Rowe 09/02/2010 07:32AM
This topic has been moved.:  Strange LOCATE behaviour   7 Ian Channing 08/18/2010 09:22AM
date constraint   4,165 Katja Fink 07/02/2010 04:20AM
Re: date constraint   1,607 Devart Team 07/05/2010 01:23AM
Re: date constraint   1,472 Katja Fink 07/05/2010 01:47AM
Re: date constraint   1,553 Devart Team 07/05/2010 06:08AM
Conditional Constraint   2,216 Susan Hurst 07/04/2010 08:40PM
This topic has been moved.:  Lowest Date / exclude duplicate "value"   136 Adam Ziemba 05/18/2010 09:14AM
This topic has been moved.:  Pivot table with VARCHAR data and mutiple tables joins   23 S C 05/18/2010 09:14AM
This topic has been moved.:  Auto incremnent primary keys   12 Lee-Ann Lee-Ann 04/19/2010 01:47PM
Foreign Key Candidate   3,693 Matt Akers 04/01/2010 06:50PM
Re: Foreign Key Candidate   1,661 Matt Akers 04/06/2010 12:15PM
Re: Foreign Key Candidate   1,598 Saurabh Deshpande 04/14/2010 05:21AM
How to create a table that distinguishes greeks 'ο' from 'ό' on INSERT but considers both identical on SELECT   3,034 Ni Angel 04/10/2010 02:02PM
Re: How to create a table that distinguishes greeks 'ο' from 'ό' on INSERT but considers both identical on SELECT   1,546 Saurabh Deshpande 04/12/2010 04:41AM
Re: How to create a table that distinguishes greeks 'ο' from 'ό' on INSERT but considers both identical on SELECT   1,579 Ni Angel 04/12/2010 01:30PM
Re: How to create a table that distinguishes greeks 'ο' from 'ό' on INSERT but considers both identical on SELECT   1,537 Saurabh Deshpande 04/14/2010 05:12AM
Dual-row primary key and unique constraint   5,288 Ole Nielsby 03/19/2010 01:19PM
Re: Dual-row primary key and unique constraint   1,983 Peter Brawley 03/19/2010 03:58PM
Re: Dual-row primary key and unique constraint   2,186 Ole Nielsby 03/19/2010 07:36PM
Re: Dual-row primary key and unique constraint   1,777 Peter Brawley 04/10/2010 08:14PM
TIMESTAMP + NOT NULL = DEFAULT Value CURRENT_TIMESTAMP ???   12,205 Ilya Khanataev 03/17/2010 04:39PM
Re: TIMESTAMP + NOT NULL = DEFAULT Value CURRENT_TIMESTAMP ???   3,985 Peter Brawley 03/19/2010 04:02PM
Hello   2,934 asef fakih 02/19/2010 02:17AM
Re: Hello   1,513 Peter Brawley 02/19/2010 11:02AM
Restriction based on another column in same table   4,065 Aaron Peachey 02/06/2010 06:01AM
Re: Restriction based on another column in same table   1,958 Peter Brawley 02/06/2010 11:27AM
Re: Restriction based on another column in same table   2,265 Aaron Peachey 02/06/2010 05:36PM
Re: Restriction based on another column in same table   1,801 Peter Brawley 02/19/2010 11:00AM
Increment error.   3,383 Andy Edwards 01/31/2010 12:58PM
Re: Increment error.   1,623 Devart Team 02/01/2010 02:34AM
Not able to create this table with contraint = errno 105   3,712 Steven Mac 01/27/2010 07:51PM
Re: Not able to create this table with contraint = errno 105   1,936 Devart Team 01/28/2010 02:55AM
FOREIGN KEY self reference problem   7,506 Assaf Moldavsky 01/18/2010 06:23PM
Add Foreign Key Constraint Error   10,763 Leon Match 11/11/2009 10:12PM
Re: Add Foreign Key Constraint Error   3,597 Devart Team 12/10/2009 03:24AM
Re: Add Foreign Key Constraint Error   2,905 Leon Match 12/11/2009 07:59PM
Re: Add Foreign Key Constraint Error   2,963 Devart Team 12/09/2009 04:24AM
Re: Add Foreign Key Constraint Error   3,052 Leon Match 12/09/2009 05:27PM
Re: Add Foreign Key Constraint Error   2,809 Leon Match 11/12/2009 05:16PM
Re: Add Foreign Key Constraint Error   3,961 Peter Lemieux 11/16/2009 12:39PM
Re: Add Foreign Key Constraint Error   3,248 Leon Match 12/08/2009 08:35PM
Re: Add Foreign Key Constraint Error   5,050 Devart Team 11/12/2009 05:40AM
Re: Add Foreign Key Constraint Error   3,290 Leon Match 11/13/2009 04:31PM
Error 1005 due to non existing constraint   4,363 Régis Priqueler 12/09/2009 04:54AM
Re: Error 1005 due to non existing constraint   2,354 Régis Priqueler 12/09/2009 06:41AM
Solved   2,221 Régis Priqueler 12/09/2009 10:41AM
Check Constraint   5,920 Nicolas Quilate 11/26/2009 12:19PM
Re: Check Constraint   2,448 Devart Team 11/27/2009 02:22AM
Q) Integrity Constraint using CHECK in a CREATE query.   5,443 Bruce Oh 11/24/2009 01:45AM
Re: Q) Integrity Constraint using CHECK in a CREATE query.   2,530 Devart Team 11/24/2009 02:16AM
Check Constraint   4,551 Joshua Raymond 09/02/2009 09:01AM
Re: Check Constraint   2,498 Peter Brawley 11/13/2009 10:40PM
CHECK as constraint   3,971 andres carlos 10/26/2009 06:34AM
Re: CHECK as constraint   2,227 Peter Brawley 11/07/2009 01:49PM
utf8 primary key   3,780 Christopher Dickinson 08/23/2009 08:08AM
ERROR 1062 (23000): Duplicate entry '113715-303' for key 2   74,404 Fan Lee 08/22/2007 08:30AM
Re: ERROR 1062 (23000): Duplicate entry '113715-303' for key 2   10,785 Dallas Bratcher 04/29/2009 06:11AM
Re: ERROR 1062 (23000): Duplicate entry '113715-303' for key 2   15,191 Rich Molumby 01/31/2009 11:48AM
Re: ERROR 1062 (23000): Duplicate entry '113715-303' for key 2   16,770 Olaf Tomczak 03/15/2009 04:37PM
Re: ERROR 1062 (23000): Duplicate entry '113715-303' for key 2   11,868 John Costantino 03/20/2009 07:05AM
Re: ERROR 1062 (23000): Duplicate entry '113715-303' for key 2   12,244 mukesh hirve 06/25/2009 12:39AM
Re: ERROR 1062 (23000): Duplicate entry '113715-303' for key 2   30,806 Alvin Yue 01/30/2008 12:57PM
Re: ERROR 1062 (23000): Duplicate entry '113715-303' for key 2   19,864 E Corr 11/13/2008 01:21AM
Re: ERROR 1062 (23000): Duplicate entry '113715-303' for key 2   15,266 conquest drfence 12/22/2008 10:35PM
Re: ERROR 1062 (23000): Duplicate entry '113715-303' for key 2   28,002 Vladimir Nikolic 11/30/2007 10:24AM
Best way to backup the database   6,063 prashant kaushik 06/14/2009 05:50PM
Re: Best way to backup the database   3,137 Peter Brawley 06/17/2009 02:01PM
Pages:  1 2 Next
Current Page: 1 of 2
powered by phorum

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.