Top "Create-table" questions

postgres: create table in database from the command line

I am trying to create a table in postgres, but it ends up in the wrong database. Here is what …

postgresql create-table

Cannot create a new table after "DROP SCHEMA public"

Since I wanted to drop some tables and somebody suggested the below and I did it: postgres=# drop schema public …

database postgresql database-schema create-table sql-drop

How to create table in partition data in hive?

drwxr-xr-x - mgupta supergroup 0 2018-03-26 22:16 /kylin/retailer/qi_basket_brand_bucket_fact/_impala_insert_staging drwxr-xr-x - mgupta supergroup 0 2018…

hive create-table hive-partitions

Copy a MySQL table including indexes

I can copy a MySQL table to create a new table: CREATE TABLE newtable SELECT * FROM oldtable This works, but …

mysql indexing create-table

Create table in mysql with one column containing sum of another two columns value

Is it possible in mysql to create a table with a column that combines two column values? something like this: …

mysql create-table

Complex SQL Join with 5 tables

I'm working on a relatively huge application, which contains quite a lot of tables. I have to write a SQL …

sql join create-table

SQLITE Query results into a temp table

I haven't used SQLite before and can't figure out the syntax, I have this working in SQL Server if it …

sqlite common-table-expression create-table

Create table syntax not working in hsql

I am new to hsqldb. I am developing simple application to get the some input from user. So Searched for …

java hsqldb create-table

Is there any way for DBUnit to automatically create tables?

I just realized that DBUnit doesn't create tables by itself (see How do I test with DBUnit with plain JDBC …

java dataset create-table dbunit

Mysql: What is 'AUTO_INCREMENT=5' in a create table query?

I have a create table query in which there is a last clause which says AUTO_INCREMENT=5 Could someone explain …

mysql create-table