A data structure that organizes information into rows and columns.

learn more… | top users | synonyms

0
votes
3answers
39 views

Update data of one table from another with comparing columns have same initial strings

I have two table NewData and OldData, NewData: EName Job Sal smith clerk 2000 allen sales 2000 jones.domain.com Manager 6000 ...
0
votes
0answers
21 views

single Small Table with more rows or single large table with less rows [closed]

I need to design a table to hold an various records coming from the source. The records are such that they have around 20 fixed columns that are common to all. There are another 10 to 15 columns which ...
1
vote
0answers
29 views

Dynamic table name in Insert query

I have asked a question about dynamic table name in a prepared statement here , but I want to know if Mysql server support dynamic table name like this : SET @tbl = 'Dawin'; INSERT INTO @tbl (col1,...
0
votes
1answer
44 views

Unable to view partition table in a schema

I am using oracle 11g enterprise edition, I have created a schema as "TESTSCHEMA" and in it i have created a partition table as "sales_test". The query for the table, create table sales_test (...
1
vote
1answer
30 views

Setting parameters like PCTUSED when creating new tables in ORACLE 12 C

When creating new tables in ORACLE 12 C, do we need to explicitly set parameters like PCTUSED, PCTFREE, INITRANS, MAXTRANS, STORAGE etc. (as shown in example below)? Or will ORACLE automatically set ...
0
votes
0answers
26 views

counting and sorting join mysql

i have table like bellow it store of amount of buys of each user +--------+----------+ | userid | amount | +--------+----------+ | 1 | 1000000 | | 2 | 80000000 | | 3 | 7000000 | | ...
0
votes
0answers
45 views

MySQL - Database Design : Encrypting user id and creating a mask for further internal references

For a food order delivery system that I am working on, I want to make sure my user's private information is well protected; from system admins too. So I thought of coming up with this concept of ...
1
vote
1answer
62 views

Converting a composite primary key to composite unique, and adding an auto-incremented PK column

Background I have taken over responsibility for a table that, in the long run, will grow monolithic. The table is a very simple link table with 2 columns, call them col1 and col2, both being foreign ...
1
vote
1answer
17 views

database setup for posts table with multiple types

Struggling with how to set this up for speed and scalability. So basically i have a bunch of posts that depending on what type of post it is, it could have different input values that i would need ...
0
votes
1answer
51 views

Problems with queries [closed]

I have problems with queries in MySQL. Problem 1: Query: SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA="mysql" and TABLE_NAME="servers" MySQL says: #1054 - Unknown column 'mysql' ...
1
vote
1answer
30 views

How to handle id's referring to multiple tables in an SQL database

I'm working on an MySQL Database for my website but I'm not sure on how to proceed now. I get to the point where actions have requirements in multiple other tables, but also have influences in ...
1
vote
1answer
54 views

Importing .dmp file into SQL developer: Do I need to import seperately for each table?

I have a large .dmp file which I would like to import into SQL developer. This contains all the data I want to import across several Schemas. Do I need to split this up into each separate table in ...
0
votes
0answers
39 views

What can cause the the table cache in MySQL to consume much memory?

I have a server with a table_open_cache of ~2000, and a query cache of ~128M. We have ~350 InnoDB (no MyISAM) tables; innodb_file_per_table is disabled; there is no partitioning; MySQL is 5.6. After ...
0
votes
1answer
37 views

Table/database design question

Suppose you have these fields to keep track of in records: (first_name, last_name, state_id, stateid_status, day, month, year, id_status, id, criminal_status, charge, plea, sentence, create_time, ...
1
vote
3answers
140 views

Difference between a schema and a database in db2

I can not figure out what is the difference between schema and database in db2 I find this SQL so confusing for example : CREATE TABLE schema1.table1 .... .... .... IN database1.tabspace1 Can ...
3
votes
0answers
53 views

What is the difference between a field and a column? [duplicate]

Although I have always regarded the terms as interchangeable, I have read somewhere that they’re not the same. I suppose this means that a record is not exactly the same as a row either. I teach that ...
1
vote
2answers
49 views

UPDATE from subquery updates rows that shouldn't be updated

Using PostgreSQL, I want to update a column. The information how to update is in another table. My try was this, but it also updates rows I don't want to update: update table_1 set column_x = ( ...
0
votes
1answer
28 views

Performance penalty for using thousands of tables in MySQL

Background I'm using wordpress multisite in which each user will have separate blog. For each blog, additional 15 tables are created. The website will be used by thousands of users. That means that ...
0
votes
1answer
110 views

ORA-00942: table or view does not exist- Can it be solved by granting privileges to user?

I am creating a Java application that connects to an Oracle Database. In the application I connect to the DB as User A, which works as intended. I then try to access tables in Schema 1 and Schema 2....
-4
votes
1answer
29 views

SQL Server Table Creation Help [closed]

I'm a newbie, taking University course on DBA with Microsoft SQL Server and trying to write my first manual create table table but I keep getting errors in query or in using SQL Fiddle My attempt is ...
0
votes
1answer
33 views

MySQL BETWEEN command - performance (order)

I want to create a table which will contain approx 20,000 records of three fields each. Two of the fields will contain numeric values. I want to be able to issue a SELECT BETWEEN command. One record ...
0
votes
1answer
52 views

Don't know why MySQL is not creating table with primary key constraint [closed]

I can't understand why MySQL showing this error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '...
0
votes
0answers
26 views

How can I partition a table in DB2 luw [closed]

I want to know if there is an option that substitute "PARTITION BY SIZE" in DB2 luw , it works in DB2 zOS, but it is not supported by luw
0
votes
1answer
46 views

Should a TeamMembers table have a relationship with the Student Table or the Enrolment Table?

I'll keep it nice and short and simply link to the ERD: Users can be assigned a role, one of those is student. So for the sake of this, Students are the same as Users! A Student can be enrolled in ...
1
vote
2answers
46 views

Find times when table is least frequently used

I would like to analyse performance of one of the big tables in the database. There are only two types of operations on it. Inserts and reads. Once data is entered it is never updated. I need to ...
0
votes
1answer
87 views

want to import exported xml file in wamp phpmyadmin

I have exported single table from wamp phpmyadmin as xml file for data verification and want to import it again into database as mysql table. Please give me guidance, how its possible?
0
votes
1answer
48 views

MySQL ADD KEY meaning

This code below is creating a primary key on table User, but Im not understanding the second ADD KEY (C_NATIONKEY), do you know what is doing? Its something about foreign keys? ALTER TABLE USER ADD ...
0
votes
0answers
39 views

How can i delete an orphaned table from AWS RDS database?

Info: Database is an RDS instance (MySql) Yesterday i tried to add a field to a table and did an Alter table command. There is probably some millions of records in that table. After a while it just ...
0
votes
0answers
23 views

XML to Database with XMLSpy

I am using XML Spy to take a XML file (looks like this) and create a database structure after it. I then import the data from my XML file to fill in the rows, etc. I find that some , about 1/4 of the ...
0
votes
0answers
59 views
1
vote
1answer
39 views

Two tables with same field

QUESTION: I have QUOTATION table and SOA table quotation - table is for pending and not approve quotation. SOA- table for approve quotation. i will just transfer the data from quotation table to soa ...
1
vote
0answers
12 views

Need advice on storing pincode system (Zip code) and Shipping company Service Details

I am in the process of creating a system that could identify shipping companies (Fedex, UPS, etc.) from a given pincode (zip code) for a e-commerce platform. The shipping companies will provide a ...
1
vote
0answers
64 views

Cardinality of an index in a MySQL table is equal to table's row size

I have just included an index to a MyISAM table and the cardinality appears to be 1 million something which is exactly the number of rows in the table. In fact it needed to be 315 because distinct ...
1
vote
0answers
20 views

Question on comparing two fields in Access

I'm not sure if the title is fitting as I am not 100% sure if what I am doing is correct but here goes. Here is my enrolment table, I have added a field called pass/fail as you can see which is ...
1
vote
1answer
39 views

Query that compares dates

I'm trying to create a query that shows if students are mature or not, based on their date of birth. However when the query is executed it returns all students as not mature. Any students that are ...
0
votes
0answers
55 views

MYISAM can't create table: Row size too large

We are having database in MySQL 5.1, we have taken the DB backup from MySQL 5.1 and trying to restore in MySQL 5.6. We are getting below error: ERROR 1118 (42000) at line 603: Row size too large. ...
3
votes
4answers
124 views

In a one-to-one relationship, where should the foreign key be placed?

I am currently designing an ERD for a project management system. I am unable to choose between two workable solutions as the best solution as I wish to embrace the best standards. The two entities ...
1
vote
2answers
158 views

novice-design: Are FOREIGN KEYs always necessary? Joins on columns which are not PK

I've been wondering if following approach is bad or really very bad:). Question#1: can we use indicator_id to combine data from indicator_values and indicator_details tables (without using FOREIGN ...
0
votes
0answers
75 views

MySQL Table Structure for Group User Permissions

I could use some assistance in restructuring the schema on mysql for more granular permissions. We have a website where for example there is data for site 1, 2, and 3. There are users A, B, and C. ...
4
votes
3answers
178 views

SQL - Many-to-Many relationship with same table and with relationship constraint

I have a SellerProduct table. Each row within the table represents product information as offered by a seller. The SellerProduct table has the following columns: id (serial, pk) productName (nvarchar(...
2
votes
2answers
36 views

List all articles with their amounts at a certain date+time

I've got a table with articles, and their stock amount changes: TABLE stock_history: +------------+---------------------+--------+ | article_id | amount_at | amount | +------------+---------...
0
votes
0answers
73 views

DB table design for attributes with multiple entries (eg: Person -> Social Media)

I am trying to decide the structure of a DB table to store Employee data. I am bit confused on how to design attributes such as Address, Social Media etc. There should be provision for multiple Social ...
2
votes
0answers
67 views

How to check wether a DB2 source table and their MySQL MyISAM duplicate are identical?

I want to compare two big tables if they are identical. If I update/insert one table into the other the process takes about 11 hours. What I am looking for is like a sum function which sum ups a key ...
1
vote
2answers
59 views

Table design: how to store denormalized Excel data

I have following data stored in Excel which I would like to transfer to SQL DB. There will be a new value every year for every indicator. Indicator | 2001 | 2002 | 2003 -----------------------------...
2
votes
1answer
93 views

Fill Database With Recursive Factorial Function

I want to calculate table's all of the rows's factorials value. And then i want to insert to each row's factorial value in table. so that i create table like as below: TABLE:FACTORIALS ---------------...
0
votes
1answer
37 views

MySQL conditional trigger delete

I have a few tables (6 to be exact) and I want to make a trigger that will delete a row from a table based on a value from the main table. To elaborate, Let's say I have a main table called "main" ...
0
votes
2answers
695 views

mysql won't start, it says Table mysql.plugin doesn't exist

I've had this problem for several hours, and now I'm just tired.. When I try to start MySql from terminal (mac), i get ERROR! The server quit without updating PID file (/usr/local/mysql/data/127.0.0....
1
vote
1answer
108 views

T-SQL Check another table rows if match delete them

I am creating a script in SSIS where I want table A to check if rows exist in table B. If they exist, they must be deleted. Table A is an archive table named Customer_archive Table B is a table that ...
0
votes
1answer
48 views

How move MySql table to another disk?

According to this it is impossible to use alter table for moving tables. So if I understand correctlly - to move table it is neccessary to do: Create new table Copy all row from old one drop old ...
0
votes
1answer
161 views

counting the number of a specific word in one SQL column

I'm trying to make a survey like a referundum to know if my neighboors in my small building are for or against a colectif compost to reduce the organics wastes. For this tool vote I'm using PHP and ...