sql经验
YQG123456
这个作者很懒,什么都没留下…
展开
-
sql注入问题
在工厂里面做的几个应用程序登陆验证都是如下: [code="java"] String hql = "from UserPower as u where u.username = '" + user + "' and u.password ='" + psw + "'"; [/code] 今天我的同学发现了这个SQL注入的问题,赶紧把这个问题点给修复了. [img][/img]...2008-06-23 21:02:20 · 105 阅读 · 0 评论 -
周生产计划导出SQL语句
select z.zdid as 站点编号,z.jhdhid as 计划单号编号,z.ddid as 订单ID,k.khmc as 客户名称,dd.ddhm as 订单号码,k.ddxh as 订单型号,ddmx.ddl as 订单量,ddmx.ddscl as 订单生产量,z.scrq as 备料日期,z.xll as 排产量,k.zsxs as 系数,z.wcrq as 完成日期,ddmx....2008-04-24 12:46:59 · 279 阅读 · 0 评论 -
查看表中两个字段相同的
SELECT * FROM zcyj_20080406140017 a INNER JOIN zcyj_20080406140017 b ON a.jtbh = b.jtbh AND a.dqzd = b.dqzd AND a.id b.id2008-04-15 11:30:29 · 130 阅读 · 0 评论 -
mssql数值列转化为文本列
将电话列以文本方式转化为电话2列 UPDATE rs SET 电话2 = CAST(CAST(电话 AS DECIMAL(20, 0)) AS VARCHAR(20))2008-10-05 09:56:17 · 884 阅读 · 0 评论 -
修改mysql root密码的方法
修改mysql root密码的方法 1.通过修改MYSQL数据库中MYSQL库的USER表就用普通的UPDATE、INSERT语句就可以 use mysql update user set Password=password('newpassword') where User='root'; flush privileges; 2.在命令行中使用如下命令 ...2008-10-05 09:53:59 · 128 阅读 · 0 评论 -
查询盘点时未盘到的吉他
制四课未盘点到的吉他 SELECT a.jtbh, c.ddhm, e.khxh, d.zdbh FROM jitajh a INNER JOIN jtscjd b ON a.id = b.id INNER JOIN dingdan c ON a.dingdanid = c.id INNER JOIN zhandian d ON b.zdid = ...2008-10-02 12:03:40 · 157 阅读 · 0 评论 -
一个表更新另一个表
[code="java"]UPDATE rs SET 转正时间 = (SELECT TOP 1 zz.转正时间 FROM zz WHERE zz.序号 = rs.管理号) [/code] [code="java"] update design_file set type = '物料' where type is NULL o...2008-08-26 13:26:11 · 126 阅读 · 0 评论 -
stock_blance_design_file_view创建
[code="sql"] CREATE VIEW `stock_blance_design_file_view` AS select `s`.`id` AS `id`,`s`.`FIRST_KIND_ID` AS `FIRST_KIND_ID`,`s`.`FIRST_KIND_NAME` AS `FIRST_KIND_NAME`,`s`.`SECOND_KIND_ID` AS `SECOND_...2008-07-04 15:48:18 · 121 阅读 · 0 评论 -
查询表1中有而表2中没有的
1. 表结构必须相同: select * from 表1 where not exists (select * from 表2 where 表1.字段A = 表2.字段A) 如: select * from tsxx where not exists (select * from pandian where pandian.tsbh2 = tsxx.tsbh) 2. select ...2008-06-03 21:12:14 · 589 阅读 · 0 评论 -
批量替换access里面某字段字符串
update content SET title = replace(title,"","")2009-01-06 19:36:39 · 1769 阅读 · 0 评论