Log in

View Full Version : New to MySQL Query process/getting erorr


DanIAm
08-15-2002, 04:56 PM
I have never done a MYSQL Query and am trying my best to learn how to do with by reading as much as I can. I am using the SQL Query from Control Panel hack found at:

https://vborg.vbsupport.ru/showthread.php?s=&threadid=33731

Right now I am trying to install the Tetris hack found at: https://vborg.vbsupport.ru/showthread.php?s=&threadid=42293

And it tells me to run a query with this listed:

"CREATE TABLE `arcade` (
`scoreid` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL
default '0',
`game` varchar(50) NOT NULL default '',
`score` int(11) NOT NULL default '0',

`comment` varchar(70) NOT NULL default 'No comment',
PRIMARY KEY (`scoreid`)
) TYPE=MyISAM;"

I have pasted this information as seen above, click run query, and I get this error:

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: CREATE TABLE `arcade` (
`scoreid` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL
default '0',
`game` varchar(50) NOT NULL default '',
`score` int(11) NOT NULL default '0',

`comment` varchar(70) NOT NULL default 'No comment',
PRIMARY KEY (`scoreid`)
) TYPE=MyISAM;
mysql error: Table 'arcade' already exists

mysql error number: 1050

Date: Thursday 15th of August 2002 10:56:09 AM
Script: http://www.mentalmingle.com/forums/forums/admin/query.php
Referer:

What does this mean, what am I doing wrong? Please help...

Thanks in advance, Dan

Dean C
08-15-2002, 06:13 PM
you already have that table... :D

your trying to run it again - there's no need :D