Jump to content


Photo

create table


  • Please log in to reply
1 reply to this topic

#1 Ninjakreborn

Ninjakreborn
  • Members
  • PipPipPip
  • Information Technology Specialist
  • 3,922 posts
  • Age:33

Posted 09 June 2006 - 03:36 PM

SOLVED- Just had to remove the comma from that last entry, thanks for the help [img src=\"style_emoticons/[#EMO_DIR#]/wink.gif\" style=\"vertical-align:middle\" emoid=\":wink:\" border=\"0\" alt=\"wink.gif\" /]

I have never been so pissed in my entire life currently I want to smash this computer into a thousand pieces, I entered the right syntax but it keeps giving me an error.
do I have to slam it into mysql [img src=\"style_emoticons/[#EMO_DIR#]/unsure.gif\" style=\"vertical-align:middle\" emoid=\":unsure:\" border=\"0\" alt=\"unsure.gif\" /]
MySQL 4.0.26

I am trying
CREATE TABLE signoninfo
(
name char(40),
email char(80),
);

it's giving me some syntax error everytime for line 5 and that is where my );
but I have tried every other way possible, I am really really getting pissed, any advice would be greatly appreciated. I went so far as to try copying and pasting an example from the manual, it worked, but then I did the samething with mine and another error.

------

Business Website: http://www.infotechnologist.biz

Personal Website: http://www.joyelpuryear.com

Blog Site: http://www.realmofwriting.com
Services: Web development, application development, mobile development, and custom development. All services listed on my website.


#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 09 June 2006 - 04:59 PM

You have to remove the trailing comma.

EDIT: Oops... scrolled past the "SOLVED" edit at of the post. See, in Perl, it's not a problem to have extra comma everywhere. I guess that'll fall on deaf ears in a PHP forum ;-)
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users