a1658616397的博客

SELECT *, abs(UNIX_TIMESTAMP(begin_time)-UNIX_TIMESTAMP('2019-04-08')) as min from ox_hand_machine_activity_device GROUP BY min desc 注 abs方法 取绝对值排序

UPDATE cacrm_ca_crm_user SET job_code=REPLACE( REPLACE( REPLACE( REPLACE(job_code,CHAR(34),''), CHAR(13), '' ), CHAR(10), '' ), CHAR...

SELECT * FROM ( SELECT c.id, a.`name`, r.`name` as rname, m.`name` as mname FROM cacrm_ca_crm_user c LEFT JOIN cacrm_ca_crm_user a ON a...

package main import ( "fmt" "github.com/xuri/excelize" "log" "reflect" "strconv" "time" ) type ExcelData interface { CreateMap(arr []string) map[string]interface{} ChangeTim...

SELECT u.openid,u.nickName,o.order_id,o.real_total_fee,i.venue_id,GROUP_CONCAT(i.time SEPARATOR ',') as time,GROUP_CONCAT(i.time_zone SEPARATOR ',') as time_zone,o.payment,o.state,o.created_at FRO...

SELECT u.openid,o.user_name,o.student_phone,o.order_id,o.price,o.payment,c.duration,o.course_num,t.courses_type,a.coach_name,concat_ws('-',o.created_at,o.over_time) as expire_time,c.is_field,o.cla...

create table cacrm_ca_crm_user_new like cacrm_ca_crm_user insert into cacrm_ca_crm_user_new select * from cacrm_ca_crm_user

SELECT g.* FROM ( SELECT SUM( IF ( a.`status` = 'xcasd' OR a.`status` = 'safasf' OR a.`status` = 'd进' OR t.`status` = "dfsdf", 1, 0 ) ) AS kj_conversion, SUM( IF ( b.`type` = '士大夫', 1,...

CREATE PROCEDURE addCacrmUser ( ) BEGIN DECLARE error INTEGER DEFAULT 1; DECLARE existsFlag VARCHAR ( 255 ) DEFAULT ""; DECLARE back_id VARCHAR ( 255 ) DEFAULT ""; ...