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: ddl
how to create new table in mysql with date default value for current date?
I am trying the following code: How can I make a default value for the date column? try the now(), but it is not valid.. Answer You can use current_date
Generate DDL script for MySQL in Oracle SQL Developer
I made a relational model in Oracle SQL Developer and I want to make tables in MySQL Workbench. I generated the DDL script in SQL Developer and copied it in MySQL Workbench. I found out that the copied queries are not in correct syntax. I tried different options in SQL Developer to generate script and none of…
How to convert a timestamp field to int8? Or just drop the column and make a new one?
I have a PostgreSQL table with a column of type timestamp. I had included this column a while ago just in case I wanted to use it for something in the future. I am now looking to convert it into an int8 and use it as an epoch time column. All rows of the table have this column set to
SQL query to set CHECK constraint on a column based on the value in other column
I need to set a CHECK constraint on a column based on the value in other column (both within the same table) Like when COLUMN A is NULL, COLUMN B should be NULL But if COLUMN A has values 1 or 2 or 3 then COLUMN B should definitely have a date value. Answer Define B as a date. And
Why is my “CREATE INDEX CONCURRENTLY ..” command blocked by a “SELECT FROM” query? (Postgres 9.6)
I was running a migration to create an index, but the migration was blocked by another query. I resolved the problem after discovering that there was another query blocking my migrations; and after …
Athena nested Struct Querying – how to query Value_counts in SQL
I have a big nested struct in AWS Athena. Here’s one column named “petowners” in the table: I’m looking for: The equivalent of the python function value_counts in the column. Meaning I’m looking for the SQL Athena command that will output for this row: [mammals:1, birds:2, Unknow…
Will a SQL view filtered by large datetime always provide current data?
If I create a view today for a table that continuously keeps getting data, using date filtering from 1900 and 2100, for example, will that “copy” become truncated to the moment that I build the view or since it is being filtered to a very large date will it keep showing the current data to the use…
How to view the Create Table SQL command after a table has been created in mySQL phpMyAdmin
When you create a mySQL table using the GUI in phpAdmin there is an option to preview the SQL create table command. Once you have created a table, made adjustments and finalised the structure, is it possible to review the SQL create command for the current version of the table? Answer SHOW CREATE TABLE Shows …
postgresql ERROR: syntax error at or near “PRIMARY”
I’m new to PostgreSQL. I’ve been trying to create tables in a database but some queries give weird errors. the first snippet throws a syntax error but when I add “serial” on the problematic column the error is resolved. Should all primary keys auto-increment in PostgreSQL? This works a…