Re: MySQL and Apostrophes
OK ..... i have changed the INSERT bit to this
INSERT INTO member VALUES(00000001,’Michael’,’Devine’,’Cork’,’Irish’,000005);
INSERT INTO member VALUES(00000002,’Danny’,’Murphy’,’London’,’English’,000005);
INSERT INTO member VALUES(00000003,’Alan’,’Bennett’,’Cork’,’Irish’,000005);
INSERT INTO member VALUES(00000004,’Dan’,’Murray’,’Cambridge’,’Irish’,000005);
INSERT INTO member VALUES(00000005,’Neal’,’Horgan’,’Cork’,’Irish’,000005);
INSERT INTO member VALUES(00000006,’Colin’,’O\'’Brien’,’Cork’,’Irish’,000005);
INSERT INTO member VALUES(00000007,’George’,’O\'’Callaghan’,’Cork’,’Irish’,000005);
INSERT INTO member VALUES(00000008,’Joe’,’Gamble’,’Cork’,’Irish’,000005);
INSERT INTO member VALUES(00000009,’Liam’,’Kearney’,’Cork’,’Irish’,000005);
INSERT INTO member VALUES(00000010,’Kevin’,’Doyle’,’Wexford’,’Irish’,000005);
INSERT INTO member VALUES(00000011,’John’,’O\'’Flynn’,’Cork’,’Irish’,000005);
INSERT INTO member VALUES(00000012,’Steve’,’Williams’,’Aberystwyth’,’Welsh’,000018);
INSERT INTO member VALUES(00000013,’Owen’,’Heary’,’Dublin’,’Irish’,000018);
INSERT INTO member VALUES(00000014,’David’,’Crawley’,’Dundalk’,’Irish’,000018);
INSERT INTO member VALUES(00000015,’Jamie’,’Harris’,’Swansea’,’Welsh’,000018);
INSERT INTO member VALUES(00000016,’Colin’,’Hawkins’,’Galway’,’Irish’,000018);
INSERT INTO member VALUES(00000017,’Wesley’,’Hoolahan’,’Dublin’,’Irish’,000018);
INSERT INTO member VALUES(00000018,’Ollie’,’Cahill’,’Clonmel’,’Irish’,000018);
INSERT INTO member VALUES(00000019,’Stuart’,’Byrne’,’Dublin’,’Irish’,000018);
INSERT INTO member VALUES(00000020,’Alan’,’Crawley’,’Sligo’,’Irish’,000018);
INSERT INTO member VALUES(00000021,’Glen’,’Fitzpatrick’,’Dublin’,’Irish’,000018);
INSERT INTO member VALUES(00000022,’Jason’,’Byrne’,’Dublin’,’Irish’,000018);
INSERT INTO member VALUES(00000023,’Patrick’,’Holden’,’Kilkenny’,’Irish’,000022);
INSERT INTO member VALUES(00000024,’Neil’,’Andrews’,’Kilkenny’,’Irish’,000022);
INSERT INTO member VALUES(00000025,’John’,’Frost’,’Limerick’,’Irish’,000022);
INSERT INTO member VALUES(00000026,’Kevin’,’Doherty’,’Dublin’,’Irish’,000022);
INSERT INTO member VALUES(00000027,’Pat’,’Purcell’,’Dublin’,’Irish’,000022);
INSERT INTO member VALUES(00000028,’Stephen’,’Yelverton’,’Cork’,’Irish’,000022);
INSERT INTO member VALUES(00000029,’Alan’,’Reynolds’,’Waterford’,’Irish’,000022);
INSERT INTO member VALUES(00000030,’Sean’,’Finn’,’Dublin’,’Irish’,000022);
INSERT INTO member VALUES(00000031,’Kevin’,’Waters’,’Wexford’,’Irish’,000022);
INSERT INTO member VALUES(00000032,’Daryl’,’Murphy’,’Waterford’,’Irish’,000022);
INSERT INTO member VALUES(00000033,’Willie’,’Bruton’,’Cork’,’Irish’,000022);
INSERT INTO member VALUES(00000034,’David’,’Forde’,’Galway’,’Irish’,000022);
INSERT INTO member VALUES(00000035,’Dan’,’Connor’,’Dublin’,’Irish’,000007);
INSERT INTO member VALUES(00000036,’Damien’,’Lynch’,’Dublin’,’Irish’,000007);
INSERT INTO member VALUES(00000037,’Simon’,’Webb’,’London’,’English’,000007);
INSERT INTO member VALUES(00000038,’Steven’,’Grey’,’Dublin’,’Irish’,000007);
INSERT INTO member VALUES(00000039,’Stuart’,’Malcolm’,’Edinburgh’,’Scottish’,000007);
INSERT INTO member VALUES(00000040,’Graham’,’Gartland’,’Dublin’,’Irish’,000007);
INSERT INTO member VALUES(00000041,’Shane’,’Robinson’,’Waterford’,’Irish’,000007);
INSERT INTO member VALUES(00000042,’Sami’,’Ristilla’,’Valkeakoski’,’Finnish’,000007);
INSERT INTO member VALUES(00000043,’Declan’,’O\'’Brien’,’Dublin’,’Irish’,000007);
INSERT INTO member VALUES(00000044,’Mark’,’Rooney’,’Dublin’,’Irish’,000007);
INSERT INTO member VALUES(00000045,’Alan’,’Reilly’,’Dublin’,’Irish’,000007);
COMMIT;
But i am now getting this error about 45 time in a row and still a problem with the \'
ERROR 1054: Unknown column 'Michael' in 'field list'
It has a problem with the second column, which is Firstname
Any ideas ??