- 博客(4)
- 收藏
- 关注
原创 关于mysql中的like语句带参数问题
一个题目引入:查询与“B1100”银行在同一城市(假设银行名称的第5和第6个字符为城市名称)的其他的银行的名称。表结构:数据:这里首先有一个问题,如何获取第五个和第六个字符。采用mysql的substr方法。SUBSTR(str FROM pos FOR len)//str为字符串对象,pos为开始位置(mysql索引从1开始),length表示截取的长度
2016-04-02 23:57:57
5671
原创 HDU 2141
Can you find it?Time Limit: 10000/3000 MS (Java/Others) Memory Limit: 32768/10000 K (Java/Others)Total Submission(s): 10874 Accepted Submission(s): 2846Problem DescriptionGive yo
2014-07-22 16:32:24
405
原创 PKU 3122
PieTime Limit: 1000MS Memory Limit: 65536KTotal Submissions: 10130 Accepted: 3580 Special JudgeDescriptionMy birthday is coming up and traditionally I'm serving
2014-07-22 16:17:14
285
原创 PKU 3187
DescriptionFJ and his cows enjoy playing a mental game. They write down the numbers from 1 to N (1 <= N <= 10) in a certain order and then sum adjacent numbers to produce a new list with one fewer
2014-07-22 15:28:31
362
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人