Understanding mySQL Table

HelloWorld · #1 (**permalink**) 06-15-2007, 10:13 AM

I'm now playing around with myPhpAdmin, see if anybody can help me here

PHP Code:

  CREATE TABLE `memberinfo` (

`username` VARCHAR( 4 ) NOT NULL ,

`password` VARCHAR( 4 ) NOT NULL 

) ENGINE = MYISAM ;

ok there are several things that I don't understand from that line, I understand, usename, memberinfo, password, vachar(4). I don't understand the rest of it

Can anybody explain me? How do you use these information? I guess I would need to understand the basics of SQL so that I can use it for my portal page.. thx guys

Lee · #2 (**permalink**) 06-15-2007, 12:02 PM

maybe these links can help you:
Varchar
MYISAM
Null

HelloWorld · #3 (**permalink**) 06-15-2007, 05:57 PM

Quote:

Originally Posted by Lee

maybe these links can help you:
Varchar
MYISAM
Null

I understood what's varchar is, I just need to understand on how does this thing work. I'm trying to set the username, and the value for that username.

Nutter · #4 (**permalink**) 06-15-2007, 06:59 PM

It sounds like you're looking at two different types of queries. The one you quoted is the query that actually builds the table. If you're trying to insert a user into this table you need an INSERT query, or if you're updating then an UPDATE query.

Code:

INSERT INTO memberinfo (username, password) VALUES ('John', 'pass');

You're probably going to want to make the fields longer than 4 characters.

HelloWorld · #5 (**permalink**) 06-15-2007, 07:02 PM

Quote:

Originally Posted by Nutter

It sounds like you're looking at two different types of queries. The one you quoted is the query that actually builds the table. If you're trying to insert a user into this table you need an INSERT query, or if you're updating then an UPDATE query.

Code:

INSERT INTO memberinfo (username, password) VALUES ('John', 'pass');

You're probably going to want to make the fields longer than 4 characters.

Tell me if I'm not wrong, and we can control these from PHP too, right? thx, rep added

chrishirst · #6 (**permalink**) 06-15-2007, 11:43 PM

Quote:

Tell me if I'm not wrong, and we can control these from PHP too

Depends on how you mean "control"

In most server side languages you can build queries, send them to the server and retrieve the results.

Start with learning the Basic SQL Commands

HelloWorld · #7 (**permalink**) 06-16-2007, 12:00 AM

Quote:

Originally Posted by chrishirst

Depends on how you mean "control"

In most server side languages you can build queries, send them to the server and retrieve the results.

Start with learning the Basic SQL Commands

Thanx, it helps me a lot. I'm now able to insert values to my data table. Now I just need to be able to call it into my PHP

rep added..

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode