List:General Discussion« Previous MessageNext Message »
From:Steve and Cindy Crim Date:April 5 1999 3:53am
Subject:php mysql question/help
View as plain text  
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'



Thread
php mysql question/helpSteve and Cindy Crim5 Apr
  • Re: php mysql question/helpMicheal Mc Evoy5 Apr