Skip to main content

Sink data from RisingWave to TiDB with the JDBC connector

As TiDB is compatible with MySQL, you can sink data to TiDB the same way you would sink data to MySQL with the JDBC connector.

For the syntax, settings, and examples, see Sink data from RisingWave to MySQL with the JDBC connector.

Data type mapping

The following table shows the corresponding data types between RisingWave and TiDB. For details on native RisingWave data types, see Overview of data types.

RisingWave typeTiDB type
BOOLEANBOOLEAN
SMALLINTTINYINT/SMALLINT
INTINT/MEDIUMINT
BIGINTBIGINT
REALFLOAT
DOUBLEDOUBLE
DECIMALDECIMAL
DATEDATE
TIMESTAMPDATETIME
TIMETIME
TIMESTAMPTZTIMESTAMP
VARCHARVARCHAR/CHAR/TEXT/TINYTEXT/
MEDIUMTEXT/LONGTEXT
BYTEAVARBINARY/BINARY/BLOB/TINYBLOB/
MEDIUMBLOB/LONGBLOB
JSONBJSON

Help us make this doc better!