Stack Overflow
Stack Overflow

Questions tagged [database-table]

In a relational database management system (RDBMS) a table organizes the information in rows and columns. Each table has a defined number of columns, each of which is identified by its name, but the number of rows is variable, consisting of one for each line of data.

In a relational database management system (RDBMS) a table organizes the information in rows and columns. Each table has a defined number of columns, each of which is identified by its name, but the number of rows is variable, consisting of one for each line of data.

More Information:

  1. The wiki entry on database tables is a good source of information.
  2. Microsoft provides an intuitive definition of a table
313 questions
0
votes
2 answers

using two data tables in a procedure SQL

I was put in a situation where I was forced to create a procedure that uses two data tables such as this: ALTER PROCEDURE [sesuser].[Login_GetUserList] ( @beginsWith NVARCHAR(20) = NULL, @SortBy nvarchar(20) = NULL, @sortByDirection…
Angie
  • 313
  • 1
  • 8
  • 20
0
votes
1 answer

How to pass large set of datas from one activity to another activity in android using database

I have a json file which contains a large size of data such as place id, latitude, longitude and date. I want to pass this data from one activity to another. When I am doing this same with Intent the app shows error. How to pass data using a…
Mysterious
  • 3
  • 1
0
votes
1 answer

Query on two databases on two servers not connecting

I have followed a lot of examples on this issue but I just cannot seem to get this to work. I can query the databases individually with success, but not the two in the same query. I've tried aliasing, referring to the servers in the query... putting…
Andi Lee Davis
  • 85
  • 3
  • 11
0
votes
2 answers

Transaction isolation level for a table in Microsoft SQL Server

It's more a confirmation of what I thought rather than a question. Can one change the isolation level on a table-basis in SQL Server or can it only be defined/changed on a session level as by the statement below? SET TRANSACTION ISOLATION LEVEL…
Eugene Lycenok
  • 603
  • 6
  • 14
0
votes
1 answer

Yii2: how to not fill a GridView when index.php is loaded

I have an index.php file generated with the Gii Code Generator. It has a GridView with the data of a table of my database. It has 536000 rows so it moves very slow. Even sometimes exceeds 30 seconds so the page is not loaded at all. I would like to…
Roby Sottini
  • 2,117
  • 6
  • 48
  • 88
0
votes
2 answers

Exploring data modelling (how to hobble a sensible database together)

i am working on a project in which people can create a playlist and its stored in localStorage as objects. everything is client side for the moment. so i will now like to take a leap forward, make a user login system (i can do it using php mysql and…
fatSlave
  • 84
  • 8
0
votes
0 answers

How to create a separate table for each user/store user specific data using sqlite3

I am using sqlite3 for python to build a notes management application using tkinter. I wanted to know how can I create a separate table to handle each user's data (contains id, tags and memo for each note) separately. Is it possible to create…
Yashodeep D
  • 9
  • 6
0
votes
0 answers

Database Best Design (Confused between 2 concepts of design)

I am trying to design a relational database to manege two objects: residence and property. a residence may have no property, one property, or many properties, and the property may not be related, but can only be related to a maximum of one residence…
adel adl
  • 35
  • 7
0
votes
1 answer

How to select multiple tables in single query mysql? (some tables have no data yet)

I have 3 tables called patients, customers and deliveries. Those tables are in the same database called db. All the tables equally have id, first_name, last_name, gender and only deliveries table has their own data. (the other 2 tables are currently…
sniffingdoggo
  • 398
  • 4
  • 16
0
votes
1 answer

Database abstraction for creating tables/views in PHP

I'm wondering if there is a solution for creating database models (tables and views) independend from the used DBMS. I'm using Zend Framework at the moment and the abstraction for the basic CRUD operations is really great, but it doesn't provide the…
Bernhard Rusch
  • 454
  • 4
  • 7
0
votes
1 answer

How to check content loading status on a static database?

We have a static database we constantly update with loader scripts. These loader scripts get current information from third party sources, clean it and upload it to database. I have already made some SQL scripts to ensure schemas and tables required…
FLC
  • 786
  • 1
  • 6
  • 18
0
votes
0 answers

Splitting the .net data table with calculated column

I have 2 data tables. First table has 4 columns and Second table has 5 columns. The 5th column in second data table calculated column. Tables schema are shown below. First Table Columns: A B C D Second Table Columns: A1 B1 C1 D1 E1=(A1+B1 *10) here…
Omkar
  • 2,129
  • 8
  • 33
  • 59
0
votes
1 answer

How to transfer specific columns of a table in one database into another database?

I am using pgAdmin 4 for PostgreSQL. I have two databases A and B each having a table called records. In database A, table records has 3 columns person_id, shop_freq and time, and has about 1000 rows. While in database B, table records has 4 columns…
Mike
  • 369
  • 5
  • 21
0
votes
0 answers

What does WALInitSync actually mean?

I am using postgresql and pgadmin. I had a table (about 12 million rows) from another database which I wanted to transfer to a table in a new database. So I created a custom backup of that table and tried restore for the new table. The Restore job…
Mike
  • 369
  • 5
  • 21
0
votes
1 answer

access database table values and use them as a parameters to stored procedures in mysql

I have one specification database table, and now i have to take one value from that table and pass that value as parameter to stored procedure. that value is taken based on condition like select spec_value from spec_tab where…
Neeraja Bandreddi
  • 437
  • 2
  • 18
1 2 3
…
20 21