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

Server (jsp) cannot send the data to MYSQL db due to inrecognizable internal errors aren't showing up in stackTrace

I have created a web project that need to register user data in database table that can be used further. registration.jsp <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%>
Abhi
  • 3
  • 2
0
votes
1 answer

Get name of current table by resultSet on RowMapper

It's possible get name of current table, on implementation of RowMapper. I try by metadata, but not have sucess
Thiago
  • 13
  • 5
0
votes
1 answer

Datatable constraints with C#

I have a Data table whose primary key should be case sensitive. i.e. 'abc' and 'ABC' should be considered unique. Hence I have enabled CaseSensitive property of a datatable to true. But the performance is degraded as I am loading 6000+ items in the…
Amit
  • 3,358
  • 9
  • 34
  • 48
0
votes
2 answers

How to Give Proper Pagination To Data Table using Pagination library in Codeigniter

I am Working pagination in CodeIgniter. I see tutorials and user manual also. but I can't find the way to do it properly they call the database in Controller for pagination. I want a proper solution. This is The Controller public function…
always-a-learner
  • 3,671
  • 10
  • 41
  • 81
0
votes
1 answer

New Table with Fields from Dictionary?

How do I create a table in sqlite3 with dictionary items as fields? I can't simply define each and every field manually, since I have a lot of dictionaries of various sizes. Is there a way to accomplish this? Here's what I've come up so far: import…
St4rb0y
  • 317
  • 3
  • 5
  • 22
0
votes
1 answer

Empty table in MySQL even though Python can insert data into table

I'm new to mySQL and Python. I have code to insert data from Python into mySQL, conn = MySQLdb.connect(host="localhost", user="root", passwd="kokoblack", db="mydb") for i in range(0,len(allnames)): try: query = "INSERT INTO resumes…
abi
  • 285
  • 1
  • 7
  • 17
0
votes
1 answer

Cakephp inherited tables

I have the following situation with three tables, which are inherited from contactBasics contactSales (foreign key of contactBasics) contactSupporters (foreign key of contactBasics) The general data about a person is stored in…
endo.anaconda
  • 2,449
  • 4
  • 29
  • 55
0
votes
2 answers

How can we Substract SUM(s) of two columns from two tables in Cakephp

I have two tables called SalaryPayment and SalaryStaff. SalaryStaff Table +-----------------+------------+-------------+ | SalaryStaffId | EmployeeId | TotalWage | +-----------------+------------+-------------+ | 6 | 5 …
Marvil Joy
  • 662
  • 6
  • 15
0
votes
3 answers

Postgresql : Alternative to joining the same table multiple times

If i have two tables entry and entry_metadata, with the entry_metadata as a description table for the entry referenced by entry_id and a variable. If i have this : entry id | name | ------------- 1 | entry1 | 2 | entry2 | 3 | entry3…
muffin
  • 2,034
  • 10
  • 43
  • 79
0
votes
1 answer

Adding constraint to two columns

I have a database table with columns "User","Role"and"Application". My requirement is that a user can only have one role but he can belong to multiple applications. I will want add this restriction in form of a constraint but i am not able to…
Lokesh
  • 7,810
  • 6
  • 48
  • 78
0
votes
0 answers

Controls bound to table with diffrent row layouts

So i have this scenario where i have a database table that can contain values of diffrent types. Most of the values will be static text from another table, but a few rows will contain a "freetext" value. The problem i have is trying to make a layout…
Daniel Andersson
  • 96
  • 1
  • 4
0
votes
5 answers

Update part of a value in mysql table

I have a table "users" in mysql with around 2K records. In the table, there is a field "status". The status can be of 2 to 3 words. In few status, at the end, there is a space followed by an asterisk mark. I want to remove the space and asterisk.…
Sabha
  • 621
  • 10
  • 32
0
votes
2 answers

Size/Length and Type of a SQL table

How do I find the length and type of a column in a SQL Table Column? i.e. While creating a table if someone used Varchar(20), I want to identify this information whether it is Numeric or Varchar and the length/size. Also, can I reduce the size of…
Xion
  • 318
  • 1
  • 5
  • 19
0
votes
0 answers

Participant Registration database

I am working on a database to store information about participants that have enrolled in a program. I made up three tables to store information regarding three types of participants. They are; Transport Operators, Artifacts Producers, and Artifacts…
Gaby
  • 1
0
votes
2 answers

Compare data postgresql

I have got a database and a table inside it. Here my table: Houses ( id, doors, windows, bathrooms, wallColor, dateRent ) I want to compare data os this table and get if it is equal or not: For example: Select id, doors,…
Za7pi
  • 1,338
  • 7
  • 22
  • 33
1 2 3
…
20 21