mysql
t我的猫呢
这个作者很懒,什么都没留下…
展开
-
mysql实现将 两个字段合并成一个字段查询
mysql实现将 两个字段合并成一个字段查询CONCAT()函数用于将多个字符串连接成一个字符串。 SELECT d.psl_code, d.psl_name, concat( d.psl_code,",",d.psl_name) as w FROM monthly_bill_detail_price_library d WHERE d.source_no in ("bbbbbb1222")原创 2022-01-10 17:43:28 · 10151 阅读 · 0 评论 -
mysql与sql server中sql语句的差异
1.搜索数据的前十条数据;mysql :select * from test limit 10sql serverselect top 10* from test2,数据分页mysql:@page_size一个多少条数据@pageNum 第几页select * from test limit (pageNum-1)*page_size,page_sizesql server:select top ${page_size} * from(select row_number() o原创 2020-12-07 13:59:08 · 127 阅读 · 0 评论 -
sql语句的简单查询 插入修改和删除
简单查询1,查询所有字段select * from test2,查询单个字段select name from test3,查询表的多个字段select name,age from test4,给字段命名第一种方式select name as n,age as a from test第二种方式 也可以把as 去掉select name n,age a from test5,给表命名也跟字段命名一样select * from test as t也可以去掉where语原创 2020-10-14 15:53:47 · 731 阅读 · 0 评论 -
sql批量查询
将传入的字符串进行处理let b = 'A1B560,AC2909' b = b.split(',') c = '('for(let i=0;i<b.length;i++){ c += "'" + b[i] +"'"+','}let lent = c.length-1c = c.substr(0,lent)c+=')'console.log(c)处理成('A1B560','AC2909')sql语句select * from class where code原创 2020-10-28 13:21:19 · 2485 阅读 · 0 评论 -
sql语句统计最近七天,30天的数据, 统计当天数据总和,统计当天每小时的数据,今日金额的支出
SELECT date_format( a.date, '%c.%d' ) times, b.count AS totals FROM (SELECT curdate( ) AS date UNION ALLSELECT date_sub( curdate( ), INTERVAL 1 DAY ) AS date UNION ALLSELECT date_sub( curdate( ), INTERVAL 2 DAY ) AS date UNION ALLSELECT date_su原创 2021-03-29 09:50:22 · 5139 阅读 · 2 评论