PHP-MySQLi-Database-Class icon indicating copy to clipboard operation
PHP-MySQLi-Database-Class copied to clipboard

Request: create, alter and drop table

Open qaharmdz opened this issue 10 years ago • 2 comments

Until now I always use $db->rawQuery() for create, alter and drop table. It would be perfect if this is available build in. May be something like this

$db->column('id', 'int(11)', 'unsigned NOT NULL AUTO_INCREMENT')
   ->column('status', "enum('yes','no')", "NOT NULL DEFAULT 'no'")
   ->column('created', 'datetime', "NOT NULL DEFAULT '0000-00-00 00:00:00'")
   ->keyPrimary('id')
   ->key('key_name', array('status', 'created'))
   ->tableCreate('user')

qaharmdz avatar Sep 08 '15 14:09 qaharmdz

+1

hirbod avatar Sep 12 '15 04:09 hirbod

+1

themonk30 avatar Jun 17 '21 06:06 themonk30