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

Display all tables created after a particular date

I am using Oracle11g for creating database applications. My question is that I have close to 100 different tables in my database and I want to list out all the tables created after a particular date. Is there any way of listing out these tables.…
Jeris
  • 2,355
  • 4
  • 26
  • 38
1
vote
1 answer

More efficient to have two tables or one table with tons of fields

Related but not quite the same thing:which is more effcient? (or at least reading through it didn't help me any) So I am working on a new site (selling insurance policies) we already have several sites up (its a rails application) that do this so I…
Ryan
  • 5,644
  • 3
  • 38
  • 66
1
vote
0 answers

List[Map[String,A]] to database table in scalaquery

I just learnt about scalaquery yesterday and it seems useful. I'd like to convert a List[Map[String,A]] (where A is a primitive type - Int, Float, String etc. and the set of keys in each of the maps are the same) to a database table. I couldn't find…
Ashwin
  • 445
  • 5
  • 9
1
vote
1 answer

MYSQL request from two tables with CONCAT

maybe you can help me: If have a table1: accounts user_id account_id 39 3799207 39 80286966 40 3789458 ... table2: subscribers id client_id master_id master_account_id active 1 43 39 3799207 …
XTRUST.ORG
  • 3,280
  • 4
  • 34
  • 60
1
vote
2 answers

MYSQL request from two tables

May be you can help me: I have a tables: 1: Users id username email 1 myname myname@myname.com 2 myname2 myname2@myname.com 2: Accounts user_id account 1 37992054 2 3804933 1 23286966 I need to make a…
XTRUST.ORG
  • 3,280
  • 4
  • 34
  • 60
1
vote
1 answer

creating two tables in sqlite/android and showing their contents

I have created one table, but i want to create two and when i hit the "show" button, i want to be able to select contents from both tables and show them...this is my code...am having problems creating two tables and showing them: public class…
user1179083
  • 79
  • 1
  • 5
  • 17
0
votes
3 answers

copying SQL server DB table from one server to another

I am trying to copy a table from a live remote server to my local development machine. I tried: select * into mmm from [sqlb8.webcontrolcenter.com].[1photo].[kelraie].[pix] But got this error: Msg 7202, Level 11, State 2, Line 1 Could not find…
Khaled
  • 9
  • 1
  • 4
0
votes
2 answers

How to associate Article with multiple categories

New to PHP/MySQL and building a CMS. I need to know how to associated an Article with multiple Categories eg "My Article 1" has to be in 3 categories and "My Article 2" has to be in only 2 etc. It's basically just the table set up to begin with.…
Crashdesk
  • 665
  • 8
  • 27
0
votes
1 answer

Create database tables from html tables

I need help creating database tables from html tables. Right now I'm just manually doing it. I have a html doc that has all the data but I don't know what the best way to extract the data.
e417927
  • 19
  • 6
0
votes
2 answers

Getting the last answer id for the questions

In M.C.Q test, when user come back to the same question again how can I track the last answer given for the question?, following is the table structure Method: 1 temptblUserAnswer id uid qid ansid 1 1 1 5 2 1 …
user841123
0
votes
0 answers

Notify Blazor + EF Core server when a db table is externallly changed?

I have a EF Core + Blazor client/server application where a table in an sql database may be updated by an external service. The server keeps a copy of that table and should react to changes to the original table (the application needs a copy for…
Razzupaltuff
  • 2,250
  • 2
  • 21
  • 37
0
votes
2 answers

Searching for a specific JOB by the procedure it calls

Is it possible to search a JOB by the code it executes? I.E. I want to find the JOB that launches a certain stored procedure. Is there a query to do it?
Revious
  • 7,816
  • 31
  • 98
  • 147
0
votes
0 answers

ASP.NET Core 6 : cascading foreign key 'x' cannot be created where the referencing column 'y' is an identity column

I'm new to building web applications with ASP.NET Core MVC. My current issue is that I got a lot of errors trying to add users to my database. Previous issue that I had was when I tried creating a new user: Cannot use table 'Users' for entity type…
Marky
  • 55
  • 7
0
votes
0 answers

Devexpress, Can't Insert a new row if the database is empty

As the title describes, I have a table in my database, my BootstrapGridView displays a cannot insert new record because some field doesn't allow Null (Despite its not NULL), the weird thing is that if I add a record manually directly in the…
Dhiya Eddine Harnane
  • 1
0
votes
0 answers

Should a one-to-many relationship create a table

I am designing this database for a manufacturing company that produces boards for other factories to produce harnesses and I have created an items table, where each record is an item in the board to be produced, for example a fixture. When a…
Gibrán Vazquez
  • 54
  • 5
1 2 3
…
20 21