Mysql foriegn key/references

Question

A is a foreign key referencing B in table C.

For this .
Create table tab(A number (2) references C(B) );

Or

Create table tab(A number (2 ) ,Foreign key(A) references C(B));

Which is better and whats it adva advantages?

Answer 1

If you still haven't found the answer, look here https://stackoverflow.com/questions/14230892/difference-between-using-references-with-and-without-foreign-key It's easier than me retelling the MySQL documentation :)