This is a part of a script which the whole script runs without errors. I followed the script and made minor changes, just by changing names, etc and discarded few commands like ‘create or replace force view’, sequences. This is one of the ‘CREATE TABLE’ commands that I edited from ther…
Tag: create-table
How to create partitioned table from other tables in Amazon Athena?
I am looking to create a table from an existing table in Amazon Athena. The existing table is partitioned on partition_0, partition_1, and partition_2 (all strings) and I would like this partition to carry over. Here is my code: Trying to run this gives me an error at the FROM line, saying “mismatched i…
ORA-00906: missing left parenthesis – LIES?
I have stared at this until my eyeballs bleed, where am I missing a parenthesis? It does also say Error starting at line: 1 in command-“. The cause and action section of the error report is blank. Answer This just because you missed column name while declaring primary key. There is another problem: cons…
phpPgAdmin: how to duplicate an exact table from one database to another
Just as the title says, I want to duplicate one table from a completely separate database in phpPgAdmin to another one. I have tried two ways but both did not work for me: Tried “Create table like” (database >> table >> create table like) this seems to can only duplicate a table within…
problem with constraint order in create table in livesql
This gives error: This doesn’t: Why? Answer Each DBMS defined it’s syntax to write SQL. It only works if you obey their rules. It’s kind of obeying the law of a country while you are in it. You can’t ask why I should do that? You have to. Or choose any dbms you like. If your dbms tells…
How do I make sure that all rows with the same foreign key have unique names in my PostgreSQL database?
I have a PostgreSQL database with two tables: Team and Project, in a one-to-many relationship. Team has these columns: id name Project has these: id name team_id I’d like to make sure that the projects within a team must have unique names. Projects belonging to different teams should be able to share na…
Populate table with data stored in separate tables
I have a MySQL database separate_data, which consists of 200 tables with random names (for example first_table, second_table, …) Each of these tables have the same structure and indexes. The total size is about 30GB. I would like to copy all this data to a new MySQL database called new_database, in the …
Simple database with 3 tables and “no matching unique or primary key for this column”
I have three tables, two are created independently, and the third one is created to include some inputs from the first two. First two tables have no problems, however, when I try to create the third one, I get an error: The thing is, I created the third table by copy/pasting the column names/definitions right…
Create Table variable datatype that would allow to save integer/floats [SQL]
as the title states, when creating a table, when definining an variable + datatype like: Question: You can define a variable as integer or as float etc. however, is there a datatype that can hold both values, integer as well as a float number ? Answer Some databases support variant data types that can have an…
How to cascade on delete in a foreign key of a mysql table correctly?
I have three tables with foreign keys which should cascade on delete nevertheless when I run this only the mapping in Tagmap and nothing happens in Excerpt nor Tag. What am I doing wrong? Answer This is not how foreign keys work. You delete from the parent table (here, tag, or excerpt), and then children reco…