I want to create a duplicate table in dashDB (with or without the original data, it does not really matter, the table structure is what is important). I tried:SELECT * INTO new_table FROM old_table;
but I get this error:"new_table" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=3.69.56
I also tried:CREATE TABLE new_table AS (SELECT * FROM old_table);
but i get this error:An unexpected token "END-OF-STATEMENT" was found following "AS (SELECT * FROM old_table". Expected tokens may include: "WITH DATA, WITH NO DATA".. SQLCODE=-104, SQLSTATE=42601, DRIVER=3.69.56
- type casting boost multiprecision integer returns wrong answer
- Using vaultr in R to pull a password from Hashicorp Vault
- set a user's secondary calendar as selected in apps script
- what is the best algorithm for this problem
- TypeError: 'coroutine' object is not subscriptable in python Quart Framework
- Can we perform (modulation operation)% on negative integers? what will be result?
- JSONObject text must begin with '{' at 1 [character 2 line 1] , yet JSON is valid and code works with a differently formatted JSON file
- Understand the “Observer Pattern” with a real world example
- aggregation search request Elasticsearch DSL
- Hibernate ColumnTransformer and DataJpaTest