cverzonilla Posted March 10, 2007 Share Posted March 10, 2007 I don't understand what indexing is in MySQL. What is it, why do you do it and how do you do it?I also don't understand what NULL means. What happens when you assign a field as NULL. Why would you do it?Thank you Link to comment Share on other sites More sharing options...
Mr_CHISOL Posted March 10, 2007 Share Posted March 10, 2007 Hi!Indexing is something that may fasten up a search in a database, more info about should you be able to find here: http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.htmlNote that there's a difference between index and indexing. Index is a way to sepperate different posts...NULL is a "non existing value". An empty value could be NULL (depending on the internal strutur of the programming language).In MySQL you can set a field as NULL or NOT NULL, which means that that field may be empty (NULL), or it isn't allowed to be empty (NOTNULL).Hope that helped some!Good Luck and Don't Panic! Link to comment Share on other sites More sharing options...
cverzonilla Posted March 10, 2007 Author Share Posted March 10, 2007 Thank you. You did help me. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now