You need supp_cd to be first in an index. Try
ALTER TABLE hpi_supp_agmt ADD INDEX supp_ind (supp_cd);
then try to add your foreign key constraint again.
Michael
Philip Walden wrote:
Michael Stassen wrote:
Hmmm..., it doesn't seem to be a problem for me in 4.0.17:
mysql CREATE TABLE t3
Hi Philip,
Hmmm..., it doesn't seem to be a problem for me in 4.0.17:
mysql CREATE TABLE t3
- (
-id CHAR(5) NOT NULL,
-description VARCHAR(48) NOT NULL,
-PRIMARY KEY (id)
- ) TYPE = InnoDB;
Query OK, 0 rows affected (0.02 sec)
Hi all,
When creating a stored procedure, what must I do to
create a procedure/function in a specific database?
I created a function hello like in the example, but
afterwards, I cannot create it from another database
connection.
The column db stays NULL in table procs.
Any idea?
With
I need to to the following
Select serial from serials;
Problem is I need to run this from a script which cron will call once a day,
how do you pass a select statement to mysql with user and pass so it can all
happen in one go?
--
-
Hi,
Am Dienstag, 3. Februar 2004 22:50 schrieb Alex croes:
I'm currently using MyCC as a tool to view and maintain a
MySQL-database of mine.
I find it quit a good tool, but which tool are you guys using. I have
heard about MySQLfront
and Navicat. Are this also good tools to maintain the
Hi,
I hope someone can point us in the right direction.
We have built up a database of over 2 million part numbers applicable to the
horticultural machinery trade.
This is held on our website in a MySQL database and subscribers can do all sorts of
searches by manufacturer or part number or
Scott Haneda wrote:
I need to to the following
Select serial from serials;
Problem is I need to run this from a script which cron will call once a day,
how do you pass a select statement to mysql with user and pass so it can all
happen in one go?
Something like this should work:
#!/bin/bash
On Wednesday 04 February 2004 05:44, Scott Haneda wrote:
I need to to the following
Select serial from serials;
Problem is I need to run this from a script which cron will call once a
day, how do you pass a select statement to mysql with user and pass so it
can all happen in one go?
mysql
hi
it is very simple in php
$query = 'SELECT *
FROM table
WHERE somefield = '.$somevalue.'
ORDER BY somefield
';
$mysql_result = mysql_query($query, $mysql_link);
while($row = mysql_fetch_array($mysql_result))
{
$output .=
On Jan 31, 2004, at 1:09 AM, Adam Goldstein wrote:
On Jan 30, 2004, at 10:25 AM, Bruce Dembecki wrote:
On Jan 28, 2004, at 12:01 PM, Bruce Dembecki wrote this wonderful
stuff:
So.. My tips for you:
1) Consider a switch to InnoDB, the performance hit was dramatic,
and it's
about SO much more
Hi,
Am Mittwoch, 4. Februar 2004 07:19 schrieb Hassan Schroeder:
Scott Haneda wrote:
I need to to the following
Select serial from serials;
Problem is I need to run this from a script which cron will call once a
day, how do you pass a select statement to mysql with user and pass so it
can
I just hacked out a script that will give me a month at a glance in MySql
3.x, I was thinking, there must be a way to do this in SQL.
Table
---
Name (varchar 48)
Date (timestamp 14)
Currently, I select distinct on the name to get all unique names, then I
iterate on each name and issue a
Ooops .. I think I have to be more precise about what I mean by
replication.
In facts the two servers A and B (in slave mode) have to replicate
different tables included in the same database and I do not want to manage
the replication through my application but only with the standard
- Original Message -
From: Luis Lebron [EMAIL PROTECTED]
The data tables look like this:
Manhours
mid | ProjectId |ChargeNum | Catid | Hours | EmployeeId
1 | 32 |11 | 19 | 80 |200020
2 | 32 |11 | 19 | 24
|23
Tasks
TaskID |ChargeNum |Catid |EmployeeId |Hours
Gowtham Jayaram [EMAIL PROTECTED] wrote:
- Are there any benchmarks that provide information
on time taken to run 'CHECK TABLE' and/or 'REPAIR
TABLE' on tables of different sizes ?
You can run your own benchmarks and find out the statistics you need.
- What are the factors that
Dear all
How can I make a user defined function (written in C/C++) what returns a
row or rowset / result set (like show open tables)
for example select udf(1,'par2') what returns
C1 | C2 | C3
+--+-
1 | 2 | A
2 | 3 | B
3 | 4 | C
Thanks Gerg
--
MySQL General
Why not use another language that has mysql hooks built in?
For example, from version 4.3.0 PHP comes with SAPI to allow scripting from
the command line, ideal for cron style tasks and it's mysql support is very
mature.
--
Russell.
--
MySQL General Mailing List
For list archives:
They are mostly windows-only tools!
CowBoyNeal uses only mysql console client! jejeje :-) (just a joke!)
PHPMyAdmin is a web based tool, very nice
SQLyog is a basic, very nice tool also (www.sqlyog.com)
DBTools is very very nice, and also support PostgreSQL
(www.dbtools.com.br)
MySQL-Front is
Hi all,
They are mostly windows-only tools!
CowBoyNeal uses only mysql console client! jejeje :-) (just a joke!)
PHPMyAdmin is a web based tool, very nice
SQLyog is a basic, very nice tool also (www.sqlyog.com)
DBTools is very very nice, and also support PostgreSQL
(www.dbtools.com.br)
Hassan,
By Murphy's law, they WILL get corrupted if you don't have a
backup. You need a current backup, or you need an older
backup and a way to redo the updates.
That said, if you do a FLUSH TABLES after your update, then
corruption is unlikely--no more likely than for any other OS file.
On 04-Feb-2004 Peter Lovatt wrote:
hi
it is very simple in php
snip
$query = 'SELECT *
$query=SELECT flds, you, want FROM ...
snip
$output .=
\$row[somefield]\\t\$row[some_other_field]\\t\$row[yetnothe
r_fiel
d]\\t ;
$output .=implode(\t, $row) .\n;
}// end
Martijn Tonies [EMAIL PROTECTED] wrote:
When creating a stored procedure, what must I do to
create a procedure/function in a specific database?
I created a function hello like in the example, but
afterwards, I cannot create it from another database
connection.
Currently you can't create
Hi,
When creating a stored procedure, what must I do to
create a procedure/function in a specific database?
I created a function hello like in the example, but
afterwards, I cannot create it from another database
connection.
Currently you can't create SP in the particular database.
Why not use another language that has mysql hooks built in?
Good suggestion.
For example, from version 4.3.0 PHP comes with SAPI to allow
scripting from the command line, ideal for cron style tasks
and it's mysql support is very mature.
Or better yet, Perl. Not only is its mysql support
I ran an insert..select from one table to the other ( changed some column types to int
from varchar on new table).
the insert went fine.
mysql INSERT INTO Feb04_int SELECT * from Feb04;
Query
I have a simple query:
SELECT id,year,month,day,cat_id FROM events
LEFT JOIN calendar_cat ON
events.cat=calendar_cat.cat_id
WHERE year=YEAR(CURDATE())
AND month=MONTH(CURDATE())
AND day=DAYOFMONTH(CURDATE())
AND cat_id='2' OR cat_id='5'
AND approved='1'
ORDER BY year,month,day ASC
Results:
Pierre Luguern [EMAIL PROTECTED] wrote:
Ooops .. I think I have to be more precise about what I mean by
replication.
In facts the two servers A and B (in slave mode) have to replicate
different tables included in the same database and I do not want to manage
the replication through my
From: John Croson [mailto:[EMAIL PROTECTED]
I have a simple query:
SELECT id,year,month,day,cat_id FROM events
LEFT JOIN calendar_cat ON
events.cat=calendar_cat.cat_id
WHERE year=YEAR(CURDATE())
AND month=MONTH(CURDATE())
AND day=DAYOFMONTH(CURDATE())
AND cat_id='2' OR cat_id='5'
AND
Martijn Tonies [EMAIL PROTECTED] wrote:
Hi,
When creating a stored procedure, what must I do to
create a procedure/function in a specific database?
I created a function hello like in the example, but
afterwards, I cannot create it from another database
connection.
Currently you
Hi John,
I think you missed on the precedence of AND/OR
if you change to
AND (cat_id='2' OR cat_id='5' )
it should work as you want it to
/Johan
John Croson wrote:
I have a simple query:
SELECT id,year,month,day,cat_id FROM events
LEFT JOIN calendar_cat ON
events.cat=calendar_cat.cat_id
WHERE
- Original Message -
From: rmck [EMAIL PROTECTED]
Are my indexes all gone?? If so how do I recover them! Thanks
hehe ;-)
MySQL just doesn't know the cardinality of the indexes yet (the cardinality
number is a *guess*)
Try CHECK TABLE and I think you will see the cardinality numbers
- Original Message -
From: rmck [EMAIL PROTECTED]
Are my indexes all gone?? If so how do I recover them! Thanks
hehe ;-)
MySQL just doesn't know the cardinality of the indexes yet (the cardinality
number is a *guess*)
Try CHECK TABLE and I think you will see the cardinality numbers
Did you run an ANALYZE TABLE?
Original Message
On 2/4/04, 9:33:30 AM, rmck [EMAIL PROTECTED] wrote regarding index
question:
I ran an insert..select from one table to the other ( changed some column
types to int from varchar on new table).
the insert went fine.
mysql INSERT INTO
Hi to all,
I'm fed up with Access as a wysiwyg editor for mysql. Generaly, i'm fed
up with client that i have to install on each comp. Actualy, i'm looking
for an opensource wysiwyg web software. Something like the very good
phpMyAdmin but with 'visual' request editor for simple users.
If
Hi!
On Jan 23, Dave Rolsky wrote:
Here's a recipe:
create table foo (foo text, bar text);
create fulltext index foo on foo (foo, bar);
mysql show index from foo;
I understand that I need to update the db's cardinality for this table
I need speed
Should I run CHECK TABLE or ANALYZE TABLE or myismachk -a?? I need the quickest one
because with 56179085 records this could take a while...
Thanks for the replies
Rob
-Forwarded
i'm using this one : http://vsbabu.org/webdev/zopedev/ieeditor.html
but it works just on IE5.5 SP1 and above (IE6;)
- Original Message -
From: fab [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 04, 2004 5:06 PM
Subject: wysiwyg web soft
Hi to all,
I'm fed up
Hi!
On Jan 12, Holm Tiffe wrote:
Description:
mysqld 4.0.17 crash on FreeBSD 5.1-current-alpha
How-To-Repeat:
Any acces over IP (not domain socket) crashes mysqld:
#/usr/local/bin/mysqladmin: connect to server at 'install' failed
error: 'Lost connection to MySQL server during query'
I've installed mysql under Linux and what I do, I always have this
number of error message :040204.
Please I need your help!
Thank u
Vinx
Accédez au courrier électronique de La Poste : www.laposte.net ;
3615 LAPOSTENET (0,34/mn) ; tél : 08 92 68 13 50 (0,34/mn)
--
MySQL General Mailing
Seeking opinions on this.
Server is Dual Pentium Xeon 2.8, 6 GB RAM, running RedHat Linux 7.2,
MySQL 4.0.17, all installed and tested with no problems.
I had a small database for testing purposes, and then dropped it,
leaving the default installation databases, mysql and test.
If I run top from
Mike Johnson wrote:
From: John Croson [mailto:[EMAIL PROTECTED]
I have a simple query:
SELECT id,year,month,day,cat_id FROM events
LEFT JOIN calendar_cat ON
events.cat=calendar_cat.cat_id
WHERE year=YEAR(CURDATE())
AND month=MONTH(CURDATE())
AND day=DAYOFMONTH(CURDATE())
AND cat_id='2' OR
Are you able to start the MySQL server? Is there anything being logged to
the hostname.err log?
Original Message
On 2/3/04, 7:23:50 PM, vincent.gueu [EMAIL PROTECTED] wrote
regarding Mysql error message:
I've installed mysql under Linux and what I do, I always have this
number of error
From: vincent.gueu [mailto:[EMAIL PROTECTED]
I've installed mysql under Linux and what I do, I always have this
number of error message :040204.
Please I need your help!
Thank u
I have no idea what your problem is, but I'd be amused if you had the number 040205
tomorrow (those being
Hi folks. I'm in the midst of moving from a debian unstable system to a
gentoo system and I'm having some problems getting mysql to give me the
same performance. On the new gentoo system (with more hardware) a fairly
complex query (a search on a UBBThreads forum) is taking 10+ seconds to
The older system is choosing to use a different index. I would suggest
running an analyze on your new tables and see if you can get the newer
system to use the same Postsindex8 index.
Original Message
On 2/4/04, 1:01:46 PM, Alan [EMAIL PROTECTED] wrote regarding index change
moving files
On Wed, Feb 04, 2004 at 07:21:30PM +, [EMAIL PROTECTED] wrote:
The older system is choosing to use a different index. I would suggest
Any idea why it would choose this? Shouldn't mysql keep using the same
indexes?
running an analyze on your new tables and see if you can get the newer
Hi,
When creating a stored procedure, what must I do to
create a procedure/function in a specific database?
I created a function hello like in the example, but
afterwards, I cannot create it from another database
connection.
Currently you can't create SP in the particular
Ive got a machine running redhat 9 kernel 2.4.20-28.9 and a recent update
from APT seems to have destroyed mysql somehow.
Mysql Version is 3.23.58-1.9
Any query kills the child process of mysqld and it has to respawn. This
does not seem to be the proper behaviour and it is causing many
Have you looked in the hostname.err logs for the MySQL server?
Original Message
On 2/4/04, 2:00:53 PM, Daniel Powell [EMAIL PROTECTED] wrote
regarding Mysql ECHILD resets on Queries:
Ive got a machine running redhat 9 kernel 2.4.20-28.9 and a recent update
from APT seems to have destroyed
We are implementing three or four MySql servers (as a start) and I'm
writing the Troubleshooting Guide for our operational staff. None of
these folks have any MySQL experience (and I'm a newbie myself). I need
a pretty basic 'Cheat Sheet' for troubleshooting common production type
problems.
The
Where exactly SHOULD these be and is it something I need to enable in
my.cnf
the generic /var/log/mysqld.log has this each time the process dies:
Number of processes running now: 0
040203 22:21:08 mysqld restarted
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not
We are implementing three or four MySql servers (as a start)
and I'm writing the Troubleshooting Guide for our operational
staff. None of these folks have any MySQL experience (and
I'm a newbie myself). I need a pretty basic 'Cheat Sheet' for
troubleshooting common production type
The hostname.err log will generally be located in the data directory.
Original Message
On 2/4/04, 2:42:02 PM, Daniel Powell [EMAIL PROTECTED] wrote
regarding Re: Mysql ECHILD resets on Queries:
Where exactly SHOULD these be and is it something I need to enable in
my.cnf
the generic
Sorry for the OT,
I deleted the messages from the perosn who sent me a response offlist.
In response to his personal emails in reply to:
http://lists.mysql.com/mysql/158945
he said, Perl was a write only language
(meaning it is hard to read since careless
people may do sloppy code - not me
This goes along with the PIDs
[EMAIL PROTECTED] mysql]# strace -p 20018
select(5, [3 4], NULL, NULL, NULL) = 1 (in [4])
fcntl64(4, F_SETFL, O_RDWR|O_NONBLOCK) = 0
accept(4, {sa_family=AF_UNIX, path=@¬@@è4@}, [2]) = 5
fcntl64(4, F_SETFL, O_RDWR) = 0
getsockname(5,
A locate *.err returns nothing?
What happens when you attempt to start MySQL with safe_mysqld?
Original Message
On 2/4/04, 3:04:54 PM, Daniel Powell [EMAIL PROTECTED] wrote
regarding Re: Mysql ECHILD resets on Queries:
nothing of the sort. no .err files on the machine nothing named
It appears to be running with safe_mysqld
root 7237 1 0 14:26 pts/000:00:01 /bin/sh /usr/bin/safe_mysqld
--defaults-file=/etc/my.cnf
and locate *.err returns nothing.
On Wed, 4 Feb 2004 [EMAIL PROTECTED] wrote:
A locate *.err returns nothing?
What happens when you attempt
If the server is up and running can you log in a perform a
show variales from the mysql monitor. From this information you can learn
where your logs are being stored.
...
Also, what sort of logging are you currently performing? Are you logging
just errors , slow queries or everything?
...
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I've reinstalled MySQL 4.1. I'm trying to start the server (mysqld_safe), but
it fails to start. The log file shows the message:
/usr/sbin/mysqld-max: Fatal error: Can't find messagefile
'/share/mysql/english/errmsg.sys'
The files exists, but the
its pretty default. I'd like to enable all logging if possible. What
specificly should I enable in my.cnf?
On Wed, 4 Feb 2004 [EMAIL PROTECTED] wrote:
If the server is up and running can you log in a perform a
show variales from the mysql monitor. From this information you can learn
where
All logging will grow very rapidly on a `busy` server. To enable all
logging you can add the --log option to the safe_mysqld command.
safe_mysqld --log
Original Message
On 2/4/04, 3:48:46 PM, Daniel Powell [EMAIL PROTECTED] wrote
regarding Re: Mysql ECHILD resets on Queries:
its pretty
I have two MySQL databases that are networked together. If changes can be
made independently to each of the databases - what is the best way to
synchronize them? How can I synchronize them in real time? If the network
link goes down, can the synchronizations be placed upon a queue until the
I may have resolved the crashing issue...
I upgraded gcc and libgcc, as well as bintools and cpp for dependancy
issues... the child PID no longer crashes... possible that the libgcc was
corrupt? im stracing the pid now and it does not exit as before. no more
constant respawning. I will
Hi Sergei!
Great news. Thanks very much! :-)
Matt
- Original Message -
From: Sergei Golubchik
Sent: Tuesday, February 03, 2004 1:54 PM
Subject: Re: query the data of a fulltext index directly from index?
Hi!
On Feb 02, Matt W wrote:
Sergei,
Any chance of getting a ft_dump
At 09:35 AM 2/4/2004, John Croson wrote:
I have a simple query:
SELECT id,year,month,day,cat_id FROM events
LEFT JOIN calendar_cat ON
events.cat=calendar_cat.cat_id
WHERE year=YEAR(CURDATE())
AND month=MONTH(CURDATE())
AND day=DAYOFMONTH(CURDATE())
AND cat_id='2' OR cat_id='5'
AND approved='1'
Here is my final analysis of this problem. May it be correct or not, mysql
is no longer panicing the child process..
libgcc was either corrupt or incompatible. It was the original version so
I lean towards corrupt. Whatever corrupted it, I have no idea what, mysql
was PISSED off about it.
Try setting the basedir=
parameter in your my.cnf file.
Original Message
On 2/4/04, 3:32:26 PM, Michael Satterwhite [EMAIL PROTECTED] wrote
regarding Starting MySQL 4.1:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I've reinstalled MySQL 4.1. I'm trying to start the server
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 04 February 2004 16:03, mos wrote:
At 09:35 AM 2/4/2004, John Croson wrote:
I have a simple query:
SELECT id,year,month,day,cat_id FROM events
LEFT JOIN calendar_cat ON
events.cat=calendar_cat.cat_id
WHERE year=YEAR(CURDATE())
Thanks,
No problem, but please post to the list and not just
me so we can all learn and share.
Also top posting is bad form, just FYI.
I have been perusing the web site, but the manuals don't
always give reasons WHY you would run something. For example
I am using 3 different systems...
Each have a registration system...
I believe they all use md5 to encrypt the password.
Is it possible to just put as the value of the password record something like this:
dbname.dbtablename
So that it will be that value, instead of one that is inserted into the
Hallo,
I am in the process of setting up a simple replication and have a
question that I can't figure out from the docs.
I have 2 servers, N1 is a test machine and hosts 2 databases live and
test. N1 is a slave to N2 which is a production machine and primary
host of live.
Basically I want to
On 4 Feb 2004, at 20:32, Dan Muey wrote:
We are implementing three or four MySql servers (as a start)
and I'm writing the Troubleshooting Guide for our operational
staff. None of these folks have any MySQL experience (and
I'm a newbie myself). I need a pretty basic 'Cheat Sheet' for
Michael Stassen wrote:
You need supp_cd to be first in an index. Try
ALTER TABLE hpi_supp_agmt ADD INDEX supp_ind (supp_cd);
then try to add your foreign key constraint again.
Michael
Looks like that does not work. BTW this does work (without adding a
separate index) in postgres.
mysql
Hello
I am going thru the source code of MySQL client.
I am not able to understand in general how MySQL is
handling unicode characters. All the function take
(char*) as arguments?
Is it expecting all the data to be UTF8-encoded and
before executing the queries (i was looking into the
batch
Hi,
Is it posssible to specific the max file size allowed for mysql database?
Thanks,
Keng Heng. Chan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
on 02/04/2004 02:23 AM, Bernd Tannenbaum at [EMAIL PROTECTED]
wrote:
2 possible ways to go:
Feed a Textfile with your statement in the db:
PATH/mysql db /sql_scripts/sql_statements_as_textfile --password=pass
Give command directly In the shell-script:
PATH/mysql --skip-column-names -e
Hi,
- Original Message -
From: [EMAIL PROTECTED]
Sent: Wednesday, February 04, 2004 12:12 PM
Subject: Server Behavior.
Seeking opinions on this.
Server is Dual Pentium Xeon 2.8, 6 GB RAM, running RedHat Linux 7.2,
MySQL 4.0.17, all installed and tested with no problems.
I had a
Hi David,
ALTER TABLE table ADD ListingID MEDIUMINT UNSIGNED NOT NULL
AUTO_INCREMENT PRIMARY KEY FIRST;
That will add the column at the beginning of the table (first column).
Remove FIRST from the end if you don't want that (it will then go at
the end) or replace it with: AFTER some_other_column
Sergei,
Any chance of getting a ft_dump Windows binary in the distribution? :-)
Regards,
Matt
- Original Message -
From: Sergei Golubchik
Sent: Monday, February 02, 2004 11:33 AM
Subject: Re: query the data of a fulltext index directly from index?
Hi!
On Feb 02, Alexander Bauer
I have a site where members rate movies they've seen. I run a routine to
recommend 5 titles based on movies they've given a max 5 rating. It's
very slow, and I think a better MySQL query can speed it up. I'm running
MySQL 3.23.54.
Tables:
movies (unique id plus movie info)
subcats (movie id,
Hi all,
I am not part of the official MySql team. I am just a lone developer.
I tried debugging MySql source (server) in Visual C++, but it doesn't
seem to work. I followed the instructions in the MySql manual and
added a few breakpoints at a few random places, but the debugger
never stopped
At 01:31 5/2/2004, Ananth Raghuraman wrote:
Hi,
Hi all,
I am not part of the official MySql team. I am just a lone developer.
I tried debugging MySql source (server) in Visual C++, but it doesn't
seem to work. I followed the instructions in the MySql manual and
added a few breakpoints at a few
I have a database with one 17GB table containing about 23 million customer records.
The table has about 15 fields. I wanna index five of them to speed up searching.
My indexing operation keeps failing with error:127 (record table has crashed).
The process fails of different fields at different
Hi,
Thanks for the info!
I am already able to debug the server startup.
I would like it to stop
at someother point, perhaps a point where a SELECT statement is executed
for example..
Thanks!
-Original Message-
From: Miguel Angel Solorzano [mailto:[EMAIL PROTECTED]
Sent: Thursday,
Philip Walden wrote:
Michael Stassen wrote:
You need supp_cd to be first in an index. Try
ALTER TABLE hpi_supp_agmt ADD INDEX supp_ind (supp_cd);
then try to add your foreign key constraint again.
Michael
Looks like that does not work. BTW this does work (without adding a
separate index)
Hi,
I am new to mysql managed to do the mysql replication, that works fine.
Now can this whole process be automated.
For example:
1) Asume that more that 2 mysql servers can be used for the replication,
like A-B-C
A--master
B,C -- Slaves to A
2) Also in the scenario 1 is it possible to make
Hi,
Am Donnerstag, 5. Februar 2004 03:43 schrieb Scott Haneda:
on 02/04/2004 02:23 AM, Bernd Tannenbaum at [EMAIL PROTECTED]
wrote:
2 possible ways to go:
Feed a Textfile with your statement in the db:
PATH/mysql db /sql_scripts/sql_statements_as_textfile --password=pass
Give
Dominique:
Thanks for your suggestions/ideas. After playing with it for a little while
longer of banging my head into a brick wall, I realized I was using a left
join when I needed a right. You have my table structures pretty much down -
here's the final SQL statement that I use to return 1 row
88 matches
Mail list logo