摘要:
CREATE TABLE tab1_bak LIKE sys_dictionary_details; INSERT INTO tab1_bak SELECT * FROM sys_dictionary_details; DROP TABLE sys_dictionary_details; ALTER 阅读全文
摘要:
对于新建表的情况,可以在新建表时添加AUTO_INCREMENT = 100(起始值), MySQL> CREATE TABLE IF NOT EXISTS `TaskTemplate` (`id` INT NOT NULL AUTO_INCREME NT PRIMARY KEY ,`name` V 阅读全文
摘要:
mysql -u用户名 -p密码 mysql> use 数据库 mysql> SELECT columnID,alias,parentID FROM `cms_column` WHERE alias LIKE '%家庭影院%' OR parentID='144500' into outfile '/ 阅读全文