Question : How to generate a create table script for an existing table in php/Codeigniter
Answered by : smoggy-snail-oxzcna49n0ag
//PHP
SHOW CREATE TABLE tablename
// FOR CODEIGNITOR
HOW CREATE TABLE $table_name";
$query = $this->db->query($sql);
echo '<pre>'; print_r($query->result());
Source : https://stackoverflow.com/questions/11739014/how-to-generate-a-create-table-script-for-an-existing-table-in-phpmyadmin | Last Update : Mon, 02 Aug 21