plz help a newbie
Hi there just a lot lot lot of questions. Plz answer as many as you can. What do u prefer varchar(2) or tiny_text? What is the biggest size for the varchar? If I want to store a very big article. What is the biggest size for text that is being support? What is the difference between timestamp and DateTime? What do u suggest? What is the difference between Varchar and Binary Varchar? Details plz? I have these type of associations supported by mysql 1:1 1:1 (Non-Identyfying) 1:1 (Descendent Obj.) What are the differences among them? Especially the last one? - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
Re: plz help a newbie
Here is a link to the MySQL manual. Lots of good info here. http://www.mysql.com/documentation/mysql/bychapter/index.htm l The max size of a varchar is 255 characters. You will want to use one of the text data types if you are going to store long articles. I suggest mediumtext. You can find the exact maximum sizes in the manual under the data types section. A timestamp column gets automatically updated to now on inserts and updates unless you explictly set it to something. Datetime fields just store a datetime (you update them to whatever you want). I don't understand what you meant by this. Can you give an example? I have these type of associations supported by mysql 1:1 1:1 (Non-Identyfying) 1:1 (Descendent Obj.) What are the differences among them? Especially the last one? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]