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
-1
votes
1 answer

Cross Referencing Multiple Tables

What I was trying to do is to get data from multiple tables, supposed that I have the following results in my query: The numbers in the column ticket_item_type represents certain table. For example, 2 is for tbl_company and 3 is for tbl_lease.…
Jayson Tamayo
  • 2,741
  • 3
  • 49
  • 76
-1
votes
2 answers

Using HAVING to search for part of a string

I was wondering if it's ok to use sql HAVING to find certain rows in a table. Example: I have a table with three columns -> ID (int, primary key), type and size (varchar) One row looks like this: ID type size 1 15; 16; 17 4;…
gogo_rulez
  • 389
  • 2
  • 10
  • 24
-1
votes
3 answers

JOIN syntax and order for multiple tables

SQL Gurus, I have a query that uses the "old" style of join syntax as follows using 7 tables (table and column names changed to protect the innocent), as shown below: SELECT v1_col, p1_col FROM p1_tbl, p_tbl, p2_tbl, p3_tbl, v1_tbl, v2_tbl,…
bdcoder
  • 3,280
  • 8
  • 35
  • 55
-1
votes
1 answer

Table normalization

Can you help me to normalize a table. The exercise say: "Find the functional dependencies (FD) and normalize the table" (i guess this means to put it in 3NF): A |B |C |D ------------ a1|b1|c1|d1 a2|b1|c1|d1 a1|b1|c2|d1 a5|b2|c5|d1 a6|b1|c7|d2…
venko_js
  • 51
  • 1
  • 2
-2
votes
1 answer

Update join with a one to many relationship

I have a table of users that looks like this: USERS userid | email | action | actiontimestamp And another table of some user actions (login, logout, etc.) that looks like this: USER_ACTIONS actionid | userid | action | actiontimestamp I need to be…
electricmouse
  • 19
  • 3
-2
votes
1 answer

How to use all_col_comments and user_col_comments in Oracle11g?

I have used the following statement to add the comment: comment on column employee.first_name is 'first name of the employee table'; No I have difficulty in knowing how to use all_col_comments and user_col_comments to view the above comment using…
Pradeep Joshi
  • 1
  • 1
  • 1
-2
votes
1 answer

How to return data specific to 1 user in an SQL database using VB.NET

This program requires a user to select their card number from a combo box, then enter their password. If their password matches the one in the database, then they get logged in. Problem is, my code doesn't select one specific user, it only takes the…
user3275784
  • 437
  • 1
  • 9
  • 18
-2
votes
2 answers

SQL select from more tables

Good day, I have 2 sql tables. Plaatsen - plid - x - y and Reservations - id - plid - startdate - enddate plid in reservations has a foreign key to Plaatsen.plid What i want is : I got 1 date (for example 2013-12-09) how can i find all…
Roboneter
  • 867
  • 2
  • 13
  • 24
-2
votes
2 answers

Turning SQL colums into seperate rows in new table SQL SERVER 2008

I have a table with a bunch of columns like this: ID, Name1, Name2, Name3, Title1, Title2, Title3, Email1, Email2, Email3 1, joe blow, Jane doe, john doe, president, secretary, janitor, no@no.com, yes@no.com,maybe@no.com I am trying to split into…
madscientest
  • 1
  • 4
-2
votes
1 answer

Different ways that data of tables can be physically organised on disk

Can anyone help me with this please? What are some of the different ways that the data of tables can be physically organised on disk?
suryll
  • 103
  • 2
  • 6
-3
votes
1 answer

Which SAP table do I need to find annual sales?

I don't know much about SAP but I need the annual sales (the total amount of what was sold in a certain year) for DSO calculation. In which SAP table is this stored? VBAK? Also for this calculation the accounts receivables (all payments that were…
Martin
  • 1
  • 1
-4
votes
3 answers

MySQL Understanding a Table

I am new to MySQL and I created a table, but I am not exactly sure what is going on. I have these lines: mysql> CREATE TABLE tutorials_tbl( -> tutorial_id INT NOT NULL AUTO_INCREMENT, -> tutorial_title VARCHAR(100) NOT NULL, ->…
user3771865
  • 11
  • 1
  • 1
  • 7
-5
votes
1 answer

How to display large data tables using plain html or php mysql or any other

I want to make a site of baby names. How do i display the baby name tables. using plain HTML and CSS or using PHP MYSQL tables or there is any other way or technology and which one loads faster. And how to make each name in a table as a link which…
rajendra prasad
  • 23
  • 7
1 2 3
…
20
21