mysql - SQL PHP INSERT INTO tables -


is possible insert multiple tables this?

select first_name, last_name, feet, inche, weight, dob, college, pob, experience, cy, py player  inner join attribute on player.pid = attribute.pid inner join history on player.pid = history.pid inner join salary on player.pid = salary.pid 

how join tables for:

if(!($stmt = $mysqli->prepare("insert player(first_name, last_name) values (?, ?)"))){    echo "prepare player failed: "  . $stmt->errno . " " . $stmt->error; } if(!($stmt->bind_param("ss", $_post['first_name'],$_post['last_name']))){     echo "bind failed: "  . $stmt->errno . " " . $stmt->error; } 

mysql doesn’t support insert multiple tables via single insert statement, believe oracle support it.

but can use transaction make sure insert statements execute via single transaction.


Comments

Popular posts from this blog

commonjs - How to write a typescript definition file for a node module that exports a function? -

openid - Okta: Failed to get authorization code through API call -

ios - Change Storyboard View using Seague -