I cannot see the MIME type field when I create tables
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 --
To be more clear...
When I use PhpMyAdmin to create SQL tables, there should be a MIME type field, but it is missing in my PhpMyAdmin.
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.
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.
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)