mySQL help

[darknuke]

can someone please help me make a mySQL table.. in english,
i've consulted the mySQL manual and i dont understand it... and yes i know php

[PHPdev]

Ok Ill try and break it down.... By the way myPHPAdmin works GREAT for this kind of stuff.

CREATE TABLE tablename (
field1name field1type field1options,
field2name field2type field2options,
PRIMARY KEY (fieldname)
);

basically everything in UPPER CASE are MySQL SYNTAX to tell it what you are doing. All the lowercase are your options.

The fieldtypes can be found in section 6.2 of the MySQL manual

The fieldoptions are many, but the ones I use the most are:
auto_increment
default 'somedefault value'
not null

for the default option the somedefault value depends on the field type... obviously you dont want to pass a integer for a field that is to be a string. thus you have to use the ' around the default value.

These are just the basics... Let me know if you dont understand anything, and Ill try to explain more.

Thanks

PHPdev

[robertoduran]

a simple table coud be:

CREATE TABLE user (
name VARCHAR(10) NOT NULL,
phone VARCHAR(12) NOT NULL,
id VARCHAR(3) NOT NULL
);

notice that the last field of the table that u are creating (in this example "id") doesnt have a "," after the NOT NULL, the NOT NULL is optional.

hope that this helps.. 😉

[darknuke]

thanks!