CodeIgniter Forums
Create two table in one create statement - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Create two table in one create statement (/showthread.php?tid=14262)



Create two table in one create statement - El Forum - 12-25-2008

[eluser]nandish[/eluser]
Hi guys

Is there any way, to create two tables in one create statement.


Thanks in advance.


Create two table in one create statement - El Forum - 12-27-2008

[eluser]kgill[/eluser]
Pretty much nope, you'd have to change most of CI's database classes to accomplish it. If you want to drop into straight PHP then yes it's possible depending on the database you're using, mysql for example supports it (mysqli_multi_query) while oracle doesn't.