Топ-100
 
CerebroSQL

Openlist procedure

Procedureopen listserves for the possibility of using a database connection from one sheet in another.

 

The procedure is supported in 2 operations:createandinsert.

IMPORTANT: data transfer is carried out in text form, i.e. on the receiver side, the table will be created with fields of type Text or varchar, depending on the DBMS

Openlist - create table

CREATE construct

Syntax:

create table <table name> as openlist(' <Sheet name> ',' <Query to execute on source side> ')

 

Requirements:

  • escaping quotes inside a query is not allowed

  • only data types that can be cast to text are supported

The query: 06.11.2021 13:56:12
Query text: create table mysql_tables as 
...
---------------------------------------------------------
Position: 35
##################Remote query##################
select * from tdb.my_catalog
##################Parameter##################
Remote list name: LIST2
Remote list type: MYSQL
Current list name: LIST1
Current list type: PG
####################Command####################
create table mysql_tables as 
 
Code: 301
Count: 4
select * from tdb.my_catalog
mysql_tables
Toper: 3
create table mysql_tables ( "TABLE_CATALOG" Text, "TABLE_SCHEMA" Text, "TABLE_NAME" Text, "TABLE_TYPE" Text, "ENGINE" Text, "VERSION" Text, "ROW_FORMAT" Text, "TABLE_ROWS" Text, "AVG_ROW_LENGTH" Text, "DATA_LENGTH" Text, "MAX_DATA_LENGTH" Text, "INDEX_LENGTH" Text, "DATA_FREE" Text, "AUTO_INCREMENT" Text, "CREATE_TIME" Text, "UPDATE_TIME" Text, "CHECK_TIME" Text, "TABLE_COLLATION" Text, "CHECKSUM" Text, "CREATE_OPTIONS" Text, "TABLE_COMMENT" Text)
Table create - successful
Starting load data
Rows transferred: 356 [ALL ROWS:356]
Run time:  0.333c.
Log operation
D:\CerebroSQL\CerebroSQL 21.11\tmp\lists\openist2021_11_06_135612.log
D:\CerebroSQL\CerebroSQL 21.11\tmp\lists\openist2021_11_06_135612.query