5 messages in com.mysql.lists.win32Re: SQL insert will not work| From | Sent On | Attachments |
|---|---|---|
| grov...@linkhomes2000.co.uk | 19 Oct 2005 09:26 | |
| Nurse, Robert (Cont, ARL/CISD) | 19 Oct 2005 09:39 | |
| Armando | 19 Oct 2005 12:56 | |
| Chuck Mabbott | 19 Oct 2005 13:26 | |
| Armando | 20 Oct 2005 05:39 |
| Subject: | Re: SQL insert will not work |
|---|---|
| From: | Armando (diji...@shaw.ca) |
| Date: | 10/19/2005 12:56:31 PM |
| List: | com.mysql.lists.win32 |
What is the structure of your table? What types are each of the fields?
grov...@linkhomes2000.co.uk wrote:
Hello,
Can anyone please explain why the following INSERT INTO query will not work. Using phpMyadmin, no error messages, it seem to insert all NULL values, but nothing else:
INSERT INTO buyers (buyers_id,first_name,middle_name,last_name,house_name_number,street_name,to wn,county,post_code,landline,mobile,email_address,fax_number,date,solicitor)
VALUES (NULL,'David','Athoney','Hopkins',25,'My Street','Some Town','This County','PR7 7TT',0114455887,NULL,NULL,NULL,NULL,NULL),
(NULL,'George',NULL,'Braod',45,'Do Street','Done Town','Upper County','PB7 0NN',0011998777,NULL,NULL,NULL,NULL,NULL),
(NULL,'Andy','Brown','Burrel',44,'Dont Street','Do Town','Lower County','PC9 1LL',5588994476,NULL,NULL,NULL,NULL,NULL),
(NULL,'Jeff',NULL,'Brand',145,'Did Street','Donte Town','middle Upper County','TH0 0YY',856478955,NULL,NULL,NULL,NULL,NULL),
(NULL,'Don','Brian','Bradban',5,'Doop Street','Downe Town','last Upper County','0PP MM0',5566447788,NULL,NULL,NULL,NULL,NULL),
(NULL,'Geo','Hartfelt','Donnington',345,'Alldo Street','None Town','Upper-Lower County','OO9 II8',775588994,NULL,NULL,NULL,NULL,NULL);
used for test purposes only..
DG)