Mysql

INSERT INTO TPersonnelChange( UserId, DepId, SubDepId, PostionType, AuthorityId, ChangeDateS, InsertDate, UpdateDate, SakuseiSyaId)SELECT UserId, DepId, SubDepId,

SELECT    case gender WHEN 1 THEN “NAN” WHEN 0 THEN “NV”end  as genderFROMt_swidy_day_nutrient

DELETE FROM purchase_suppliers_contract_materials_sourceWHERE PSCMS_ID in( SELECT PSCMS_ID FROM( SELECT p1.PSCMS_ID FROM purchase_suppliers_contract_materials_source AS p1 LEFT JOIN materials A

数据库中查到所有的表SELECTtable_nameFROMinformation_schema. TABLESWHEREtable_schema = “db-mayn-erp-test”AND table_type = “base table”; 把这个表结果拷贝到excel中,使用筛选功能，筛选包含_bak表 将筛选的_bak表列放在另外一个列中，在B列输入：=”DROP TABLE IF

— 查询符合条件的表SELECT CONCAT(“truncate table “, table_name, “;”) FROMinformation_schema. TABLESWHEREtable_schema = “db-mayn-erp-test”AND TABLE_NAME LIKE “%purchase%”AND table_type = “base table”;– user 你

检测损坏图片并根据我们的选择加以替换。$(“img”).error(function(){ $(this).attr(“src”, “img/broken.png”); });

select count(name) from syscolumns where id = object_id(“表名”)

Windows键+r键 mysql –uroot –p 输入密码 use 数据库名 set names utf8; source C:UsersAdministratorDesktopm.sql

mysqldump -u 用户名 –p输入密码数据库名 >导入到的文件地址名实例：mysqldump -u root -p ms-bbs>C:UsersAdministratorDesktopms-bbs.sql