Jump to content


Photo

Problem creating a table HELP


  • Please log in to reply
1 reply to this topic

#1 redgtsviper

redgtsviper
  • Members
  • PipPip
  • Member
  • 19 posts

Posted 27 April 2006 - 02:17 AM

Can anyone tell me what is wrong with this code



# phpMyAdmin MySQL-Dump
# [a href=\"http://phpwizard.net/phpMyAdmin/\" target=\"_blank\"]http://phpwizard.net/phpMyAdmin/[/a]
#
# Table structure for table 'users'
#

CREATE TABLE users (
user_id mediumint(9) NOT NULL auto_increment,
first_name varchar(15) NOT NULL,
last_name varchar(30) NOT NULL,
email varchar(40) NOT NULL,
username varchar(40) NOT NULL,
password varchar(40) NOT NULL,
registration_date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
PRIMARY KEY (user_id)
);


#2 redgtsviper

redgtsviper
  • Members
  • PipPip
  • Member
  • 19 posts

Posted 27 April 2006 - 02:42 AM

Fixed the problem

it was the ; at the end




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users