MySQL Forums
Forum List  »  InnoDB

eroor when trying to greate table
Posted by: Warren Hawthorne
Date: October 17, 2008 02:45AM

Im just starting to use Mysql and am a bit stuck.

I use the following commands:

CREATE DATABASE test;
USE test;

***

CREATE TABLE users;
->
(
user_name varchar(20),
user_pw varchar(20),
);


Everytime I type in the code as from *** as soon as i press return after ); i get :

ERROR 1064: you have an error in your SQL syntax near ')' at line 5

can anyone explain where im going wrong trying to create this table?

thanks
warren.

Options: ReplyQuote


Subject
Views
Written By
Posted
eroor when trying to greate table
3767
October 17, 2008 02:45AM
2542
October 29, 2008 03:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.