mySQL Help!

HelloWorld · #1 (**permalink**) 07-09-2007, 07:56 PM

Code:

create table Member
(
username varchar,
pass varchar
)

Do you guys find there's something wrong with my query? It's really simple but, SQL Query Browser tells me that there's an error...

Code:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
pwd varchar
)' at line 3

I have no clue what's wrong, I checked my query over and over, and by comparing it with the tutorial that I found

rpgfan3233 · #2 (**permalink**) 07-09-2007, 08:09 PM

Try the MySQL tutorial at MySQL AB :: MySQL 5.0 Reference Manual :: 3 Tutorial

In my opinion, that is a very good tutorial. Also, for VARCHAR, I believe you need to set a length:

Code:

create table Member
(
username varchar(32),
pass varchar(32)
);

Also, don't forget the semicolon ( ; ) at the end.

HelloWorld · #3 (**permalink**) 07-09-2007, 08:11 PM

fart! look at this crappy tutorial...

SQL Create Database, Table, and Index

gave me a wrong code XD
Man, I was comparing it like for about 5 minutes and gave up
thanx pal~!

HelloWorld · #4 (**permalink**) 07-09-2007, 08:13 PM

but it still doesn't work lol.... XD
same exact error message.....~

rpgfan3233 · #5 (**permalink**) 07-09-2007, 08:28 PM

I just installed MySQL. Here is what I did:

create database mytest;

use mytest;

create table Member
(
username varchar(32),
pass varchar(32)
);

HelloWorld · #6 (**permalink**) 07-09-2007, 08:32 PM

Quote:

I just installed MySQL. Here is what I did:

create database mytest;

use mytest;

create table Member
(
username varchar(32),
pass varchar(32)
);

as expected, I realized that there's nothing that let the query know which table to use. But I set the default schema to my database name though...

It did works well.. Thanx a lot

Lee · #7 (**permalink**) 07-10-2007, 05:49 AM

I would say learn how mysql works by coding using all the different commands in your website, to make your databases at first install and use phpmyadmin, it will make life easier to start and then when it comes to making databases in your script then it would be much easier as you will have a lot of knowledge on how the mysql syntax should be.

ccoonen · #8 (**permalink**) 07-10-2007, 07:07 AM

I'm thinking that url you were looking at was for MsSQL not MySQL. Still, its best practice to define field lengths when possible when creating your table schema's.

HelloWorld · #9 (**permalink**) 07-10-2007, 08:39 AM

Quote:

Originally Posted by ccoonen

I'm thinking that url you were looking at was for MsSQL not MySQL. Still, its best practice to define field lengths when possible when creating your table schema's.

yeah, the web doesn't really explain whether it's mySQL or msSQL it just stated as SQL query

TeraTask · #10 (**permalink**) 07-10-2007, 11:11 AM

Personally, I use PHPMyAdmin to create tables. I'll let it worry about the syntax.

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

The Following User Says Thank You to rpgfan3233 For This Useful Post:
HelloWorld (07-09-2007)

The Following User Says Thank You to ccoonen For This Useful Post:
HelloWorld (07-10-2007)