ENGINE=MyISAM
Thanks for fast help
but after wrote
ENGINE=MyISAM
this error has appeared
SQL query:
-- MySQL dump 9.11
--
-- Host: localhost Database: recipes
-- ------------------------------------------------------
-- Server version 4.0.20a-debug
--
-- Table structure for table `accessgroups`
--
CREATE TABLE accessgroups(
AccessGroupID int( 11 ) NOT NULL AUTO_INCREMENT ,
AccessGroupName varchar( 50 ) default NULL ,
PRIMARY KEY ( AccessGroupID )
) ENGINE = MYISAM ;
MySQL said: Documentation
#1046 - No database selected
=============
SQL query:
--
-- Table structure for table `conferences`
--
CREATE TABLE conferences(
ConferenceID int( 11 ) NOT NULL AUTO_INCREMENT ,
ConferenceRoom int( 11 ) NOT NULL default '0',
ConferenceName varchar( 50 ) NOT NULL default '',
ConferenceDescription varchar( 50 ) NOT NULL default '',
ConferenceStarttimestamp( 14 ) NOT NULL ,
ConferenceDuration time NOT NULL default '00:00:00',
ConferenceBy varchar( 50 ) NOT NULL default '',
PRIMARY KEY ( ConferenceID ) ,
KEY ConferenceID( ConferenceID )
) ENGINE = MYISAM ;
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL,
ConferenceDuration time NOT NULL default '00:00:00',
Confer' at line 10