Where can I find out about setting up some tables in mysql (I am a rank
beginner with a big project and a lot of learning to do) (the script is
from someone elses project I just trying to learn from) The code and
the telnet log are below...
Thank you
Steve Crim
mailto: stcrim@stripped
# MySQL dump 4.0
#
# Host: localhost Database: reminders
#--------------------------------------------------------
#
# Table structure for table 'notify'
#
CREATE TABLE notify (
date_field timestamp(14),
email varchar(200) DEFAULT '' NOT NULL,
comment blob DEFAULT '' NOT NULL,
recur_num tinyint(3) unsigned DEFAULT '0' NOT NULL,
notify_num tinyint(3) unsigned DEFAULT '0' NOT NULL,
notify_val enum('day','min','hour') DEFAULT 'day' NOT NULL,
recurring char(3) DEFAULT 'no',
recur_val enum('day','min','hour','month','year') DEFAULT 'day' NOT
NULL,
adv_notice char(3) DEFAULT 'no',
id varchar(14) DEFAULT '' NOT NULL,
KEY date_field (date_field)
);
#
# Table structure for table 'passwd'
#
CREATE TABLE passwd (
email varchar(100) DEFAULT '' NOT NULL,
epasswd varchar(14) DEFAULT '' NOT NULL,
PRIMARY KEY (email)
);
Telnet
Log----------------------------------------------------------------------
sienna:~$ # MySQL dump 4.0
sienna:~$ #
sienna:~$ # Host: localhost Database: reminders
sienna:~$ #--------------------------------------------------------
sienna:~$
sienna:~$ #
sienna:~$ # Table structure for table 'notify'
sienna:~$ #
sienna:~$ CREATE TABLE notify (
bash: syntax error near unexpected token `('
sienna:~$ date_field timestamp(14),
bash: syntax error near unexpected token `timestamp(1'
sienna:~$ email varchar(200) DEFAULT '' NOT NULL,
bash: syntax error near unexpected token `varchar(2'
sienna:~$ comment blob DEFAULT '' NOT NULL,
bash: comment: command not found
sienna:~$ recur_num tinyint(3) unsigned DEFAULT '0' NOT NULL,
bash: syntax error near unexpected token `tinyint(3'
sienna:~$ notify_num tinyint(3) unsigned DEFAULT '0' NOT NULL,
bash: syntax error near unexpected token `tinyint(3'
sienna:~$ notify_val enum('day','min','hour') DEFAULT 'day' NOT NULL,
bash: syntax error near unexpected token `enum(''
sienna:~$ recurring char(3) DEFAULT 'no',
bash: syntax error near unexpected token `char(3'
sienna:~$ recur_val enum('day','min','hour','month','year') DEFAULT
'day' NOT
NULL,
bash: syntax error near unexpected token `enum(''
sienna:~$ adv_notice char(3) DEFAULT 'no',
bash: syntax error near unexpected token `char(3'
sienna:~$ id varchar(14) DEFAULT '' NOT NULL,
bash: syntax error near unexpected token `varchar(1'
sienna:~$ KEY date_field (date_field)
bash: syntax error near unexpected token `(d'
sienna:~$ );
bash: syntax error near unexpected token `;'
sienna:~$
sienna:~$ #
sienna:~$ # Table structure for table 'passwd'
sienna:~$ #
sienna:~$ CREATE TABLE passwd (
bash: syntax error near unexpected token `('
sienna:~$ email varchar(100) DEFAULT '' NOT NULL,
bash: syntax error near unexpected token `varchar(1'
sienna:~$ epasswd varchar(14) DEFAULT '' NOT NULL,
bash: syntax error near unexpected token `varchar(1'
sienna:~$ PRIMARY KEY (email)
bash: syntax error near unexpected token `(e'
sienna:~$ );
bash: syntax error near unexpected token `;'
sienna:~$ CREATE TABLE notify (
bash: syntax error near unexpected token `('
sienna:~$ date_field timestamp(14),
bash: syntax error near unexpected token `timestamp(1'
sienna:~$ email varchar(200) DEFAULT '' NOT NULL,
bash: syntax error near unexpected token `varchar(2'
sienna:~$ comment blob DEFAULT '' NOT NULL,
bash: comment: command not found
sienna:~$ recur_num tinyint(3) unsigned DEFAULT '0' NOT NULL,
bash: syntax error near unexpected token `tinyint(3'
sienna:~$ notify_num tinyint(3) unsigned DEFAULT '0' NOT NULL,
bash: syntax error near unexpected token `tinyint(3'
sienna:~$ notify_val enum('day','min','hour') DEFAULT 'day' NOT NULL,
bash: syntax error near unexpected token `enum(''
sienna:~$ recurring char(3) DEFAULT 'no',
bash: syntax error near unexpected token `char(3'
sienna:~$ recur_val enum('day','min','hour','month','year') DEFAULT
'day' NOT
NULL,
bash: syntax error near unexpected token `enum(''
sienna:~$ adv_notice char(3) DEFAULT 'no',
bash: syntax error near unexpected token `char(3'
sienna:~$ id varchar(14) DEFAULT '' NOT NULL,
bash: syntax error near unexpected token `varchar(1'
sienna:~$ KEY date_field (date_field)
bash: syntax error near unexpected token `(d'
sienna:~$ );
bash: syntax error near unexpected token `;'
sienna:~$
sienna:~$ #
sienna:~$ # Table structure for table 'passwd'
sienna:~$ #
sienna:~$ CREATE TABLE passwd (
bash: syntax error near unexpected token `('
sienna:~$ email varchar(100) DEFAULT '' NOT NULL,
bash: syntax error near unexpected token `varchar(1'
sienna:~$ epasswd varchar(14) DEFAULT '' NOT NULL,
bash: syntax error near unexpected token `varchar(1'
sienna:~$ PRIMARY KEY (email)
bash: syntax error near unexpected token `(e'
