current community

your communities

more stack exchange communities

Stack Exchange
tour help
stack overflow careers

Tagged Questions

A database is an organized collection of data typically used to model certain situations. Use this tag if you have questions about designing a database. If it is about a particular database management system, (e.g., MySQL), please use that tag instead.

learn more… | top users | synonyms (4)

0
votes
0answers
9 views

how to update or delet from database

I am new to database i just created a simple database .please let me know how to delete a single row from this data base and how to edit a single row from this database :) thanks in advance ...
0
votes
0answers
3 views

Can we perform joins on tables in two different projects in BigQuery?

I have two projects having datasets. I want to perform join of one table from first project to table in second project. How can I do that? Query ?
0
votes
0answers
4 views

DLookup on a report in Access 2013

I have an attendance log that keeps track of patient attendance in my office. We have many therapists who see patients. The therapists are listed on an "Employees" table with an ID called "ID". On the ...
0
votes
0answers
4 views

Almost Foreign Key Relationship Schema Diagram

I am working with an existing database and I'm attempting to draw a schema for it. One of the tables refers to multiple other tables using only two columns. In the first column is the name of the ...
-3
votes
0answers
10 views

how to read and write SQLite database file in java (after making jar file)

I want to create a java application which will use Sq Lite database and after making jar file my application will read and write Sq lite database file. So how to achieve this.... please give me ...
0
votes
0answers
6 views

synchronizing remote database and sqlite database using long polling in a angularjs application

What is a efficient way to synchronize a remote database with a local database on a mobile device (in this case a sqlite database) using angularjs long polling mechanisms? The main requirement is ...
0
votes
0answers
6 views

Python: Can you Save an Object and all of it's Associated Values?

I have an 2D-Array of co-ordinates that has an arbitrary number of factors to each co-ordinate. (Some have associated Boolean values, String values etc.) Is there any way, to save the array and all ...
-1
votes
1answer
11 views

Column not found in SQLite databse

I reated a column name called _id, but when I run and view the database in a ListView by using the getAllRows() method, it shows an error saying (no such column: _id (code 1): , while compiling: ...
0
votes
0answers
11 views

C#: Simple client server to send XML information to CRUD database

I need to develop a resident app to get info from Win32_BaseBoard class when is required by another app by XML without create any file and then this app must insert or update that information on ...
0
votes
2answers
21 views

I pass data from database in array form, then I want to show this array in php

How do I use $objects in this function? I pass data from database in array form, then I want to show this array in PHP page, but it's printing this word "array". I want to print it in this ...
-1
votes
0answers
15 views

Android listview item filter issue

I have a ListView which work fine. Now I have put an EditText at the top of my ListView. What I want is that when a enters a letter "A", only the names starting with an "A" should appear in the list . ...
0
votes
0answers
7 views

how to migrate data from mySQL to PostgreSQL

Trying to migrate a database from MySQL to PostgreSQL. All the documentation I have read covers, in great detail, how to migrate the structure. I have found very little documentation on migrating the ...
0
votes
0answers
9 views

Creating the ER Model after the creation fo the database

I've created a program runnning on the web (html) about booking tickets on a cinema theater. I now want to create its ER Model. As far as I know, the logical sequence of actions is: Create the ER ...
-1
votes
0answers
24 views

Android - how i can access to a database helper class from two places simultaneously

In my android app i have to download some files from a server. To do this i have implemented a Service class which performs the download of these files updating, for each file downloaded, a table in ...
0
votes
0answers
9 views

Modifying File on database using batch file

I have made a simple chat room in batch and it works over the same Wi-Fi but I want to extend this and make it work online. I have a database and I want to save a text file there and want to update it ...
0
votes
0answers
17 views

Retrieve Image from sqlite3 database and directly display on kivy window

What I am getting from this code? Image is retrieved from the database, then created in the same folder from this code with open(self.filename, 'wb') as output_file: ...
0
votes
3answers
34 views

Android listview with filter issue

I have a listview of items coming from a database. Now I have put an edit text at the top of my listview. What I want is that when a user start typing in the edit text, the listview should be ...
0
votes
1answer
11 views

Converting h2 database from h2.db to mv.db

I am converting old h2 databases (with the h2.db extension) to the newer mv database engine. In some tables of the database I have a problem with the stricter engine. just a SELECT * FROM does get ...
-2
votes
0answers
17 views

What database to go with nodejs? [on hold]

My boss just walked in on me, and told me he wants our site to be rewritten in Node.JS. So, okay, Express.JS or similar for backend, maybe AngularJS or ReactJS for client, but what about Database, ...
0
votes
1answer
13 views

Joining product attributes with the product table to display product

I have three tables for listing products with product attributes Product Table with dummy data Product_Attributes with dummy data Attributes with dummy data Kespersky antivirus ...
-1
votes
1answer
22 views

Pulling questions based on category & user

So I am developing a website that has questions across different categories, but depending on the user the question will be different. an example : Team A has access to questions (Cat 1 - Question 1, ...
0
votes
0answers
13 views

How to retrieve objects related to specific user in Parse using Swift

I currently get my users contacts onto my parse database under the className "Contacts". I now want to retrieve this data relating to a specific user. I do so by the following: let query = ...
2
votes
1answer
22 views

Zend Framework 2 - Showing the content of a database

I'm making some kind of market site with Zend Framework 2. The home got a slider showing all the products (realized with CSS3 keyframes) and some text. Both the sliding pictures and the text are read ...
0
votes
0answers
23 views

Codeigniter count_all_results not working

I'm using below function to return if a row exists to support my upsert function $this->db->where('date', $date); $this->db->where('emp_id', $emp_id); ...
0
votes
1answer
18 views

postgresql: change primary key

Until now I had a column account_name as the primary key for my database. I'd now like to use a hash of account_name as the primary key instead. So as an interim measure, I added an account_hash ...
0
votes
0answers
16 views

Converting a Sql Join for lucene index

I am pretty new to Lucene and don't have enough knowledge to solve this problem. So first I would like to describe the scenario, then my problem, and then the approach I have taken for my solution ...
0
votes
0answers
6 views

Declaring multiple attributes as key in DTD

In DDT language, an element can have at most one attribute of type ID. The question is if I want to declare multiple attributes as key, what should I do? Is it available to do this or I should define ...
0
votes
0answers
8 views

BCNF- Boyce Codd Normal Form

I'm currently a bit confused with BCNF So the condition for BCNF states, To be in BCNF relation R needs to be in 3NF. X -> Y X should be a super key. In this example: A -> BCD BC -> ...
0
votes
0answers
23 views

How to move data from one database table to another table of same database using ASP.NET MVC?

I am new to ASP.NET and I want to move data from database table to another table in the same database. I searched a lot but I didn't find such thing in ASP.NET MVC. I have a Table 1 and Table 2 in my ...
0
votes
0answers
11 views

Netbeans/ Java Desktop Application: Multiple users simultaneously

with the support of this forum, beginning here import comma separated text data to java database table, I've completed the desktop application which has a database of almost 100GB (and expanding). ...
0
votes
1answer
31 views

Best database & schema for a tree?

What database (and schema, if applicable) would be most appropriate for storing and retrieving data (location, timestamp) that can be placed at any node of an arbitrarily defined tree? For instance: ...
-1
votes
2answers
29 views

Oracle DB : What is difference between spfile and init.ora file?

I have tried to understand through oracle docs but could not get it properly Any body please explain. What is difference between spfile and init.ora file? Thanks.
2
votes
1answer
26 views

How to get a mysql query to use a specific index?

SELECT * FROM orders WITH (INDEX(idx)); When i fired above query i got the error mysql #1064 - You have an error in your SQL syntax I have created index as below create index idx on ...
1
vote
0answers
20 views

Mysql Innodb deadlock problems on REPLACE INTO

I want to update the statistic count in mysql. The SQL is as follow: REPLACE INTO `record_amount`(`source`,`owner`,`day_time`,`count`) VALUES (?,?,?,?) Schema : CREATE TABLE `record_amount` ( ...
0
votes
0answers
8 views

Deploying VSTO Addin with DB, EF and Raw SQL using ClickOnce

I have an Outlook 2013 VSTO addin. It uses a database. And it also uses entity framework with a DataSet in my solution explorer (which also uses the database obviously). When I deploy with ...
0
votes
1answer
10 views

Importing a mysql database with command line

Have tried all other answers on stackoverflow, and they haven't worked. I have a database in phpMyAdmin, and I need to update it. The file is too big to upload via phpMyAdmin, and I've tried ...
0
votes
1answer
22 views

Building an API for Android/iOS Use? [on hold]

I'm trying to make an Android/iOS app for school calendars for parents, where users should be able to insert holidays/vacations, and others should be able to access holidays/vacations for a specific ...
0
votes
2answers
38 views

basic graph data structure

I am trying to write a simple text-based game in Unity where the player must navigate from their bed 'let's say, 'A'' to an exit, 'G' by moving across 'nodes' that are directly attached. Here's an ...
0
votes
1answer
26 views

Can't open sql connection in cs file - asp.net

I am new to ASP.NET and following a tutorial where a user can register to a site and it checks a database to see if username already exist. When came time to create database, the tutorial said to ...
0
votes
1answer
8 views

Database Migrations on Secondary Database on Heroku

Our company acquired an application from another company, so I'm a little unfamiliar with how they may have done this in the past. Currently there are two applications in Heroku. A production and ...
0
votes
1answer
16 views

how to examine contents of database during or after rails integration test

I'm a fairly experienced dev but I'm a total web and rails newbie. I'm trying to implement a kind of market place rails application. I've developed the app to where I'm far along in the customer ...
0
votes
0answers
25 views

How to Insert html, special charters to a sql database with PDO?

I'm trying to insert some html special characters inside my MySql MyIsam table Used query : INSERT INTO place_menu (menu_ref_place, menu_name, menu_price, menu_card_price, menu_full_price, ...
0
votes
1answer
26 views

Update a field from one table to another, involving a 3 table join

I have a table I need to update the price field in. I need to update this field from a different price field from a different table. The only way I can get to the required table for the update is by ...
0
votes
1answer
23 views

Converting non-utf8 database to utf-8

I've been using for a long time a database/connection with the wrong encoding, resulting the hebrew language characters in the database to display as unknown-language characters, as the example shows ...
-2
votes
3answers
40 views

SQL - Select all person whose “firstName lastName” contain a name

I have a database table "person" with two columns firstName and lastName. Now I want to select all the persons whose "firstName lastName" contains a given name. How can i do it with a SQL query? ...
2
votes
1answer
18 views

Database Multiple select Query , Unable to Retrieve Desired Data

I have three Tables as given below , I want to search record on base of three Different cafeterias in Single query,I want to search record whether user give Brand_Name , Drug_Id, Generic Name It give ...
3
votes
1answer
22 views

Does PostgreSQL quickly search for columns with arrays of strings?

According to Can PostgreSQL index array columns?, PostgreSQL can index array columns. Can it do searches on an array column as efficiently as it does for non array types? For example, suppose you ...
0
votes
0answers
14 views

Query to find when identifier changes

I am trying to identify when two employees who are married, but divorce and get their own single policies. Or if there are two employees with single policies and get married then going under one ...
0
votes
1answer
16 views

What is the best replication model for failover purposes [on hold]

I have a database with over 500 tables, views, triggers, and etc on a sql server 2008. I have been asked to setup a replication in case the primary database server failure occurs with the following ...
-3
votes
0answers
34 views

Query to Database - What does this code do exactly? [on hold]

I wrote the following line of code for my school project. While I understand the basic concept of these lines, I can't figure out what it does exactly and why it is necessary. Notes: The code ...

1 2 3 4 5 … 1891