The previous chapter showed you how to use INNER JOIN and LEFT JOIN to retrieve information stored in multiple tables. You also learned how to link existing tables by adding an extra column to the child table and updating each record individually to insert a foreign key. However, most of the time you’ll want to insert data simultaneously in both tables. That presents a challenge, because INSERT commands can operate on only one table at a time. You need to handle the insert operations in the correct sequence, starting with ...
© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022
D. PowersPHP 8 Solutionshttps://doi.org/10.1007/978-1-4842-7141-4_1818. Managing Multiple Database Tables
David Powers1
(1)
London, UK
Get PHP 8 Solutions: Dynamic Web Design and Development Made Easy now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
