Hi all -
I've got a database along the lines of the following
--
| Transactions | | Products | | TransDetails |
--
| TransID | | ProdID | | TransID |
| TransDate| | ProdName | |
I have two tables as below:
CREATE TABLE domain_types (
type_id INT(4) NOT NULL AUTO_INCREMENT,
name VARCHAR(10) UNIQUE NOT NULL,
description VARCHAR(75),
PRIMARY KEY(type_id)
) TYPE=INNODB COMMENT=Types of domains we store;
CREATE TABLE domains (
domain_id INT(6) NOT NULL
= d.type_id
group by t.name
order by t.type_id
or something with a 'join on t.type_id = d.type_id'
-yves
-Ursprüngliche Nachricht-
Von: Alec Smith [EMAIL PROTECTED]
An: [EMAIL PROTECTED]
Gesendet: Freitag, 25. Juli 2003 23:08
Betreff: Selecting unique values
I have two tables
I have two tables as below:
CREATE TABLE domain_types (
type_id INT(4) NOT NULL AUTO_INCREMENT,
name VARCHAR(10) UNIQUE NOT NULL,
description VARCHAR(75),
PRIMARY KEY(type_id)
) TYPE=INNODB COMMENT=Types of domains we store;
CREATE TABLE domains (
domain_id INT(6) NOT NULL
I have two tables as below:
CREATE TABLE domain_types (
type_id INT(4) NOT NULL AUTO_INCREMENT,
name VARCHAR(10) UNIQUE NOT NULL,
description VARCHAR(75),
PRIMARY KEY(type_id)
) TYPE=INNODB COMMENT=Types of domains we store;
CREATE TABLE domains (
domain_id INT(6) NOT NULL
Hi -
[Perhaps not exactly the right list, but [EMAIL PROTECTED] doesn't
seem to be too active, so I'm hoping someone here might be able to offer
some insight.]
I'm getting the below error when trying to connect to a MySQL 4.0.12
server on RedHat 9 using a Perl script:
DBI
I've got a table containing dates as follows (number of rows edited for length)
mysql select * from chat_schedule;
+-+--+-+
| schedule_id | model_id | timeslot|
+-+--+-+
| 1 |2 |
I've got a table containing dates as follows (number of rows edited for length)
mysql select * from chat_schedule;
+-+--+-+
| schedule_id | model_id | timeslot|
+-+--+-+
| 1 |2 |
What would be the correct query to convert a date stored in MySQL in a
DATETIME field to month_name month_date, year format at the same time I'm
pulling a bunch of other data from the same row as the field with the
date I need converted? I've tried something like the below without
success:
I'm just starting to learn SQL and MySQL, and am curious as to how the
following query might be built.
I've got a table of X rows, each with a unique ID as determined by
auto_increment when the row is inserted into the database. How would I go
about doing a SELECT on a row of the database and
As the RPMs available on the MySQL site are built against RH6.x libraries,
is there someplace where I can get versions linked against RedHat 7
libraries? RedHat themselves don't seem to have anything newer than 3.23.32
whereas I'd like to use 3.23.34.
Yeah yeah, I know I should have installed
As the RPMs available on the MySQL site are built against RH6.x libraries,
is there someplace where I can get versions linked against RedHat 7
libraries? RedHat themselves don't seem to have anything newer than 3.23.32
whereas I'd like to use 3.23.34.
Yeah yeah, I know I should have installed
12 matches
Mail list logo