Creating Tables. (MySQL Tables)

[lMattz]

Can someone explain what these mean:

NOT NULL,
NULL
NULL AUTO_INCREMENT
PRIMARY KEY (`id`)
) TYPE=MyISAM;
VARCHAR( 50 )

Thanks

- Matt

[D3stroyer]

I'm not sure about MySQL but i'm sure Primary key is the id of the table or something and the type is the type. but :S i don't really have a clue about MySQL.

Daza

[Wizzdom]

Are you trying to create tables in html format?

[lMattz]

No, for databases lol.

[Encryptions!]

Hello.

Are you trying to create tables or understand what they mean.

The Actual Table

In my description the table of a mySQL table would have to be the same as a Microsoft Access Database table; they are used to store data and run queries and other commands.

Setting up a Table

There are two ways to do this; but the easiest way is to create it in the structure of PhpMyAdmin in your MySQL section of cPanel. You can choose the various function null etc and then it creates the SQL for you and then you need to connect to your Database via PHP connection using your user details of the actual Database. Also your host must be PHP/MySQL enabled.

Thanks
Encryptions

[D3stroyer]

Dan i thought this was a kiddies forum and you were more respcted or ure big devolpmnt websites..
pm me

[nets]

I'm making an assumption that you're following a tutorial; if I'm not mistaken, then forget what has been mentioned in this thread as it's irrelevant.
What you've got there is SQL (invalid SQL), it's a language used to "control" databases (for instance MySQL).
To create a table, your SQL should look something along the lines of:

CREATE TABLE Example
(
name varchar(50),
age int(3),
}