Search results for query: *

I'll take your point onboard. What I am intending to do is to verify data at the point of entry as well as using the null columns to make sure that erroneous input is avoided. No doubt that database will provide better protection against erroneous input, but on the other hand, the program...

I have read the article, it makes more sense now. But I still don't see much use of the null column when adding records to the tables. If the purpose is to notify the user of whether a field is mandatory or not, than I can do that in the java servlet in which I will embed the mysql statements...

Hello Everybody, I am currently designing a database for my website (a MySql database). This concept is new to me, I am having difficulty in understanding which fields should be null and which should be "not null". Does anybody know of any good articles on the net on this subject? I...

O well, this means I will need a few extra lines in my java program to deal with referential integrity. I am new to mysql and have always heard about its realiability and ease of use. It comes as a surprise that such a well known database doesn't support referntial integrity. As you said, its a...

Yes it does make sense. Can you please explain what you mean when you said it is just "decoration" in mysql. Do you mean that mysql doesn't automatically delete/update foreign key fields in the secondary table when the corresponding primary key fields are deleted/updated in the first...

Thank you. Any ideas of what the syntax will be to create such a field? I'm having difficulty finding an example anywhere on the net. Regards, Junaid.

Hi, I have a design issue. Is it possible to declare a primary key of a table to be a foreign key as well? if its confusing please read on for an example of what I mean. Suppose i have two tables, they both have the same primary key. Lets say that both tables have a primary key called...