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

Looping through sql table and calculate figures in php

I have a what seems a simple question but I cannot workout how to do it. Employee id | dev_time | pm_time 1 | 4 | 5 2 | 2 | 3 3 | 6 | 2 2 | 3 | 6 3 | 4 …
user2133387
  • 11
  • 3
0
votes
1 answer

Select statement within a cell in a database table

I have a basic database table. I would like to implement a functionallity that would allow to insert a select query within a random cell in the table. The result of this query would then be used as as any other cell of elementary type - in my case…
user2113043
  • 11
  • 1
0
votes
3 answers

Creating a table, SQL. Basic stuff

So I'm having a small problem with creating a table. The problem is in my attempt to create a foreign key to another table. I'm currently using MYSQL2008 Management R2 express, so no designer. Heres my two tables use teckDB; CREATE TABLE…
KaosAkroma
  • 35
  • 1
  • 5
0
votes
2 answers

Deleting foreign key references in a database table

Given this problem: Consider a relation geq which represents “greater than or equal to”, that is, (x,y)E geq only if y < x. create table geq ( lb integer not null , ub integer not null , primary key lb , foreign key (ub) references geq on delete…
shamim
  • 51
  • 1
0
votes
1 answer

magento join sales_flat_quote_payment with sales_flat order tables

I am trying to show last4 of the CC and the Card type in a report, by going through the Database I have learned that inside sales_flat_quote_payment there is a field called additional information, and that field seems to have all the info I need, so…
Mike Steelie
  • 13
  • 5
0
votes
3 answers

How to normalize an association between weekly participations and weekly questions?

I am implementing a contest system in which the user has to choose the correct answer of multiple questions. Each week, there is a new set of questions. I am trying to find the correct way to store the user participations in a database. Right now I…
Antoine Aubry
  • 12,203
  • 10
  • 45
  • 74
0
votes
2 answers

ruby on rails database design

I am using devise for authentication and i have added some user-personal fields which i am not sure is the correct way to continue developing my app and is the proper database design... users CREATE TABLE `users` ( `id` int(11) NOT NULL…
stergosz
  • 5,754
  • 13
  • 62
  • 133
0
votes
2 answers

Sorting results in a sql query alphabetically and numerically

I want to make a SELECT from a certain table (ex. "table1") with a column (ex. "column1") which contains a letter followed by a number (ex. z98, k87, a245, a241, d7, e91, e32, b212, r101, r32) Is there a way to make a select that sorts the results…
Alex
  • 8,908
  • 28
  • 103
  • 157
0
votes
2 answers

MySQL Selecting data from multiple different tables in a single query

I have a database of users where I have a primary table with name, address etc. I then have separate tables for the users children, pets, training courses and education results etc. This users details can all be displayed on the same page and the…
Sean
  • 269
  • 1
  • 6
  • 16
-1
votes
1 answer

MySQL sql data text languages (japanese, greek, etc...)

I have tables with latin1_swedish_ci column. I've done tests and inserted into them some texts in languages like french, greek, japanese, spanish and it's working fine. Data written in japanese for example (ぴゃ) are well stored and display. I don't…
defacto
  • 359
  • 1
  • 5
  • 18
-1
votes
2 answers

Indexes needed for user advanced filter?

ASP.NET MS SQL table: tblPets ID (123456789) AnimalType (Dog, Cat, Goldfish...) AnimalName (Rudolf, Ben, Harold...) CountryCode (US, AU..) StateCode (CA, NY...) CityCode (AK, LA...) IsMammal (True, False) IsFish (True, False) HasFur (True,…
user1946932
  • 474
  • 1
  • 16
  • 41
-1
votes
2 answers

copying between multiple tables

I have some records in tables A with fields i.e firstname surname, lastname, school, dob I have another table B with some records and fields i.e firstname, surname, address, club, I'd like to use the firstname and surname in table B to check if the…
Golden Warrior
  • 21
  • 1
  • 5
-1
votes
1 answer

Error creating page to change data from table in my blade

I created a page to implement the function of changing the data from the table, and after I did everything on the video tutorial I somehow do not work this page, here is the text of the error: Undefined variable: business (I still attached a…
Mineral
  • 39
  • 1
  • 1
  • 7
-1
votes
1 answer

HTML Dropdown will not generate selected MySQL Tables

I am trying to use this form to display tables in my database. I am unsure what I am doing wrong. I swapped the positions of the "form" and "select" tags assuming that was the fix. But everytime anything from the drop-down is selected the page…
Rob Nelson
  • 11
  • 8
-1
votes
2 answers

Database table design for several similar columns related to those tables

I am working on a project which has several similar forms in terms of values they are supposed to pass to database. In each form 4 out of 5 inputs and the values they hold are just same but 5th one are always different. Therefore I do not think…
Akberov
  • 154
  • 3
  • 12
1 2 3
…
20
21