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

MySQL: Join table iteself. Unknow column

To go Mad!!!! On Access works and on MySQL don't want. And I take the trick on a post here. Here the query: SELECT A.B_ID, B.CNT_B, B.MAX_PRICE, B.SUM_AB, B.SUM_C_AB, B.UNIQUE_B, B.Costi, …
Oscar Zarrus
  • 790
  • 1
  • 9
  • 17
0
votes
1 answer

Yii-CRUD: Getting select boxes filled with data from other tables

Do I need some more work, to get a select box with the corresponding data (e.g. land list from an another db-table) in the created insert form (via CRUD) or it is enough to define the relations in the models and yii would do this for me…
Gabriel
  • 81
  • 2
  • 9
0
votes
2 answers

Access Table Configuration

I'm fairly new to access and I need some insight on the way I'm setting up two tables. I am in the business of tracking equipment procurements. I have one table that has the main unit, quantity, make/model information along with some other…
user2891566
  • 15
  • 2
  • 6
0
votes
0 answers

Microsoft Access using and updating data in just one table

I need help, i have created a database that is made up of five table and they all depend on three primary keys such as contractID, Firstname and LastName. this fields are repetitive in all the five tables they are necessary i just want to enter the…
user2906088
  • 1
  • 4
0
votes
2 answers

MySQL sum two tables fields and UPDATE

Im trying how to sum id by id two tables and update the one : STOCKA --------- |P | U | |-------| | 1 | 1 | | 2 | 0 | | 3 | 3 | --------- STOCKB --------- |P | U | |-------| | 1 | -3 | | 2 | -2 | | 3 | -1 | --------- Results I want : STOCKA…
sarasa
  • 15
  • 1
  • 5
0
votes
2 answers

Use php to combine 3 mysql tables

Is it possible to combine the following 3 MySQL tables using PHP? Table 1: Columns - userid, username, userpass Table 2: Columns - accountid, accounttype Table 3: Columns - userid, accountid, date, rating Please note that I am new to mySQL…
E3563
  • 1
  • 1
0
votes
1 answer

Ignited Datatables call stored procedure php

I follow tutorial ignited datatables https://github.com/IgnitedDatatables/Ignited-Datatables/wiki/Function-Reference function datatables() { $this->datatables ->select('TerminalID,AtmLocation,MaxNumOfBills1,MaxNumOfBills2') …
Ardy Ant
  • 59
  • 1
  • 10
0
votes
0 answers

How do you implement SQLite in Android App?

Ok, so, I want to create a database for storing three tables and keeping the data (tables, columns and attribute values) stored every time the app launches. I do not need to add GUI for adding or deleting tuples, but hard coding it on each creation…
larsac07
  • 61
  • 1
  • 3
0
votes
1 answer

MySQL 3 tables single query for Datatables

I'm trying to get data from 3 tables in one query. Those tables are for storing and displaying user messages. Each user can log in and request all his inbox messages. The user id is avaliable from the PHP session and parameter type=1 gets passed in…
user164863
  • 580
  • 1
  • 12
  • 29
0
votes
1 answer

How to make arbitrary SQL-queries very quick from a huge table in the database

We have a single flat table consisting of ~50 million records of data with ~100 columns on Oracle 11g DBMS. A single table was made primarily for performance reasons. There are multiple client-applications which execute different select SQL-queries…
Ivan Voroshilin
  • 5,233
  • 3
  • 32
  • 61
0
votes
1 answer

SQL Server processing for jquery datatables order by issue?

I have written the following script to mimic the incoming parameters from datatables and try to filter the results using the parameters. Everything works fine except the order by clause. Basically it only orders by rownumber and does not take into…
Farhad-Taran
  • 6,282
  • 15
  • 67
  • 121
0
votes
1 answer

pass arguments into anchor after sql query

how can I to perform this operation? this->datatables->select('first_name','roll_num') -> from('students') -> add_column('cancel',anchor("cancel//", 'Delete', array('onClick' =>"return confirm('Are you sure you want…
Rishi Reddy
  • 123
  • 1
  • 2
  • 10
0
votes
3 answers

how to copy top 1000 records from 7000 records in existing table to other new table

I have a table A which consists more than 7k records,Now i am creating a new table B .In my new table B I need to copy only 1000 records from table A which has more than 7000 records. No condition applies, it may be any thousand records from 7000 .
Chow.Net
  • 593
  • 6
  • 13
  • 25
0
votes
2 answers

How to Compare Fields in same table defined by WHERE clause

I am trying to compare product_models in a product table between 2 different manufacturers. I found the same product has 2 different product_model numbers. Similar but still different. For example CNELD-1004 from Manufacturers 1 (ELD) is the same…
kipper
  • 1
  • 2
0
votes
0 answers

PHP SQL UDP server handling multiple clients creating dynamic tables

I'm trying to create dynamic SQL tables with multiple clients in XAMPP. I already have the server code running to handle multiple clients. Below is my multiple client code, which fully works by constantly listening for incoming clients and opens a…
saibot
  • 11
  • 4
1 2 3
…
20 21