localtimestamp??current_timestamp????mysql????????

2020-09-11 文章 xuzh 
1??timestampvarchar??
2??
2020-09-09 15:25:55.416

local_dtm   
   | curr_dtm   
   | local_dtm_no_zone 
| curr_dtm_no_zone
  |
  | 
  | 
  | 
  |
2020-09-09 02:25:55.416 | 2020-09-08 18:25:55.416 | 2020-09-09 
02:25:55.416 | 2020-09-08 18:25:55.416 |



CREATE TABLE `sink2` (
 `local_dtm` varchar(100) DEFAULT NULL,
 `curr_dtm` varchar(100) DEFAULT NULL,
 `local_dtm_no_zone` varchar(100) DEFAULT NULL,
 `curr_dtm_no_zone` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8


drop table if exists sk;
CREATE TABLE sk (   
local_dtm TIMESTAMP,
curr_dtm TIMESTAMP,
local_dtm_no_zone  TIMESTAMP WITHOUT TIME ZONE,
curr_dtm_no_zone  TIMESTAMP WITHOUT TIME ZONE
)
WITH (
  'connector' = 'jdbc',
  'url' = 
'jdbc:mysql://10.12.5.37:3306/rs_report?useUnicode=trueamp;characterEncoding=UTF-8',
  'table-name' = 'sink2',
  'driver' = 'com.mysql.jdbc.Driver',
  'username' = 'dps',
  'password' = 'dps1234'
);


insert into sk values(localtimestamp,current_timestamp,localtimestamp   
,current_timestamp);


2020-09-09 15:25:55.416 

local_dtm   
   | curr_dtm   
   | local_dtm_no_zone 
| curr_dtm_no_zone
  |
  | 
  | 
  | 
  |
2020-09-09 02:25:55.416 | 2020-09-08 18:25:55.416 | 2020-09-09 
02:25:55.416 | 2020-09-08 18:25:55.416 |


----
??: 
   "xuzh"   
 <443435...@qq.com;
:2020??9??10??(??) 10:01
??:"xbjtdcq"

??????localtimestamp??current_timestamp????mysql????????

2020-09-11 文章 xuzh 
1??timestampvarchar??
2??
2020-09-0915:25:55.416

local_dtm   
   | curr_dtm   
   | local_dtm_no_zone 
| curr_dtm_no_zone
  |
  | 
  | 
  | 
  |
2020-09-0902:25:55.416 |2020-09-0818:25:55.416 
|2020-09-0902:25:55.416 |2020-09-0818:25:55.416 |






----
??: 
   "xuzh"

?????? localtimestamp??current_timestamp????mysql????????

2020-09-10 文章 xuzh 
CREATE TABLE product2 (
  id INT,
  prod_nm STRING,
 primary key(id)  NOT ENFORCED --  '??'
) 
WITH (
'connector' = 'jdbc',
'url' = 
'jdbc:mysql://10.12.5.37:3306/rs_report?useUnicode=truecharacterEncoding=UTF-8',
'table-name' = 'sink',
'driver' = 'com.mysql.jdbc.Driver',
'username' = 'dps',
'password' = 'dps1234'
);  







CREATE TABLE `sink2` (
  `local_dtm` varchar(100) DEFAULT NULL,
  `curr_dtm` varchar(100) DEFAULT NULL,
  `local_dtm_no_zone` varchar(100) DEFAULT NULL,
  `curr_dtm_no_zone` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8


drop table if exists sk;
CREATE TABLE sk (   



















 local_dtm TIMESTAMP,
 curr_dtm TIMESTAMP,
 local_dtm_no_zone   TIMESTAMP WITHOUT TIME ZONE,
 curr_dtm_no_zone   TIMESTAMP WITHOUT TIME ZONE
) 
WITH (
'connector' = 'jdbc',
'url' = 
'jdbc:mysql://10.12.5.37:3306/rs_report?useUnicode=truecharacterEncoding=UTF-8',
'table-name' = 'sink2',
'driver' = 'com.mysql.jdbc.Driver',
'username' = 'dps',
'password' = 'dps1234'
);


insert into sk values(localtimestamp,current_timestamp,localtimestamp   
,current_timestamp);


2020-09-09 15:25:55.416 

local_dtm   | curr_dtm| 
local_dtm_no_zone  | curr_dtm_no_zone   |
| | 
   | |
2020-09-09 02:25:55.416  | 2020-09-08 18:25:55.416 | 2020-09-09 02:25:55.416 | 
2020-09-08 18:25:55.416 |





----
??: "Leonard Xu"

localtimestamp??current_timestamp????mysql????????

2020-09-09 文章 xuzh 
Dear all??



 CREATE TABLE sink (
 id INT,
 prod_nm STRING,
 dtm timestamp,
 primary key(id) NOT ENFORCED -- '??'
 )
 WITH (
  'connector' = 'jdbc',
  'url' = 
'jdbc:mysql://10.0.0.0:3306/rs_report?useUnicode=truecharacterEncoding=UTF-8',
  'table-name' = 'sink',
  'driver' = 'com.mysql.jdbc.Driver',
  'username' = 'dps',
  'password' = 'dps'
 );

insert into sink
select id,prod_nm,current_timestamp from product;



mysql ??dtm 
??8??21

insert into sink
select id,prod_nm,localtimestamp from product;



mysql ??dtm ??8.