sql 2018-03-15

最新推荐文章于 2022-07-31 07:30:17 发布

原创最新推荐文章于 2022-07-31 07:30:17 发布 · 220 阅读

0 ·

CC 4.0 BY-SA版权

database 专栏收录该内容

45 篇文章

订阅专栏

本文展示了一系列SQL查询与操作示例，包括基本的查询、删除、插入等操作，并涉及了表的创建与数据导入等内容。这些示例适用于数据库管理和维护场景。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

select * from t_fb_form where id ='701a3fc7-ac3b-4043-85b2-c323ec0e310e'

select * from t_fb_dis_form where form_id= '701a3fc7-ac3b-4043-85b2-c323ec0e310e'

select * from t_Sys_User where id='86561aa5a7ac49e7bff21bb05b7764fe'

select * from t_fb_batch_form where  BATCH_ID='9f972507e6ab4684a115b2083724a380'

delete from t_fb_fill_in_batch where id = 'b222962871104c9bb17d3dbb55bfacf2';

select * from T_FB_BATCH_FORM where batch_id = 'b222962871104c9bb17d3dbb55bfacf2';


SELECT * FROM SU_JZGJBXX_2017 where xm like '%杨%';
SELECT SYS_GUID() FROM dual;

CREATE TABLE T_SYS_USER_20180315zwf AS SELECT * FROM T_SYS_USER;
CREATE TABLE T_SYS_USER_DETAIL_20180315zwf AS SELECT * FROM T_SYS_USER_DETAIL;

select * from t_sys_user where id in ('e9d8f26d25a54640964a10efadcdda0e', 'b2d6a20a77764fbf8a57c9096b925262', '483fefe873f3416c969ecac6cf1f0e95');
select * from t_sys_user_detail where id in ('e9d8f26d25a54640964a10efadcdda0e', 'b2d6a20a77764fbf8a57c9096b925262', '483fefe873f3416c969ecac6cf1f0e95');
select * from t_sys_user_role where role_id = '0';

SELECT * FROM T_SYS_USER_20180315zwf;
SELECT * FROM T_SYS_USER_DETAIL_20180315zwf;

SELECT * FROM T_SYS_USER;
SELECT COUNT(1) FROM SU_JZGJBXX_2017;


DELETE FROM t_sys_user where id in ('e9d8f26d25a54640964a10efadcdda0e', 'b2d6a20a77764fbf8a57c9096b925262', '483fefe873f3416c969ecac6cf1f0e95');
DELETE FROM t_sys_user_detail where id in ('e9d8f26d25a54640964a10efadcdda0e', 'b2d6a20a77764fbf8a57c9096b925262', '483fefe873f3416c969ecac6cf1f0e95');


INSERT INTO T_SYS_USER
(
ID,
ACCOUNT,
PWD,
NAME,
SEX,
BIRTHDAY,
STATUS,
REGISTTIME,
LOGIN_FLAG,
USER_FLAG
)
SELECT
       SYS_GUID(), 
       GH,
       'E10ADC3949BA59ABBE56E057F20F883E',
       XM,
       (CASE XB 
         WHEN '男' THEN '1' 
         WHEN '女' THEN '0' 
       ELSE '99' END) AS XB,
       TO_DATE(CSNY, 'YYYY-MM'),
       '0',
       TO_DATE(RXSJ, 'YYYY-MM'),
       '1',
       '0'
FROM SU_JZGJBXX_2017;


CREATE TABLE T_SYS_USER_201803151014 AS
SELECT * FROM T_SYS_USER;

select * from T_SYS_USER_201803151014

UPDATE T_SYS_USER SET birthday = NULL;