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