Create Table

[Markus3003]

Hi guys,
I am quit new with SQL and I do have a problem. Please check my screenshots, so hopefully someone can help

1.) I created a table with 4 columns:

2.) I created a dataframe


Everything worked so far...

3.) I want to insert the Data in the table, but the I get the following error:



So the statement says I created only 3 columns, but I did 4!

Thank you for any help!

Best Markus

 

[ukulele]

If you execute a SELECT * FROM tbl_... do you get 3 or 4 clumns?
You could/should always specify the columns to insert in and to select from, don't use SELECT * in productive code. So please try

INSERT INTO target(col1,col2) SELECT col1,col2 FROM source