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.