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

'Users' SQL table out of control. Searching for a better way

I've been programming and using a survey software for more than three years. It began as a simple survey system, with a basic 'users' SQL table, as you can find, for instance, in most CMS's. I initially planned to use the program two or three times,…
Stephane
  • 781
  • 1
  • 5
  • 4
0
votes
3 answers

SQL GROUP BY with two tables involved

Could you guys help me to make SELECT query for my simple case: Table A: UserID UserName 10 John 11 Mike 12 Matt Table B: SessionID UserID SessionTime 124 10 20 123 10 122 42 …
MikZ
  • 364
  • 2
  • 13
0
votes
0 answers

Table missing in a database but query works

I have a table TBLT_GLDET in my SQL Server 2008 database. When I open a new query window and select the right database and execute following query select * from TBLT_GLDET; the data appears. But in the tables list the table does not appear. Also…
ChathurawinD
  • 756
  • 1
  • 13
  • 35
0
votes
1 answer

is it allowable to use the same tables from the different microservices?

We have 2 microservices: service_A, service_B. Both of them use the same database. Today I find out that we have repositories for the same tables used by the different services. I remember that I read that it is a design mistake for some reason and…
gstackoverflow
  • 36,709
  • 117
  • 359
  • 710
0
votes
1 answer

Passing database table name into another page

Im trying to pass the value of the database table name to another page. I succesfully display all the database table from my database but the problem is that Im trying to pass it to another page when I click the database table name so that I can get…
Rick Ryan Medillo
  • 11
  • 4
0
votes
1 answer

Prevent over booking ticket by using busno and date

Am working on small project and am new to coding, i want the system to be a booking system whenever specific bus is booked for specific date then that bus will be specific to that date. for example Bus12 is booked to be used on 21 of Aug then if by…
yasmin ahmed
  • 39
  • 7
0
votes
1 answer

Supporting table structure changes in JPA/Eclipselink

I'm fairly new to JPA/Eclipselink and facing a problem which is in 2 parts - First - I needed to add CLOB field my existing table. I made the required change to persistence classes and it worked with MySQL as database without changing the below…
javshak
  • 179
  • 2
  • 15
0
votes
1 answer

How to count the number of entries in one column

I have a simple Excel sheet, containing different columns, each of them having their title. Each of the cells, containing the title, have a name, e.g. the column containing the first entries (key values), starts with the cell with the name…
Dominique
  • 16,450
  • 15
  • 56
  • 112
0
votes
1 answer

How to copy data from a view of one server into the database table of another server in a SQL server database?

how can i copy data from a view of one server into the database table of another server in a SQL server database without using linked servers method. I tried using the code: SELECT [LogEntryID] ,[TimeStamp] Into…
user9630935
  • 349
  • 1
  • 4
  • 18
0
votes
1 answer

How to run same query on every single row of a table? (MVC)

I'm currently having a table named 'Events' where there are columns 'EquipApprovedDate', 'EquipCalDueDate', & 'ThemeColor'. I want to update the ThemeColor based on the remaining days left before the EquipCalDueDate. Green = Good Orange =…
Maheswarha Rajagopal
  • 49
  • 6
0
votes
2 answers

Should I store Users and Staff in the same table?

I'm working on database design for my new application that has people with two different roles in the system. Those two groups are User and Staff. The main difference is that Users have activeUser,username,password,security-question and answer and…
espresso_coffee
  • 5,980
  • 11
  • 83
  • 193
0
votes
2 answers

Yii2: how to show data from two related tables?

I have the table persons(id_person, name_person, id_color) and the table colors(id_color, name_color). I need to show names of the persons and the color name of every person inside a Select2 component. I am using a Select2 component very similar to…
Roby Sottini
  • 2,117
  • 6
  • 48
  • 88
0
votes
1 answer

Users and Staff in the same table or separate tables?

I have to decide on design of my database for my application. So far I have Users table that stores these fields: **USERS** RecID - auto increment UserID - unique id (Primary…
espresso_coffee
  • 5,980
  • 11
  • 83
  • 193
0
votes
1 answer

Creating fields in database

I am making a quiz portal and for that I am having a quiz table. Here I am saving the quiz id , quiz questions and quiz answers. Now I am confused in the quiz answers part. My question has 4 options so should I make 4 columns for four options, or…
Tarun
  • 271
  • 1
  • 6
  • 18
0
votes
3 answers

How to represent this in a table?

I have a collection of data like so Programme title | Episode | Subtitle | Performers | Description Initially I normalised this into two table like so PROGRAMME progid | progtitle | description EPISODE epid | progid | episode | …
PDStat
  • 5,513
  • 10
  • 51
  • 86
1 2 3
…
20 21