摘要:
insert into urls(company,counterType,mdUrl,tradeUrl) values('test', CASE 'test'WHEN 'CTP' THEN 1WHEN 'NULL' THEN 2WHEN '飞鼠' THEN 3WHEN '飞鼠 FIX' THEN 4 阅读全文
摘要:
数据库表中id列不为自动增加,需要程序来增加id的SQL SELECTCASE IFNULL(MAX(id),1)WHEN 1 THEN 1ELSE MAX(id) + 1END AS newmaxidFROM test 阅读全文