any MYSql Buffs on - GoFuckYourself.com

MBS Auto · 03-01-2005, 06:39 PM

I am trying to creat a simple freakin table and it is not working, keep giving me this stupid error

and this is the table

MBS Auto · 03-01-2005, 07:08 PM

BUMP!! Promise it will never happen again

lloyd · 03-01-2005, 07:15 PM

mght you be running a version that doesnt support innodb?

MBS Auto · 03-01-2005, 07:20 PM

No, I get the same error for all storage types

fr8 · 03-01-2005, 07:27 PM

First mistake. Your using windows.

Second im not sure about. I do know that an INNODB type table is for the hotbackup software that you can buy for a mysql database. do you have the that intalled? if so it should work like so.

CREATE TABLE `goddess` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`username` VARCHAR( 16 ) NOT NULL ,
`password` VARCHAR( 16 ) NOT NULL ,
`email` VARCHAR( 25 ) NOT NULL ,
PRIMARY KEY ( `id` )
) TYPE = INNODB ;

im not sure how you would add this through the gui but that is the commandline for the new table.

fr8 · 03-01-2005, 07:31 PM

CREATE TABLE `dbusers` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`username` VARCHAR( 16 ) NOT NULL ,
`password` VARCHAR( 16 ) NOT NULL ,
`email` VARCHAR( 25 ) NOT NULL ,
PRIMARY KEY ( `id` )
) TYPE = INNODB ;

just noticed goddess was the database

03-01-2005, 06:39 PM	#1
MBS Auto Confirmed User Join Date: Oct 2004 Location: Sin City Baby... Posts: 1,725	any MYSql Buffs on I am trying to creat a simple freakin table and it is not working, keep giving me this stupid error and this is the table __________________ Shoes and Boot

03-01-2005, 07:08 PM	#2
MBS Auto Confirmed User Join Date: Oct 2004 Location: Sin City Baby... Posts: 1,725	BUMP!! Promise it will never happen again __________________ Shoes and Boot

03-01-2005, 07:20 PM	#4
MBS Auto Confirmed User Join Date: Oct 2004 Location: Sin City Baby... Posts: 1,725	No, I get the same error for all storage types __________________ Shoes and Boot

03-01-2005, 07:27 PM	#5
fr8 Confirmed User Industry Role: Join Date: Mar 2003 Posts: 5,074	First mistake. Your using windows. Second im not sure about. I do know that an INNODB type table is for the hotbackup software that you can buy for a mysql database. do you have the that intalled? if so it should work like so. CREATE TABLE `goddess` ( `id` INT( 10 ) NOT NULL AUTO_INCREMENT , `username` VARCHAR( 16 ) NOT NULL , `password` VARCHAR( 16 ) NOT NULL , `email` VARCHAR( 25 ) NOT NULL , PRIMARY KEY ( `id` ) ) TYPE = INNODB ; im not sure how you would add this through the gui but that is the commandline for the new table. __________________ █ joesmut (a) gmail Dot com █ Full Stack Developer

03-01-2005, 07:31 PM	#6
fr8 Confirmed User Industry Role: Join Date: Mar 2003 Posts: 5,074	CREATE TABLE `dbusers` ( `id` INT( 10 ) NOT NULL AUTO_INCREMENT , `username` VARCHAR( 16 ) NOT NULL , `password` VARCHAR( 16 ) NOT NULL , `email` VARCHAR( 25 ) NOT NULL , PRIMARY KEY ( `id` ) ) TYPE = INNODB ; just noticed goddess was the database __________________ █ joesmut (a) gmail Dot com █ Full Stack Developer

03-01-2005, 07:15 PM	#3
lloyd Confirmed User Industry Role: Join Date: May 2002 Location: 858/604 Posts: 798	mght you be running a version that doesnt support innodb?