sql - Mysql insert query to be fixed -


i have mysql query insert query giviing below mentioned error , not able figure why

1064 - have error in sql syntax; check manual corresponds mysql server version right syntax use near 'values ('edinburgh', 'edinburgh*glasgow' ,'loreum ipsim'), values ('newcastle', ' @ line 3

insert wp_widget_custom (name,centers,description)      values ('glasgow',  'glasgow*edinburgh' ,'loreum ipsim'), values ('edinburgh',    'edinburgh*glasgow' ,'loreum ipsim'), values ('newcastle',    'newcastle*middles-brough'  ,'loreum ipsim'), values ('leeds',    'leeds' ,'loreum ipsim'), values ('manchester',   'manchester'    ,'loreum ipsim'), values ('nottingham',   'nottinghamshire*lichfield' ,'loreum ipsim'), values ('lichfield',    'lichfield*birmingham*nottinghamshire'  ,'loreum ipsim'), values ('birmingham',   'lichfield*birmingham*milton-keynes'    ,'loreum ipsim'), values ('milton-keynes',    'milton-keynes*hemel-hempstead*hertfordshire'   ,'loreum ipsim'), values ('cardiff',  'cardiff*bristol-international' ,'loreum ipsim'), values ('bristol',  'bristol-international*bristol*cardiff' ,'loreum ipsim'), values ('plymouth', 'plymouth'  ,'loreum ipsim'), values ('southampton',  'southampton*hemel-hempstead*reading*maidenhead*slough' ,'loreum ipsim'), values ('reading',  'hemel-hempstead*hertfordshire*reading*maidenhead*slough*guildford' ,'loreum ipsim'), values ('slough',   'surrey*hertfordshire*hemel-hempstead*reading'  ,'loreum ipsim'), values ('hemel-hempstead',  'slough*surrey*guildford*bromley*london*billericay*hertfordshire*hemel' ,'loreum ipsim'), values ('london',   'hempstead*maidenhead'  ,'loreum ipsim'), values ('crawley',  'crawley*bromley*guildford*surrey*london'   ,'loreum ipsim'), values ('bromley',  'billericay*crawley*london*billiericay*bromley' ,'loreum ipsim'), values ('upminster',    'crawley'   ,'loreum ipsim'), values ('billericay',   'billericay*london*bromley' ,'loreum ipsim'), values ('livingston',   'edinburgh*glasgow' ,'loreum ipsim'), values ('renfrewshire', 'edinburgh*glasgow' ,'loreum ipsim'), values ('northumberland',   'newcastle' ,'loreum ipsim'), values ('west-yorkshire',   'leeds' ,'loreum ipsim'), values ('cheshire', 'manchester'    ,'loreum ipsim'), values ('nottinghamshire',  'nottinghamshire'   ,'loreum ipsim'), values ('staffordshire',    'lichfield*birmingham*nottinghamshire'  ,'loreum ipsim'), values ('warwickshire', 'milton-keynes*birmingham'  ,'loreum ipsim'), values ('northamptonshire', 'milton-keynes' ,'loreum ipsim'), values ('south-gloucestershire',    'bristol-international*bristol*cardiff' ,'loreum ipsim'), values ('north-somerset',   'bristol*bristol-international*cardiff' ,'loreum ipsim'), values ('devon',    'plymouth'  ,'loreum ipsim'), values ('hampshire',    'southampton*guildford*surrey*reading*maidenhead*slough'    ,'loreum ipsim'), values ('berkshire',    'southampton*maidenhead*reading*slough*surrey'  ,'loreum ipsim'), values ('maidenhead',   'guildford*hemel-hempstead*hertfordshire'   ,'loreum ipsim'), values ('surrey',   'surrey*guildford*reading*slough'   ,'loreum ipsim'), values ('sussex',   'bromley*crawley'   ,'loreum ipsim'), values ('kent', 'crawley'   ,'loreum ipsim'), values ('essex',    'bromley*sittingbourne*london*london*billericay*bromley'    ,'loreum ipsim'), values ('hertfordshire',    'hemel-hempstead*hertfordshire*slough*milton-keynes*maidenhead*slough'  ,'loreum ipsim'), values ('buckinghamshire',  'hemel-hempstead*hertfordshire' ,'loreum ipsim'), values ('oxfordshire',  'milton-keynes' ,'loreum ipsim'), values ('leicestershire',   'lichfield*nottinghamshire' ,'loreum ipsim'), values ('derbyshire',   'nottinghamshire*lichfield' ,'loreum ipsim'), values ('portsmouth',   'southampton'   ,'loreum ipsim'), values ('gloucester',   'bristol*milton-keynes*birmingham*lichfield'    ,'loreum ipsim'), values ('coventry', 'nottinghamshire'   ,'loreum ipsim'), values ('stoke-on-trent',   'manchester*lichfield*nottinghamshire'  ,'loreum ipsim'), values ('bolton',   'manchester*leeds'  ,'loreum ipsim'), values ('huddersfield', 'leeds' ,'loreum ipsim'), values ('liverpool',    'manchester'    ,'loreum ipsim'), values ('merseyside',   'manchester'    ,'loreum ipsim'), values ('leicester',    'birmingham*nottinghamshire'    ,'loreum ipsim'), values ('bradford', 'leeds' ,'loreum ipsim'), values ('wolverhampton',    'birmingham*lichfield*nottinghamshire'  ,'loreum ipsim'), values ('dudley',   'birmingham*lichfield*nottinghamshire*hemel-hempstead*hertfordshire*slough' ,'loreum ipsim'), values ('luton',    'maidenhead'    ,'loreum ipsim'), values ('preston',  'manchester'    ,'loreum ipsim'), values ('sunderland',   'newcastle*middlesbrough*birmingham*lichfield*nottinghamshire'  ,'loreum ipsim'), values ('walsall',  'manchester'    ,'loreum ipsim'), values ('swansea',  'cardiff'   ,'loreum ipsim'), values ('norfolk',  'thetford-forest'   ,'loreum ipsim'), values ('norwich',  'thetford-forest'   ,'loreum ipsim'), values ('hull', 'hull'  ,'loreum ipsim'); enter code here 

insert wp_widget_custom (name,centers,description) values      ('glasgow',  'glasgow*edinburgh' ,'loreum ipsim'), ('edinburgh',    'edinburgh*glasgow' ,'loreum ipsim'), ('newcastle',    'newcastle*middles-brough'  ,'loreum ipsim'), ('leeds',    'leeds' ,'loreum ipsim'), ('manchester',   'manchester'    ,'loreum ipsim'), ('nottingham',   'nottinghamshire*lichfield' ,'loreum ipsim'), ('lichfield',    'lichfield*birmingham*nottinghamshire'  ,'loreum ipsim'), ('birmingham',   'lichfield*birmingham*milton-keynes'    ,'loreum ipsim'), ('milton-keynes',    'milton-keynes*hemel-hempstead*hertfordshire'   ,'loreum ipsim'), ('cardiff',  'cardiff*bristol-international' ,'loreum ipsim'), ('bristol',  'bristol-international*bristol*cardiff' ,'loreum ipsim'), ('plymouth', 'plymouth'  ,'loreum ipsim'), ('southampton',  'southampton*hemel-hempstead*reading*maidenhead*slough' ,'loreum ipsim'), ('reading',  'hemel-hempstead*hertfordshire*reading*maidenhead*slough*guildford' ,'loreum ipsim'), ('slough',   'surrey*hertfordshire*hemel-hempstead*reading'  ,'loreum ipsim'), ('hemel-hempstead',  'slough*surrey*guildford*bromley*london*billericay*hertfordshire*hemel' ,'loreum ipsim'), ('london',   'hempstead*maidenhead'  ,'loreum ipsim'), ('crawley',  'crawley*bromley*guildford*surrey*london'   ,'loreum ipsim'), ('bromley',  'billericay*crawley*london*billiericay*bromley' ,'loreum ipsim'), ('upminster',    'crawley'   ,'loreum ipsim'), ('billericay',   'billericay*london*bromley' ,'loreum ipsim'), ('livingston',   'edinburgh*glasgow' ,'loreum ipsim'), ('renfrewshire', 'edinburgh*glasgow' ,'loreum ipsim'), ('northumberland',   'newcastle' ,'loreum ipsim'), ('west-yorkshire',   'leeds' ,'loreum ipsim'), ('cheshire', 'manchester'    ,'loreum ipsim'), ('nottinghamshire',  'nottinghamshire'   ,'loreum ipsim'), ('staffordshire',    'lichfield*birmingham*nottinghamshire'  ,'loreum ipsim'), ('warwickshire', 'milton-keynes*birmingham'  ,'loreum ipsim'), ('northamptonshire', 'milton-keynes' ,'loreum ipsim'), ('south-gloucestershire',    'bristol-international*bristol*cardiff' ,'loreum ipsim'), ('north-somerset',   'bristol*bristol-international*cardiff' ,'loreum ipsim'), ('devon',    'plymouth'  ,'loreum ipsim'), ('hampshire',    'southampton*guildford*surrey*reading*maidenhead*slough'    ,'loreum ipsim'), ('berkshire',    'southampton*maidenhead*reading*slough*surrey'  ,'loreum ipsim'), ('maidenhead',   'guildford*hemel-hempstead*hertfordshire'   ,'loreum ipsim'), ('surrey',   'surrey*guildford*reading*slough'   ,'loreum ipsim'), ('sussex',   'bromley*crawley'   ,'loreum ipsim'), ('kent', 'crawley'   ,'loreum ipsim'), ('essex',    'bromley*sittingbourne*london*london*billericay*bromley'    ,'loreum ipsim'), ('hertfordshire',    'hemel-hempstead*hertfordshire*slough*milton-keynes*maidenhead*slough'  ,'loreum ipsim'), ('buckinghamshire',  'hemel-hempstead*hertfordshire' ,'loreum ipsim'), ('oxfordshire',  'milton-keynes' ,'loreum ipsim'), ('leicestershire',   'lichfield*nottinghamshire' ,'loreum ipsim'), ('derbyshire',   'nottinghamshire*lichfield' ,'loreum ipsim'), ('portsmouth',   'southampton'   ,'loreum ipsim'), ('gloucester',   'bristol*milton-keynes*birmingham*lichfield'    ,'loreum ipsim'), ('coventry', 'nottinghamshire'   ,'loreum ipsim'), ('stoke-on-trent',   'manchester*lichfield*nottinghamshire'  ,'loreum ipsim'), ('bolton',   'manchester*leeds'  ,'loreum ipsim'), ('huddersfield', 'leeds' ,'loreum ipsim'), ('liverpool',    'manchester'    ,'loreum ipsim'), ('merseyside',   'manchester'    ,'loreum ipsim'), ('leicester',    'birmingham*nottinghamshire'    ,'loreum ipsim'), ('bradford', 'leeds' ,'loreum ipsim'), ('wolverhampton',    'birmingham*lichfield*nottinghamshire'  ,'loreum ipsim'), ('dudley',   'birmingham*lichfield*nottinghamshire*hemel-hempstead*hertfordshire*slough' ,'loreum ipsim'), ('luton',    'maidenhead'    ,'loreum ipsim'), ('preston',  'manchester'    ,'loreum ipsim'), ('sunderland',   'newcastle*middlesbrough*birmingham*lichfield*nottinghamshire'  ,'loreum ipsim'), ('walsall',  'manchester'    ,'loreum ipsim'), ('swansea',  'cardiff'   ,'loreum ipsim'), ('norfolk',  'thetford-forest'   ,'loreum ipsim'), ('norwich',  'thetford-forest'   ,'loreum ipsim'), ('hull', 'hull'  ,'loreum ipsim');

Comments

Post a Comment

Popular posts from this blog

jquery - Invalid Assignment Left-Hand Side -

i trying assign class tag via jquery, resulting in error through firebug says "invalid assignment left-hand side" on fourth line below. <cfoutput> $('.pngfix a').each(function(index) { var hreflink = $(this).attr("href"); if (hreflink.tolowercase() = '../audio.cfm') { $(this).addclass('audioimg'); } }); </cfoutput> looking around online, looks syntax problem, don't seem see it... any tips? thanks if (hreflink.tolowercase() = '../audio.cfm') that attempts assign value, rather check equality. change = operator == .
Read more

java - Play! framework 2.0: How to display multiple image? -

i need display gallery of photos. here template: @(photos: list[photo]) @title = { <bold>gallery</bold> } @main(title,"photo"){ <ul class="thumbnails"> @for(photo <- photos) { <li class="span3"> <a href="#" class="thumbnail"> <img src="@photo.path" alt=""> </a> </li> } </ul> } and here controller method: public static result getphotos() { return ok(views.html.photo.gallery.render(photo.get())); } and here photo bean : @entity public class photo extends model { @id public long id; @required public string label; public string path; public photo(string path, string label) { this.path = path; this.label = label; } private static finder<long, photo> find = new finder<long, photo>( long.class, photo.class); public static list<phot...
Read more

gmail - Is there any documentation for read-only access to the Google Contacts API? -

i want read-only access user's google contacts. there stackoverflow member wanted this, , received following answer : yes, there is, use https://www.googleapis.com/auth/contacts.readonly scope , "view contacts". this exchange reference read-only access google contacts can find using google. simply using access token obtained attempt read usual google contacts api (i.e. https://www.google.com/m8/feeds ) fails insufficient permissions. similarly, using google contacts api on new target fails 404 errors (for example https://www.googleapis.com/auth/contacts.readonly/default/full ). is there documentation anywhere on how use api, or permissible way access google contacts api full read-write access?
Read more