Top "Database-table" questions

In a relational database management system (RDBMS) a table organizes the information in rows and columns.

MySQL: Select Random Entry, but Weight Towards Certain Entries

I've got a MySQL table with a bunch of entries in it, and a column called "Multiplier." The default (and …

php mysql select random database-table
Linq left outer join

I ultimately what I needed is generic function which would take two datatable and and 2 tablekeys and return Joined datatable. …

vb.net linq join database-table
Query to find the difference between successive rows in Mysql

As I am new to MySQL, this question may be silly. How can I find the difference between successive rows? …

mysql database-table
Creating a SQL table from a xls (Excel) file

I'm trying to convert an Excel document into a table in SQL 2005. I found the link below and am wondering …

sql excel sql-server-2005 database-table
Android SQLite copy table to another table

I want to implement delete column in Android's SQLite. I want to make table copy without desired column, than delete …

android sqlite copying database-table
How do you determine the base table?

My question is in relation to database theory. If I am given a set of tables, is there a way …

database database-design theory database-table
How to join two tables on three conditions?

hope someone can figure out what I'm doing wrong here. The task seems quite simple, but is apparently beyond me. …

sql join criteria database-table