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

Error Call to a member function getFieldNames() on null in codeigniter 4

I'm trying to get the columns name from "users" table in my database using detFieldNames function in codeigniter 4 but something went wrong. Here is the error: Error Model class: class UsersModel extends Model { public function __construct() …
sana khalid
  • 1
  • 1
0
votes
1 answer

How to put the constrain of duplicated entries in DynamoDB?

I am using DynamoDB under Python environment and I would like to use the following DynamoDB as an example: id time value 1 1 1 2 2 3 1 2 4 1 3 4 1 4 6 I would like to have a table that has unique id and time (not id or time). I…
Winston
  • 1,308
  • 5
  • 16
  • 34
0
votes
1 answer

Table design for monthly (time series) counts/stats in DynamoDB

I would like to store upwards of 100 time series in DynamoDB for each user. The data is aggregate monthly counts and is used for comparing monthly usage to permitted usage under varying subscription plans. Over 5 years, that's 100 x 5 x 12 = 6,000…
good1492
  • 161
  • 1
  • 10
0
votes
1 answer

How to create database table based on the type of the users

I have two types of users. For example: Male 2 Female Now I have created a table of 'users' that holds all the common information and 'males' and 'females' will hold specific information related to those. Now my question is how to create the table…
Istiyak Sheyam
  • 5
  • 3
0
votes
1 answer

I want to add multiple job roles for different durations in designation history table . how can i get it in ABAP?

I have 2 tables i.e employee details and employee designation history. Employee details table - EMPID , Name , Age ,Gender. (EmpID - Primary Key) Designation history table - EMPID , Startdate , Enddate , JobRole. I know there needs to be one more…
sumedh patil
  • 59
  • 3
  • 8
0
votes
1 answer

How to Modify the data inside database table for existing record in ABAP?

I have created database table ZSP_EMP_DET inside which I am performing CRUD operations by providing values through screen . So I have tried to find if record is already present in table or not and if found update values through screen but values are…
sumedh patil
  • 59
  • 3
  • 8
0
votes
1 answer

Query to select data from row into column in SQL Server

I have example table like this : type value ----------------------- Name | John Gender | Male Address | New City Phone | 62813 etc... | etc... I want to make query and show the data from row into column, and the…
Reinardus Hans
  • 77
  • 2
  • 8
0
votes
1 answer

what is the table design for this json request

Request body { "standard": '', "section": '', "subject": '', "type" : '', "startTime": '', "allDayEvent": false, "startTimezone": '', "endTimezone": '', "endTime": '' , "repeat": { "frequency":…
Teja sree
  • 1
  • 2
0
votes
1 answer

Check if a certain Table in MYSQL Database is empty C# (skeleton table)

My application starts with the login menu, a user provides his login credentials and the process of comparing passwords (hashed) goes on, logged in if everything is fine and error handlers kick in if there is an error. My question is, is there a way…
UnkownReality
  • 130
  • 13
0
votes
2 answers

SQLite extension in VSCode not showing tables

I am trying to use SQLite in VSCode. I have installed SQLite extension by Alexcvzz. after opening the database when I right-click on the table and select "Show Table" no data appear. please see the picture below. Note: I have created a database in…
Anonymous
  • 1
  • 1
  • 4
0
votes
1 answer

Creating Sub-Tables within a Table in PHPMyAdmin

I have this Menu for a restaurant with food categorized into different groups i.e.: For the Breakfast (food here) Salads (food here) Cold Beverages (drinks here) Hot Beverages (drinks here) etc. ... I've already created a table for the menu, I…
UnkownReality
  • 130
  • 13
0
votes
1 answer

How to decompose the tables for optimal querying

Suppose I have three tables Actor, Movie, Producer with following attributes Actor(Id,ActorName,Bio) Producer(Id,ProducerName,Bio) Movie(Id,Name,Description,ActorName,ProducerName) There can be many actors in a movie and actor can act many movies,…
nihar
  • 43
  • 5
0
votes
1 answer

Cross-platform way to check if "DUAL" table exists in SQL

I have an application that has the potential to use either an Oracle, MySQL, or SQL Server. In a few queries, I need to use the "DUAL" table, for example: SELECT (CASE WHEN EXISTS (SELECT 1 FROM MYTABLE) THEN 1 ELSE 0 END) FROM DUAL However, the…
user3163495
  • 2,425
  • 2
  • 26
  • 43
0
votes
1 answer

Should I split a table which has big size data?

I'm using MySQL. I need to save contents of XML file to database. The size of file is usually less than 10k. The table looks like this: articles ----------- id date writer ... file_name file_content (Text) file_date Does splitting the table improve…
Sanghyun Lee
  • 21,644
  • 19
  • 100
  • 126
0
votes
1 answer

Can a user import only the selected tables into HCL OneTest Data while importing any schema from a database?

When a user imports the schema or sample data set from a database into HCL OneTest Data, then can the user import only the selected tables?
askdev
  • 15
  • 2
1 2 3
…
20 21