|
|
请使用QQ关联注册PLM之家，学习更多关于内容，更多精彩原创视频供你学习！
您需要 登录 才可以下载或查看，没有账号？注册
×
* v: P2 ?2 o% d. W# l数据库： 禁止重复数据插入数据库的方法，没有主键和索引
! I+ l7 }* m3 u6 ]+ C+ E0 P; a$ |* L8 {- Q- f
直接进行硬核判断，查询是否有一致的值，因为当前表中不存在主键: L% J0 V! @1 B" N: o, D
6 x0 _9 ~; c% y- Y8 U; s[mw_shl_code=sql,true]INSERT INTO ingate_standardsection SELECT
! ^) ]5 \. w& f) T! ~'扁平梯形',8 S) y" O! I& M$ E" ~
'FlatTrapezoidSection.bmp',
7 d- I- ]" T# Z* q! l5 X: u3.75,
7 D" U% H" h j, T \( [50,0 e6 o/ U8 H0 N$ K& Y9 V* c1 }
25,
8 t# k3 @: ^/ t' K9 `& a10,* J! m9 @# z8 m% H) L3 N6 l. [7 m
'dddddd',- l8 b$ `, \% L4 F% T4 g1 F1 ?
'udf' % R* m- D5 O! t1 f* r
FROM
7 K# @% F, \7 y+ i0 }DUAL
0 Q) @5 P5 Y LWHERE0 @3 N* v- E/ ^
NOT EXISTS (7 [. Z ^- C3 g" @
SELECT' O# |6 H6 c5 |7 ^
1 1 T, v0 }' ~' @+ ?3 V. M8 |: |' @0 U
FROM i' `7 e6 y0 s$ a6 }. e0 A6 V
ingate_standardsection + M: s9 y. {/ X! t4 R+ ~# \0 m! E0 Y
WHERE
7 m3 Q) z( S0 f5 T2 o+ y section_type = '扁平梯形'
" g+ W$ s9 h8 S& I7 k" z6 ] AND section_bmp = 'FlatTrapezoidSection.bmp' @+ V9 a9 O/ O, T* \+ q
AND CONCAT( section_area, '' ) = '3.75' - ] n9 c% X4 D$ Z" b3 m0 d3 H/ N
AND CONCAT( section_dima, '' ) = '50'
& W) u8 z$ {4 z2 P AND CONCAT( section_dimb, '' ) = '25' 0 k# s5 Q# h* h! K% M" c2 P
AND CONCAT( section_dimc, '' ) = '10'
; r+ K( U9 |: P AND section_from = 'udf'
6 }7 w4 q' {6 V! z- \ ). D, ~7 e: o& L! |7 b' f5 ~. I
/ u7 Y3 k2 I3 l" p
[/mw_shl_code] c" m, G2 n" u/ G
|
|
发表于 2022-5-4 10:18:21
