View Single Post
Old 03-01-2005, 07:27 PM  
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
fr8 is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote