Sql Questions

Ad

Multiple foreign keys?

I've got a table that is supposed to track days and costs for shipping product from one vendor to another. we (brilliantly :p) stored both the
Ad
Ad

mysql full text search is empty

I am using ruby on rails with a mysql backend. i have a table called notes and here is the migration i use to create it: def
Ad

MySQL Results to a File

How do i write the results from a mysql query to file? i just need something quick. output can be csv, xml, html, etc.
Ad
Ad

Generate field in MySQL SELECT

If i've got a table containing field1 and field2 can i generate a new field in the select statement? for example, a normal query would be:

Boolean Field in Oracle

Yesterday i wanted to add a boolean field to an oracle table. however, there isn't actually a boolean data type in oracle. does anyone here know

Add 1 to a field

How do i turn the following 2 queries into 1 query $sql = "select level from skills where id = $id limit 1;"; $result =
Ad
Ad

Nested dropdown

I'm building a form with php/mysql. i've got a table with a list of locations and sublocations. each sublocation has a parent location. a column
Ad

Inheritance in database?

Is there any way to use inheritance in database (specifically in sql server 2005)? suppose i have few field like
Ad
Ad

Blog Categories

Ad