We have been using database nodes for working on data present in MySQL database.
I would like to know if we can perform the below listed operations on the data :
1.How to run data manipulation queries in Database Query node
2.How to change the name of a column through Database query
3.Cross join in KNIME through sql / Database nodes
4.How are missing values treated in Database node
There are some posts in the forum which suggest to use column rename node and write the data to database but we would like to directly execute these queries on the database using SQL nodes.
Any ideas and suggestions will be highly appreciated.
Thanks in advance.