Page 1 of 1

I know nothing about databases/MySQL

Posted: Tue Jun 25, 2002 11:10 pm
by theotheragentm
To begin with, I started web programming with ColdFusion because my work is fortunate enough to have a ColdFusion server. I understand how queries and such work. Now that I have hosting for a web page on a server that runs PHP, I'm completely lost.

I believe this is the version of MySQL the server I'm hosted on is running: MySQL 3.23.49

My host has a control panel to set up the tables in the database easiliy, or that's what it's supposed to be anyway. I took a screenshot of the forms. Could someone explain the stuff to me?

Here is the image: link

The dropdowns I understand. I have no idea what those checkboxes are on the right. Maybe this is just something specific to my host. Please let me know if you can help me out. Thanks in advance for any help. :D

Posted: Tue Jun 25, 2002 11:30 pm
by jason

Posted: Wed Jun 26, 2002 1:42 am
by theotheragentm
Thanks. That did help. I'm not sure what the following fields are for still:

Index
Unique
Fulltext
Length/Values
Attributes

I'm assuming default is the default value for the field.

Posted: Wed Jun 26, 2002 2:41 am
by twigletmac
Helpfully there is a MySQL manual online:
http://www.mysql.com/doc/
and on this page
http://www.mysql.com/doc/C/R/CREATE_TABLE.html
theres lots of info about the different bits that go into creating a table.

Mac