LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 12-12-2003, 04:00 PM   #1
alaios
Senior Member
 
Registered: Jan 2003
Location: Aachen
Distribution: Opensuse 11.2 (nice and steady)
Posts: 2,203

Rep: Reputation: 45
mysql lot of questions


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?
 
Old 12-12-2003, 05:35 PM   #2
Pcghost
Senior Member
 
Registered: Feb 2003
Location: The Arctic
Distribution: Fedora, Debian, OpenSuSE and Android
Posts: 1,820

Rep: Reputation: 46
Anytime I am unsure what the value will be, I go with varchar.
Varchar can be up to 255 characters.

I use Datetime because it gives a more precise measure.

The rest I will leave for someone more experienced with MySQL as I am not sure of the answers.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need a lot of Help- Several Questions Sleepy_Sentry Linux - Wireless Networking 6 05-16-2005 08:18 AM
A lot of Newbie questions alaxulas Linux - Newbie 5 11-22-2004 05:23 PM
A lot of newbie questions... mfo6463 Fedora 15 03-30-2004 04:30 AM
I have a lot of questions Ajai Linux - Newbie 4 07-23-2003 02:38 AM
Lot of Questions Half_Elf Linux - Software 4 09-15-2001 03:31 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 01:35 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration