Stack Overflow
Stack Overflow

Questions tagged [create-table]

The statement that creates a table in SQL (`CREATE TABLE ...`).

The statement that creates a table in SQL (CREATE TABLE ...). Use this tag if your question refers to a problem that might have a relation with an SQL statement that involves a CREATE TABLE statement. Do not use this tag if you have no indication that the CREATE TABLE statement has no relation to the error you are asking about.

1935 questions
0
votes
1 answer

Creating table for wordpress plugin not being created

I am trying to redesign my previous code into a plugin but I have run into some issues. When I try to create a table using the below code. The table is not created. I tried to debug but I get no errors :S Appreciate if you can have a look at…
F117a
  • 31
  • 1
  • 4
0
votes
1 answer

CREATE several tables by looping through ROWS in a particular table in MySQL

How can I, in MySQL using loop through the Subject table and create a table for each subject as shown below using Math, Econs, Chem as examples. Bring in php only as a last resort. Table: SUBJECTS | Subject | unit | staff | | Math …
Nditah
  • 1,429
  • 19
  • 23
0
votes
0 answers

Create a table with select columns from Another Table

I'm trying to break down a GPS point in a new table since the old table is in CHAR my new table will be set to INT. Drop Table LoopTest1; CREATE TABLE LoopTest1 ( `Account Number` char(32) NULL , `Latitude` decimal(30,2) NULL , `LatDegree` …
Joker327
  • 65
  • 7
0
votes
1 answer

Create if not exists else update tables

I want to create table if not exists,else update it. this code is for create table: CREATE TABLE Book ID INT(10) PRIMARY KEY AUTOINCREMENT, Name VARCHAR(60) UNIQUE, TypeID INT(10), Level INT(10), Seen INT(10) how can I change it to…
ali raha
  • 211
  • 1
  • 2
  • 14
0
votes
1 answer

Naming for contraints when creating a table

I see following SQL in a system: create table Account ( [AccountId] int not null, [EquityStatus] int not null constraint DF_Account_EquityStatus default(1), [DerivativeStatus] int not null constraint DF_Account_DerivativeStatus…
Deqing
  • 14,098
  • 15
  • 84
  • 131
0
votes
1 answer

Create New Table with Conditional Assignments - MS Access 2013

Sample data: ORDER SEQ IN OUT 310 1 Jan-20 Jan-22 310 2 Jan-22 Jan-23 207 1 Jan-23 Jan-26 207 2 Jan-26 Jan-27 207 3 Jan-27 Jan-29 I need to create a new table that makes ORDER a…
blondeonia
  • 9
  • 2
0
votes
2 answers

Android SQLite Create table statement

I have a problem where this table is not being created at all in android. Here is the whole MyDBHandler: package com.example.plrardiakao; import android.content.ContentValues; import android.content.Context; import android.database.Cursor; import…
Sheenah
  • 85
  • 12
0
votes
1 answer

SQL Proc Stock error

I need your help for a little problem on SQL. For information my environement is SQL Express 2008 R2 used in local on my computer for lab tests. Hello So, I want run this procedure step by step like : 1st query : Proc_Choise_Test 1; ==> Create…
N3xU5
  • 1
  • 1
0
votes
1 answer

creating table as SYSTEM under another schema make any difference

we are using oracle 11g I am preparing a .sql file of commands to create tables, index, trigger and etc. I have .sql files which should be ran as a particular user. To avoid above contraint, I am running all DDL as SYSTEM user. so my question…
Vishwanath gowda k
  • 1,675
  • 24
  • 26
0
votes
2 answers

Tables not showing anything when creating new one

I have problem with SQL . I am trying to create tables from other tables with foreign keys. The table is created normally without problem but when I'm trying to see the data inside the table there is none of the data inside! Anyone who knows? --…
Giorgos Neokleous
  • 1,709
  • 1
  • 14
  • 25
0
votes
1 answer

Create table in Oracle

I want to create a table in Oracle, with sql developer and I received an error! This is my code: CREATE TABLE "DASHBOARD"."DASH_OMC_CASES" ( "OBJID" NUMBER, "CASE_ID" VARCHAR2(255 BYTE), "CREATION_TIME" DATE, "MELDUNGS_TYP"…
eu127
  • 123
  • 1
  • 14
0
votes
2 answers

SQL Creating Table Dependencies

I've been stuck at creating tables. Here is the code I am stuck at how to make the code work in loan_type to write office worker or non office worker create table loaner ( loan_id number(5) primary key, loan_type VARCHAR2 (16), …
Alex Hummedov
  • 37
  • 5
0
votes
3 answers

Need some tips on create table

I plan to create a table to store the race result like this: Place RaceNumber Gender 　　Name 　Result 12 0112 Male Mike　Lee 1:32:40 16 0117 Female Rose Mary …
Nano HE
  • 9,109
  • 31
  • 97
  • 137
0
votes
1 answer

How to fix : unable to extend segment by 8 in undo tablespace?

I'm trying to add 10m data to my database table and at about 3,5m it stopped and I got the error unable to extend segment by 8 in undo tablespace. I've never encountered that before and I have no idea how to fix it. I'm running my scripts through…
aiden87
  • 929
  • 8
  • 25
  • 52
0
votes
2 answers

How can I optimize the import of this dataset in mysql?

I've got the following table schema: CREATE TABLE `alexa` ( `id` int(10) unsigned NOT NULL, `rank` int(10) unsigned NOT NULL, `domain` varchar(63) NOT NULL, `domainStatus` varchar(6) DEFAULT NULL, PRIMARY KEY (`rank`), KEY `domain`…
GeoffreyF67
  • 11,061
  • 11
  • 46
  • 56
1 2 3
…
99
100