update user set password=PASSWORD('root') where user='root'; CREATE DATABASE `ufuturehk` DEFAULT CHARACTER SET latin1 COLLATE utf8_general_ci; CREATE TABLE IF NOT EXISTS `cu_tbl_dev_data` ( `devsn` varchar(50) CHARACTER SET utf8 NOT NULL, `devRegionID` varchar(50) CHARACTER SET utf8 NOT NULL, `devname` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `mAddTime` datetime DEFAULT NULL, `mUpdateTime` datetime DEFAULT NULL, `devID` tinyint(4) DEFAULT '0', PRIMARY KEY (`devsn`,`devRegionID`), UNIQUE KEY `devsn` (`devsn`), KEY `mNamw` (`devname`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8_general_ci; INSERT INTO `cu_tbl_dev_data` (`devsn`, `devRegionID`, `devname`, `mAddTime`, `mUpdateTime`, `devID`) VALUES ('04A0B9554A28828C', '9B3E60753DF802FB', '04A', '2019-01-23 18:04:25', '2019-01-23 18:04:25', 8), ('112233445566', '35AB8984CAE158BD', '公司自动门', '2019-01-18 10:32:55', '2019-01-22 22:20:33', 1); delete from cu_tbl_dev_data where devsn='04A0B9554A28828C'
使用单php文件工具 Adminer操作mysql数据库