?

Search Help Board

PHP FAQ
PHP Articles
PHP Help
Bulletin Board

PHP Manual (NEW!)
First Time PHP'ers
Help with programming
Sql assignment help
PHP Homework Help


C# Help

?
?phpMyAdmin 2.5.1 Screw Up
Author:??(---.in-addr.btopenworld.com)
Date:???10-09-03 06:04

I am trying to add a database to my Website via phpMyAdmin. I have done this before, but this time, I get the following error. Please help me - I have a lot of work to do, and without a database, it's impossible.

SQL-query :

CREATE TABLE `wrestling` (

`event` VARCHAR NOT NULL ,
`eventwhen` VARCHAR NOT NULL ,
`ppv` VARCHAR NOT NULL ,
`id` TINYINT( 10 ) AUTO_INCREMENT ,
`a1` VARCHAR NOT NULL ,
`a2` VARCHAR NOT NULL ,
`a3` VARCHAR NOT NULL ,
`a4` VARCHAR NOT NULL ,
`b1` VARCHAR NOT NULL ,
`b2` VARCHAR NOT NULL ,
`b3` VARCHAR NOT NULL ,
`b4` VARCHAR NOT NULL ,
`c1` VARCHAR NOT NULL ,
`c2` VARCHAR NOT NULL ,
`c3` VARCHAR NOT NULL ,
`c4` VARCHAR NOT NULL ,
`d1` VARCHAR NOT NULL ,
`d2` VARCHAR NOT NULL ,
`d3` VARCHAR NOT NULL ,
`d4` VARCHAR NOT NULL ,
`e1` VARCHAR NOT NULL ,
`e2` VARCHAR NOT NULL ,
`e3` VARCHAR NOT NULL ,
`e4` VARCHAR NOT NULL ,
`f1` VARCHAR NOT NULL ,
`f2` VARCHAR NOT NULL ,
`f3` VARCHAR NOT NULL ,
`f4` VARCHAR NOT NULL ,
`g1` VARCHAR NOT NULL ,
`g2` VARCHAR NOT NULL ,
`g3` VARCHAR NOT NULL ,
`g4` VARCHAR NOT NULL ,
`h1` VARCHAR NOT NULL ,
`h2` VARCHAR NOT NULL ,
`h3` VARCHAR NOT NULL ,
`h4` VARCHAR NOT NULL ,
`i1` VARCHAR NOT NULL ,
`i2` VARCHAR NOT NULL ,
`i3` VARCHAR NOT NULL ,
`i4` VARCHAR NOT NULL ,
`j1` VARCHAR NOT NULL ,
`j2` VARCHAR NOT NULL ,
`j3` VARCHAR NOT NULL ,
`j4` VARCHAR NOT NULL ,
UNIQUE (
`id`
)

MySQL said:


You have an error in your SQL syntax near 'NOT NULL ,
`eventwhen` VARCHAR NOT NULL ,
`ppv` VARCHAR NOT NULL ,
`id` TI' at line 1

?Topics Author? Date
?phpMyAdmin 2.5.1 Screw Up??new
TeenBite.com 10-09-03 06:04?
?Re: phpMyAdmin 2.5.1 Screw Up??new
bastien 10-09-03 09:49?
Go to Top??|??Go to Topic??|??Flat View??|??Search?
??|??
New Topic
?Reply To This Message
?Your Name:
?Your Email:
?Subject:
Email replies to this thread, to the address above.
??wrote: > > I am trying to add a database to my Website via phpMyAdmin. I > have done this before, but this time, I get the following > error. Please help me - I have a lot of work to do, and > without a database, it's impossible. > > SQL-query : > > CREATE TABLE `wrestling` ( > > `event` VARCHAR NOT NULL , > `eventwhen` VARCHAR NOT NULL , > `ppv` VARCHAR NOT NULL , > `id` TINYINT( 10 ) AUTO_INCREMENT , > `a1` VARCHAR NOT NULL , > `a2` VARCHAR NOT NULL , > `a3` VARCHAR NOT NULL , > `a4` VARCHAR NOT NULL , > `b1` VARCHAR NOT NULL , > `b2` VARCHAR NOT NULL , > `b3` VARCHAR NOT NULL , > `b4` VARCHAR NOT NULL , > `c1` VARCHAR NOT NULL , > `c2` VARCHAR NOT NULL , > `c3` VARCHAR NOT NULL , > `c4` VARCHAR NOT NULL , > `d1` VARCHAR NOT NULL , > `d2` VARCHAR NOT NULL , > `d3` VARCHAR NOT NULL , > `d4` VARCHAR NOT NULL , > `e1` VARCHAR NOT NULL , > `e2` VARCHAR NOT NULL , > `e3` VARCHAR NOT NULL , > `e4` VARCHAR NOT NULL , > `f1` VARCHAR NOT NULL , > `f2` VARCHAR NOT NULL , > `f3` VARCHAR NOT NULL , > `f4` VARCHAR NOT NULL , > `g1` VARCHAR NOT NULL , > `g2` VARCHAR NOT NULL , > `g3` VARCHAR NOT NULL , > `g4` VARCHAR NOT NULL , > `h1` VARCHAR NOT NULL , > `h2` VARCHAR NOT NULL , > `h3` VARCHAR NOT NULL , > `h4` VARCHAR NOT NULL , > `i1` VARCHAR NOT NULL , > `i2` VARCHAR NOT NULL , > `i3` VARCHAR NOT NULL , > `i4` VARCHAR NOT NULL , > `j1` VARCHAR NOT NULL , > `j2` VARCHAR NOT NULL , > `j3` VARCHAR NOT NULL , > `j4` VARCHAR NOT NULL , > UNIQUE ( > `id` > ) > > MySQL said: > > > You have an error in your SQL syntax near 'NOT NULL , > `eventwhen` VARCHAR NOT NULL , > `ppv` VARCHAR NOT NULL , > `id` TI' at line 1 ">??

Provided By
Phorum