1064 error

system · August 28, 2013, 10:27pm

I am very much a newby at this and am trying to setup a graveyard database for my local church. AN initial step is to load some data but this comes up with an error and no amount of surfing has found me an answer. (Data - In some cases I don’t have a dob so I have used a comma and a space). Without completing this step I can’t move on! I’d be grateful for help. The error I get on running Import is #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 ‘grave_dob’ varchar(20),
grave_dod' varchar(20,grave_ageatdeath’ v’ at line 8

The script is

– phpMyAdmin SQL Dump

– version 5.5.1
– http://www.phpmyadmin.net

–

– Host: localhost

– Server version: 5.1.36

– PHP Version: 5.5.0

SET SQL_MODE=“NO_AUTO_VALUE_ON_ZERO”;

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

–

– Database: graveyard

–

– Table structure for table gravestones

–

DROP TABLE IF EXISTS gravestones;
CREATE TABLE IF NOT EXISTS gravestones (

 `grave_index` int(10) NOT NULL AUTO_INCREMENT,

 `grave_location` varchar(8) NOT NULL,

 `grave_location` varchar(25) NOT NULL,

 `grave_forenames' varchar(25) NOT NULL,
 `grave_dob' varchar(20),
 `grave_dod' varchar(20,
 `grave_ageatdeath' varchar(10),
 `grave_comments' varchar(255),
 `grave_record_updated timestamp NOTNULL  
  PRIMARY KEY (`grave_index`)

  ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

–

– Dumping data for table gravestones

–

INSERT INTO gravestones (grave_index, grave_surname, grave_forenames, grave_dob', 'grave_record_updated) VALUES

(1, Bowler, Rose Evelyn, 19 June 1931),
(2, Trotter, Marjorie, ),
(3, McClements , Ruby, ),
(4, McClement, Colin, ),
(5, Sharpe, Stephen Hendry, 29 October 1965),
(6, Sharpe, Nelson, 7 January 1933),
(7, Hetherington, Edith, ),
(8, Hetherington, Joseph, ),
(9, Wilful, Fred, ),
(10, Car, Joseph, ),
(11, Long, Joseph Renfrey, 18 March 1913 ),
(12, Long, Hannah, 9 July 1913),
(13, Lamb, George, ),
(14, Butler, Harold, ),
(15, Butler, Dorothy Elaine, ),
(16, Sharpe, Ivy, ),
(17, Stafford, James, ),
(18, Stafford, Martha, ),
(19, Crichton, Robert Alexander, ) ;

Many thanks.
Ian

Topcoder · August 28, 2013, 10:52pm

You got so many things wrongs I’m not even going to list all the issues, instead I created a new script for you to run…

[php]
DROP TABLE IF EXISTS gravestones;

CREATE TABLE IF NOT EXISTS gravestones (

 grave_index int(10) NOT NULL AUTO_INCREMENT,
 grave_location varchar(8),
 grave_surname varchar(25) NOT NULL,
 grave_forenames varchar(25) NOT NULL,
 grave_dob varchar(20),
 grave_dod varchar(20),
 grave_ageatdeath varchar(10),
 grave_comments varchar(255),
 grave_record_updated timestamp NOT NULL  DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (grave_index)

  ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

INSERT INTO gravestones (grave_surname, grave_forenames, grave_dob) VALUES
(‘Bowler’, ‘Rose Evelyn’, ‘19 June 1931’),
(‘Trotter’, ‘Marjorie’, null ),
(‘McClements’ , ‘Ruby’, null),
(‘McClement’, ‘Colin’, null),
(‘Sharpe’, ‘Stephen Hendry’, ‘29 October 1965’),
(‘Sharpe’, ‘Nelson’, ‘7 January 1933’),
(‘Hetherington’, ‘Edith’, null),
(‘Hetherington’, ‘Joseph’, null),
(‘Wilful’, ‘Fred’, null),
(‘Car’, ‘Joseph’, null),
(‘Long’, ‘Joseph Renfrey’, ‘18 March 1913’),
(‘Long’, ‘Hannah’, ‘9 July 1913’),
(‘Lamb’, ‘George’,null ),
(‘Butler’, ‘Harold’, null),
(‘Butler’, ‘Dorothy Elaine’, null),
(‘Sharpe’, ‘Ivy’, null),
(‘Stafford’, ‘James’, null),
(‘Stafford’, ‘Martha’, null),
(‘Crichton’, ‘Robert Alexander’, null ) ;
[/php]

Tell your priest to put in a good word for me…