MySQL data calculation

This article provides an implementation plan for MySQL data computing scenarios, including configuration examples, execution steps, and parameter descriptions.

Case description

Calculate data in MySQL

Case implementation

CREATE TABLE table1
USING JDBC
OPTIONS (
    driver 'com.mysql.cj.jdbc.Driver',
    url 'jdbc:mysql://147.192.168.116:30102/ispong_db',
    user 'ispong',
    password 'ispong123',
    dbtable 'zqy_users_jdbc'
);

select * from table1;