Create table in mysql database in phpmyadmin panel
DROP TABLE IF EXISTS `tablename`;
CREATE TABLE IF NOT EXISTS `tablename` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`AdminUserName` varchar(255) NOT NULL,
`AdminPassword` varchar(255) NOT NULL,
`AdminEmailId` varchar(255) NOT NULL,
`Is_Active` int(11) NOT NULL,
`CreationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`UpdationDate` timestamp NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbladmin`
--
INSERT INTO `tbladmin` (`id`, `AdminUserName`, `AdminPassword`, `AdminEmailId`, `Is_Active`, `CreationDate`, `UpdationDate`) VALUES
(1, 'admin', 'password', 'admin@email.com', 1, '2019-02-10 17:51:00', '2019-02-15 08:52:44');
Comments
Post a Comment