Another Question On Mysql Table Data Type

mrdee

Nov 1 2007, 10:57 PM

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.

Comment/Reply (w/o sign-up)

jlhaslip

Nov 1 2007, 11:46 PM

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.

Comment/Reply (w/o sign-up)

Similar Topics

Keywords : mysql, table, data, type, text, field, lots, text,

Text Size In "fill-in" Form Blanks

How do you change the size of the text in the fill in form entry boxes (2)

Thanks for all the help on my previous question about adding an address to a "Submit" button.
I've also been able to add a "print page" button through the help from group members. I now have
another question. I've created a form using the Input commands that ask for name, address,
state, etc. My computer is set to use 12 point text on a 800 x 600 screen resolution. When I hit the
print screen button, everything is printed out fine, but I would like the information that people
will be entering into the various boxes to be of a larger or bolder style. The whole re....

Need Help With My Database [resolved]

retrive data as a link (6)

This is the situation: I have a database where you can add bands ( theire albums, genre other
info) For the album part they can add for each album the songs. So what do i want: When i show
the results there only shoul display the bandname which should be a link to the more detailed info
like albums biography etc. How do I do that. Is there a name for this and are there any
tutorials. thx in advance....

Mysql

Several files in one field. (2)

Hi guys. I want t know if it is posible to have so many entries for one object in a field in MySQL.
I know my question may not be clear because I lack in terminology but pliz try and help. What I want
to do is for axample have a database of my clients with the following fields for every client:
fname, lname, more than one photos, contrubutions(comments, jokes, testimonials posted) etc. I want
to have the things like the photos in the same field but they have to be unique so that my php code
can deal with them individually llike they are coming from different fields.....

Index In A Mysql Database

Make the numbers follow (3)

I hope I am on topic here (It does have to do with web design, after all). I have noticed that in a
MySQL database, the 'id' field just keeps its numbers for every record, with the backdraw
that, whenever you remove (a) record(s) from the table, you get your list numbered as eg.
1,5,6,7,12,25 etc. This makes it a bit difficult of keeping track of the number of records in your
table. Is there a way of achieving (either in PHPMyAdmin or through the use of PHP) that the id
field in your table gets sort of 'refreshed and updated' so you have a clearer view....

Treating .csv Files As Database Data

Showing .CSV data on a web page (2)

I use a nice program (which I helped to beta test) called ' Simfatic Forms ' to generate
forms on web pages. The only problem is that it does not (yet) support MySQL databases, it saves the
form data as a .CSV file. Now I was wondering if you can do the same with a .CSV file as you do
with a MySQL databse, ie. displaying the data in that file on a web page which adjusts automatically
as data are added to the file. To clarify: eg. if I make a form to sign a petition online, the data
are saved to a .CSV file every time someone fills in the form, is it now possibl....

Key Sounds In Text Box On Webpage

Typing Key sounds when keys are pressed (1)

Hey guys! /smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" />
I've been conducting some research over the last couple of years and have come to a phase that I
need to put up an online instructory course. It's hardly a website, but it'll consist of a
text box where users are to write a sentence provided to them and while they type, as the keys are
pressed, corresponding .wav files will play. Much like a keyboarding class, a set of sentences and
sounds have already been pre-made to specifications...I've been told that I nee....

Mysql + Php Question

(5)

Hi, I am creating a website in php and using a mysql database to store the data. I want to store
time data in the database. My question is what is the best datatype I should use and how do I read
the time from the database and format(display) it using php ?....

What Program Do You Use To Design Your Web?

Frontpage, Dreamweaver, a good text editor? (103)

I personaly choose frontpage because its easy to use but.....I use dreamweaver for PHP.....

Accessing Mysql From Javascript

Javascript to communicate with database (5)

I found a nice program which allows you to put quizzes on your web site. You can design your own
questions, set the layout of your page, and there is also a possibility of having the results
emailed to you. It further offers a facility to store the results and all that, all you have to do
is put a link in the program, telling it which page takes care of that. However, when I look at the
HTML code the program generates, I see that most of it is written in Javascript. Obviously, it also
uses variable names, but as I don't know any Java, I was wondering if those variab....

Which Data Type To Use In Mysql Table

Using a 5 character number (4)

If I wanted to use an ID field which automatically increments when data are addad, but displays the
ID as a 5 figure number, which data type would I have to use? I would want a type that assigns a
number to a record in the format "00001", "00002", etc. However, when I use "int" as datatype, it
only displays th field contents as "1", "2" etc. So, which data type could do the job for me? i do
not need a decimal point or anything, just an id that displays in 5 figures, including the leading
zeros. Thanks in advance.....

Where Am I Going Wrong This Time?

Can't enter data into database (4)

Hi, on my local machine (with Apache 2.0, PHP 5.2.4 and MySQL 5.0) I come across weird things. I
have successfully made a table, but when I try to enter data into it it just will not accept the
empty string for the first field (id). This was the creation line: QUOTE $query="CREATE TABLE
members (id int(20) auto_increment,first varchar(15) NOT NULL,last varchar(15) NOT NULL,phone
varchar(20) NOT NULL,mobile varchar(20) NOT NULL,fax varchar(20) NOT NULL,email varchar(30) NOT
NULL,web varchar(30) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))"; This has crea....

Merging Database Php Mysql

(5)

Hii i need help margning script. i have coppermine gallery, AzDGDating Site, Noah's
Classifieds they all have user sign-up login. but they have different like i need to have 3 seperate
account for each script is there any way like mergning one user name and password would work for 3
section. if you don't get my question please tell me i will try to explain more in detail
thank you for your time and help ....

Help Or Advise Needed For Access Database Webpage Conversions

I need some help with getting a linked webform so that the data can be (0)

Hello All. I'm looking for some advise or assistance with getting a web page/access page
running so that i can have the page online and collect the data live into my database for Project
Management... Currently I'm developing a database using M$ Access, and need to have staff data
enter sales information directly into a web form that can be linked to a database? I've looked
at using a M$ Front page web form with data collected into a .CSV text file and extracting the data
but i need to be able to let the staff review and update the data for each file? A....

Need Help Designing Website For Online Novels

Making lots of text comfortable to read (3)

I want to start getting my website hammered out, and I realize that I'm not exactly sure how to
balance an attractive design with basic readability. I generally don't like templates and
programs, preferring to work things out from the bottom up as much as possible. I've got some
basic HTML "programming" under my belt, but everything I learned was 5+ years ago, and before CSS.
If possible, I'd like to design something with a "frame" effect over the top of the page and on
the left all the way down with a background for menus and buttons, with the backgrou....

How Do You Combine Multiple Mysql Databases Into One Database?

(3)

How do you combine multiple mysql databases into one database? I was thinking thta soem servers
restrict you to one to five mysql databases. If I have a dynamic part of a table on my site, I
would use one database for that. For every table of dynamic information, I use one database. Can I
streamline what I am doing and combine all of my databases into one? I could make multipple tables
in the same database. Would that work? thanks....

Phpbb And Mysql Relations?

Need forum code for my website (2)

Hi if someone could get back to me as fast as they can that would be great! i got a couple of
questions what do you use my sql for what does that have to do with forums? and secondally can
someone give me the php code for the forum thanks /biggrin.gif" style="vertical-align:middle"
emoid=":D" border="0" alt="biggrin.gif" />....

Syndicate Your Content Using Php And Mysql

(0)

I just finished reading a php book, and figured out some interesting things, and wanted to share
them with the Trap17 community. I know lot of you make websites so this could help out. Enjoy
QUOTE Introduction So, you've spent the best part of a year creating your PHP/MySQL driven
web site. You've got a fair amount of decent, flexible content, and you're buddies with a
couple of other webmasters, so they've given you a free banner ad on their site in exchange for
one on yours. Promoting your site can be even harder than developing it. I've foun....

Html Editor

Text editor or HTML Editor (7)

What is a HTML editor? A HTML editor i basically a text editor but it has some advanced
features.The important one being able to translate written text into HTML codes.Nowadays everyone
uses HTML editors but still there are some guys doing it over a Text editor What do you fell about
this At present iam creating a webpage with MS FP .It is user friendly and actually a very good
tool for a beginner.Beginers look no further than FP.Also one cannot expect,atleast 99% ,a flop show
from Microsoft.It has an integrated FTP. But all sites do not support FP extensi....

Tips On Creating Your Own Search

PHP/MySQL Integrated search on your site (1)

I'm not a professional web developer but I've learned a lot since I used Macromedia
Dreamweaver. The latest version 8 supports PHP 5. If you select PHP as your working language, you
can use this software to automatically add dynamic content to your website with MySQL as a
requisite. If you have a MySQL database containing records like a songs information database, then
you might probably not be able to add a good search page to your website which will search records
in the database. I faced the same problem, but now I'm able to create one sophisticated datab....

Php And Mysql Problem

Need a little help (8)

hi.. i'm new in php and mysql... here is my problem.... $sql = "SELECT COUNT(*) FROM
messages WHERE _parent={$row }"; after sending the query above i dont know how to fetch the actual
rows counted.. i tried using the mysql_fetch_array() and mysql_fetch_row() function but it didnt
work... actually the only function i know that fetches results from sql queries is
mysql_fetch_array()... so what function or code i need to have the result from the query which uses
COUNT?....

Import From Excel File Into Mysql Database

(14)

Has anyone tried using the excel import function that comes with phpmyadmin
http://www.phpmyadmin.net/home_page/ - it does not require any additional plug-ins or scripts and
is fairly straightforward to use. In phpmyadmin, if you click on the database table which you wish
to import the data to , there is a link on the bottom left corner which says "insert data from a
text file into the table" - although it says text file it still can be used to import an excel file.
When you click on this link you will be taken to a page where you will be asked for the file name
(the....

Mysql Host Adress

how do i connect (4)

helo! hou do you? i need somebody post the data for acces my mysql database from my client. thanks a
lot! also i need the alter code for add a foreign key to a column on a table, thanks a lot
/blink.gif' border='0' style='vertical-align:middle' alt='blink.gif' /> Moved to the appropriate
section. Don't put questions in the tutorial section please. ....

Flashing Text?

can u help me (13)

Is there a way to make text flash on a webpage as i think it would be cool can anyone help??????? i
just want to be able to make text flash cheers chris....

What If You Forget Mysql Root Password

(2)

If you have set a root password, but forgot what it was, you can set a new password with the
following procedure: 1. Take down the mysqld server by sending a kill (not kill-9) to the mysqld
server. The pid is stored in a `.pid' file, which is normally in the MySQL database directory:
shell> kill `cat /mysql-data-directory/hostname.pid` You must be either the Unix root user or the
same user mysqld runs as to do this. 2. Restart mysqld with the --skip-grant-tables option. 3. Set
a new password with the mysqladmin password command: shell> mysqladmin -u root password &....

Mysql And Ms Access

(1)

Can MS Access interface with mySQL? Does anyone know how to set it up? Is it even a good idea to?....

Mysql Tool

(0)

What are the best Open Source MySql developer tools?....

Mysql Infos

(2)

hello... what are the infos for the mysql databases ? Like the host, is it localhost ? and the
username ? And what does setting up users for the databases in cpanel does ? thanks in advance....

Php Tutorial - Basics...up To Mysql/file Commands

(1)

the best way to start php is probably not adjusting a script IMO - that misses out a stage. - the
very first stage - here... Why use php? because it allows things to be generated very quickly -
without lots of html pages. It enables users you choose to allow, to input their own content to the
pages you want them to. 1) save these files as anyfilename.php - pick your names, upload them to a
php enabled server and go to the url they are at... 2) understand , .php, //////, /* */, and ;
Code: ?> THis tells the web browser when to expect php coding. So... wh....

Looking for mysql, table, data, type, text, field, lots, text,

Another Question On Mysql Table Data Type - text field for lots of text.

Another Question On Mysql Table Data Type - text field for lots of text.