Welcome Guest ( Log In | Register)



 
Reply to this topicStart new topic
> Another Question On Mysql Table Data Type, text field for lots of text.
mrdee
post Nov 1 2007, 10:57 PM
Post #1


Super Member
*********

Group: [HOSTED]
Posts: 258
Joined: 18-July 07
From: Slough (UK)
Member No.: 46,682



In my MySQL table I would like to use one text field which can contain lots of text. What I want to use it for is for student records, and I want to be able to add to it without destroying what is already there.
I want the field to contain something like:

****03/11/2007****
Chopin prelude No 9: small problem bars 12-15.
Advice given on how to practice.

****10/11/2007****
Problem in Prelude overcome, piece successfully completed.
New piece set: Beethoven Sonata No 1, movement 1.

etc.
This is of course just an example, but that is how I want to set up my student records.

Do I have to use LONGTEXT for this, and how do I set the parameters?

Thanks in advance.
Go to the top of the page
 
+Quote Post
jlhaslip
post Nov 1 2007, 11:46 PM
Post #2


A computer once beat me at chess, but it was no match for me at kick boxing.
Group Icon

Group: [MODERATOR]
Posts: 3,882
Joined: 24-July 05
From: In Trouble Again... still?
Member No.: 9,787
Spam Patrol



Using the cheat sheet from your other topic, text is good for 65K characters. So is BLOB, but I think Blob is more suited to Binary data, like images. Might have to check on that, so either of them should be good.

Tinychar and Varchar are only good to 255 characters, about 100 words.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. 5000 + Icons(0)
  2. Php Tutorial - Basics...up To Mysql/file Commands(1)
  3. Mysql Infos(2)
  4. Mysql Tool(0)
  5. Mysql And Ms Access(1)
  6. What If You Forget Mysql Root Password(2)
  7. Flashing Text?(11)
  8. Mysql Host Adress(4)
  9. Import From Excel File Into Mysql Database(7)
  10. Php And Mysql Problem(8)
  11. Tips On Creating Your Own Search(1)
  12. Html Editor(7)
  13. Syndicate Your Content Using Php And Mysql(0)
  14. Phpbb And Mysql Relations?(2)
  15. How Do You Combine Multiple Mysql Databases Into One Database?(3)
  1. Need Help Designing Website For Online Novels(3)
  2. Help Or Advise Needed For Access Database Webpage Conversions(0)
  3. Merging Database Php Mysql(5)
  4. Where Am I Going Wrong This Time?(4)
  5. Which Data Type To Use In Mysql Table(4)
  6. Accessing Mysql From Javascript(4)
  7. What Program Do You Use To Design Your Web?(82)
  8. Mysql + Php Question(5)
  9. Key Sounds In Text Box On Webpage(1)
  10. Treating .csv Files As Database Data(2)
  11. Index In A Mysql Database(3)
  12. Mysql(2)
  13. Need Help With My Database [resolved](6)


 



- Lo-Fi Version Time is now: 25th July 2008 - 07:52 PM