sql - Error Code: 1452. Cannot add or update a child row: -



sql - Error Code: 1452. Cannot add or update a child row: -

a foreign key constraint fails (ldatabase.book, constraint bpid foreign key (bpid) references publish (pid) on delete no action on update no action) insert ldatabase.book (bid, title, author, bpid, available, language) values (20, 'dsp', 'kevin', 01, 10, 'eng')

i have created tables , inserted values publish table.. when trying come in values book table .. due misfortune have encountered error

posted error indicates that, column bpid in table ldatabase.book has foreign key relationship publish table pid column.

which means, before insert bpid key in book table create sure same key (pid) exists in publish table else end above posted error.

sql

Comments

Post a Comment

Popular posts from this blog

php - How to pass multiple values from url -

php - How to pass multiple values from url - i'm trying pass textbox , 1 select result value 1 page page.using url.but it's display error message. "parse error: syntax error, unexpected '' (t_encapsed_and_whitespace), expecting identifier (t_string) or variable (t_variable) or number (t_num_string) in c:.." while($value= mysqli_fetch_assoc($result)){ $apid=$value['apid']; echo("<tr> <td>". $value['apid'] ."</td> <td>".$value['email']."</td> <td>".$value['comments']."</td> <td>".'<input type="text" name="payment"/>'."</td> <td>"."<input type='text' name='apid' value='".$apid."' style='visibility:hidden' size='2'>"."</a>"."<a hre...
Read more

php - Laravel not returning controller -

php - Laravel not returning controller - i have simple ajax() request that's supposed add together coupon if take take (via pop tag). however, when run page , click on tag , @ in console it's doing returning entire page in html. how can utilize controller specify via routes? new ajax sure that's problem is. what's supposed happen client clicks on take coupon button, ajax processes info controller , shows modal letting them know coupon has been added successfully. a tag <a href="#" class="btn btndefault btnsmall" id="ajaxcoupon">add coupon cart , go on shopping <i class="fa fa-arrow-right"></i></a> ajax $('#ajaxcoupon').click(function(e){ e.preventdefault(); $.get('ajaxaddcoupon', function(data){ $('#successcoupon').foundation('reveal', 'open'); }); }); controller & route ...
Read more

c# - Confused on how to specify a Platform and Version while using ChromeOptions for RemoteWebDriver with Selenium donNet since recent updates -

c# - Confused on how to specify a Platform and Version while using ChromeOptions for RemoteWebDriver with Selenium donNet since recent updates - using c# selenium 2.39 , before, able interact chromeoptions , desiredcapabilities directly. so, if wanted emulate android device on modern version of windows, code snippet might this: // define chromeoptions create chrome deed mobile device chromeoptions options = new chromeoptions(); options.addargument("--user-agent=mozilla/5.0 (linux; android 4.0.4; galaxy nexus build/imm76b) applewebkit/535.19 (khtml, gecko) chrome/18.0.1025.133 mobile safari/535.19"); options.addargument("--disable-sync-passwords"); capabilities = desiredcapabilities.chrome(); //needed find win7 vm rather linux or mac capabilities.setcapability("platform", "vista"); //cef apps tested using selenium2 , grid. //a version of "real" has ...
Read more