piebug
01-28-2007, 02:08 AM
I cannot see the MIME type field when I create tables
jobeard
01-28-2007, 12:51 PM
be more specific; what tables -- html "< table > .. </ table >" or SQL tables?
either of these do NOT have a MIME type so you've got me confused!
Mime types are set in the HTTP header of a reply so the browser knows how
to render the content --
piebug
01-29-2007, 01:03 AM
When I use PhpMyAdmin to create SQL tables, there should be a MIME type field, but it is missing in my PhpMyAdmin.
Mictlantecuhtli
01-29-2007, 02:48 AM
That's odd, I've been using MySQL for quite a long time and I've never heard of mimetypes in tables.
Then again, I prefer the command line to PHPMyAdmin.
Nodsu
01-29-2007, 04:58 AM
The columns and types in database tables are arbitrary. Why do you think that there has to be a MIME type field? Or, if it has to be there, then just create it. That's what you are supposed to do when creating tables - define the fields and data types.
jobeard
01-29-2007, 01:52 PM
Haven't done this in some time -- however, one normally creates SQL tables
as a background task, ie: command line or batch script, not online via a browser.
ONLY the browser needs mimetypes.
Even if using some online form the flow would still be
fill in the form
POST to a CGI script on the host
run the sequence into MySQL
verify no errors
reply to the browser success/failure (needing a mimetype)