MySQL Forums
Forum List  »  Spanish

Re: PROBLEMA CON FOREIGN KEY (FK) MYSQL
Posted by: Gonzalo Garcia Correas
Date: November 26, 2009 07:27AM

Tienes un error de sitaxis, cuando indicas a qué tabla hace referencia una FK también tienes que indicar a qué campo se hace referencia:
ALTER TABLE matricula
ADD CONSTRAINT fk_matricula_curso
FOREIGN KEY idcurso
REFERENCES `curso`(`idcurso`);

Se requiere eso porque no hay forma en que MySQL sepa cuál es el campo, ya que el mismo podría tener un nombre diferente al que aparece en la tabla referenciada.

Options: ReplyQuote


Subject
Views
Written By
Posted
54838
July 11, 2006 07:51AM
4209
February 25, 2010 05:22PM
3891
November 09, 2010 06:58AM
6087
June 07, 2010 03:05PM
4313
August 31, 2011 05:59AM
7838
August 30, 2006 09:33AM
8809
November 14, 2007 03:15AM
8076
June 13, 2011 08:59AM
12124
February 12, 2008 06:04PM
7898
March 11, 2008 05:17AM
4636
April 10, 2010 06:07PM
8914
August 25, 2008 07:22PM
9210
March 23, 2008 09:27AM
5691
April 19, 2008 05:08PM
5248
May 11, 2008 12:28PM
7873
March 28, 2008 10:20AM
6847
June 05, 2008 08:21AM
5177
May 20, 2009 06:30PM
7903
April 18, 2008 12:52PM
5129
May 20, 2009 06:27PM
5747
April 30, 2008 02:21PM
5472
June 05, 2008 08:02AM
7563
May 02, 2008 01:15PM
5553
May 08, 2008 08:13PM
5800
May 08, 2008 09:05AM
7976
June 04, 2008 01:47PM
5133
May 29, 2008 04:34AM
5242
May 29, 2008 05:54AM
5484
June 02, 2008 11:47AM
12091
June 04, 2008 02:01PM
6361
June 05, 2008 07:46AM
6816
June 09, 2008 02:31AM
4929
June 09, 2008 09:53AM
5273
June 11, 2008 10:47AM
5950
June 16, 2008 06:28AM
7971
September 03, 2008 04:34PM
10047
September 05, 2008 04:09AM
5609
December 14, 2008 11:49AM
7981
May 19, 2009 08:31AM
5206
May 19, 2009 08:43AM
4395
July 29, 2009 08:59AM
4378
August 02, 2009 09:19PM
5117
August 02, 2009 03:18PM
4807
August 28, 2009 06:55PM
8093
August 31, 2009 03:02PM
5165
September 14, 2009 01:54PM
5253
September 24, 2009 09:43PM
4293
September 25, 2009 09:30AM
4651
October 07, 2009 01:51AM
6300
November 05, 2009 05:09PM
4636
November 25, 2009 06:51AM
Re: PROBLEMA CON FOREIGN KEY (FK) MYSQL
7202
November 26, 2009 07:27AM
3719
November 26, 2009 04:13AM
4158
December 28, 2009 10:31PM
4778
February 02, 2010 09:55AM
11410
February 12, 2010 08:35AM
4574
March 01, 2010 03:08PM
3864
March 03, 2010 08:23AM
5902
March 05, 2010 07:57AM
3406
March 06, 2010 04:37PM
5367
April 13, 2010 03:43PM
3649
August 08, 2010 03:15PM
3461
August 08, 2010 03:54PM
2460
September 15, 2010 10:06AM
14123
September 18, 2010 10:24AM
2729
October 10, 2010 10:05AM
2421
November 13, 2010 05:53AM
2749
October 18, 2010 04:05PM
2253
October 18, 2010 07:34PM
2545
January 20, 2011 03:13PM
3911
February 14, 2011 09:18AM
3474
January 31, 2011 04:19PM
3376
February 02, 2011 11:41AM
2236
March 17, 2011 01:35PM
2728
July 30, 2011 10:51PM
1818
August 15, 2011 03:50PM
2876
September 20, 2011 10:54AM
1700
September 20, 2011 01:53PM


Sorry, you can't reply to this topic. It has been closed.

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.