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
4 answers

PHP SQL Query That Displays Certain Results Based On Values In Another Table

Right now, I have two database tables. Table history_2014 has a column(member) that says whether or not a member is active (Y or N). I have another table called history_overall that contains all of the contact information for these members. I need a…
user3761506
0
votes
1 answer

How to write a query for a nested object that varies on a field of the parent?

This may be a difficult question to ask correctly. The idea is that I have a thing that has a schema that could result in a json object like so: { id:1, x:1, y:1, type:"map" settings: {... those settings for type "map" ...}} Each of the fields id,…
lucidquiet
  • 6,124
  • 7
  • 51
  • 88
0
votes
1 answer

How to split a column's data into different with same Header in PIVOT?

I have used the following query to extract the member data with their interest using PIVOT. CREATE Table #MEMBER_ATTRIBUTES ( MEMBER_ID int, MEMBER_PROPERTY varchar( 500 ), MEMBER_VALUE varchar( 500 ), PRMEDIAUSER_ID int, MEMBER_FULL_NAME…
Ram Singh
  • 6,664
  • 35
  • 100
  • 166
0
votes
1 answer

Trying to put table around results from query?

I can't put a table around my results from my code and need some help as I've tried but it comes back with "Parse error: syntax error, unexpected '<' in C:\xampp\htdocs\search_go.php on line 27". So could I get help with how to insert a table?…
user3649219
  • 25
  • 5
0
votes
1 answer

SQL: Foreign Key With multiple child values

How would I setup a groups table with following relationship with a list of user: For example, lets say I have table of users: user_list ----------------------------------- first_name | Last Name | user_id…
user3143218
  • 1,738
  • 5
  • 32
  • 48
0
votes
1 answer

how to check SQL table with last one week data in sql server using stored procedure

my transaction_tbl structure like this transactID int TBarcode varchar(20) Locid int PlateNo varchar(20) dtime datetime DelEcode nvarchar(50) Paydate datetime KeyRoomDate datetime DelDate datetime Status …
user3262364
  • 369
  • 3
  • 9
  • 23
0
votes
1 answer

How to draw an ERD where you can store calculation methods based on other id's

Hope someone can help me how to set-up an ERD diagram where you can store calculation methods or formulas. The user should be able to add accounts: eg "points possible"; "ID: 1" "points earned"; "ID: 2" but should be also able to enter and keep a…
YCC
  • 9
  • 2
0
votes
1 answer

Creating Postgres table out of variable table data

I have a Postgres table of data that looks like this (ex.): ╔════╦═══════════╦════════════╗ ║ ID ║ FieldName ║ FieldValue ║ ╠════╬═══════════╬════════════╣ ║ 66 ║ PO# ║ 11111111 ║ ║ 66 ║ Zip ║ 01810 ║ ║ 66 ║ Badge ║ …
user3537023
  • 13
  • 3
0
votes
1 answer

how to check for multiple types of validations in one table

So I have a scenario. Must have these 4 application fees set up with no end date or end date in future. (FeeTypeID = 16 AND FeeRequirementTypeID = 18) (FeeTypeID = 17 AND FeeRequirementTypeID = 18) (FeeTypeID = 18 AND FeeRequirementTypeID =…
ace.nasir
  • 1
  • 1
  • 4
0
votes
1 answer

Codeigniter MS Access Limit to TOP

I have this function from: https://github.com/IgnitedDatatables/Ignited-Datatables/ private function get_paging() { $iStart = $this->ci->input->post('iDisplayStart'); $iLength = $this->ci->input->post('iDisplayLength'); if($iLength !=…
Ramzendo
  • 576
  • 1
  • 5
  • 16
0
votes
3 answers

Comparing values of columns from 3 tables - MySQL

following question: I'm working with 3 tables = actors, movies, roles. I'm trying to find all the movies a given actor, say 'Robin Williams' has been in by comparing the specific actor id since there be may more than one actor with the same name.…
Sina Sima
  • 29
  • 2
  • 8
0
votes
1 answer

Creating tables in SQL server adding Constraints and Defaults

Hi i'm relatively new to SQL server and am working on creating tables i was given the following ERD and Constraints i'm not sure if my code matches the table in the erd any advice would be appreciated Table Customer CustomeNumber Int (PK) …
user3390711
  • 3
  • 2
0
votes
1 answer

SQL-How to insert one value from one table to another but the data in another table should remain the same

I have two simple tables: bazaa (ime VARCHAR(20),prezime VARCHAR(20)) bazab (ime VARCHAR(20),prezime VARCHAR(20)) Let's say bazaa contains 1 ime and 1 prezime and bazab contains 2 ime and 2 prezime. I want to insert values into bazaa and those…
Sv1z3c
  • 1
0
votes
1 answer

SQL Server 2008: populate a table with data from dynamic table

I have two tables Control1 (BatchID ,TableName) , Control2(BatchID, MemID) and there are additional tables that will be added to the database one by one. The format for the tablename is ABC_date for example ABC_01032014 (dynamic) Now this Table…
Bhupinder Singh
  • 1,061
  • 1
  • 11
  • 21
0
votes
3 answers

Database is created but database table is not created

I have this set of coding that is used to insert the data that I've keyed in into database. However, when I export the database, I don't see any tables I wonder have I done it correctly. No error was shown too. logcat 01-21 07:55:25.567:…
Chloe
  • 149
  • 1
  • 12
1 2 3
…
20 21