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 AUTO_INCREM
ns d
> where t.type_id = 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
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 AUTO_INCREM
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 AUTO_INCREM
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 connect('mailers:192.16
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 | 2001-11
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 | 2001-11
You might also take a look at Z3 Internet (www.z3.com). I've had zero
problems dealing with them for several years now without problem. Its easy
to get custom packages at affordable rates, and tech support (on the rare
occasion its actually needed) is first rate. The sysadmins have even gone
so fa
, '%M %d, %Y') FROM
guestboo
k;
++---+--+
| name | city | DATE_FORMAT(post_timestamp, '%M %d, %Y') |
++---+--+
| Alec Smith | Lyndhurst | June 04, 2001
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:
SELECT
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 hav
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
14 matches
Mail list logo
