What is the 'idx' for when you already have an 'id' column? Also, you
need an index on the column that you are joining on; having a single
indexed column on a table doesn't automatically improve all queries
against that table. Put an index on the 'email_address' fields of both
tables. You'll
]
ext #4176
!DSPAM:40fbe134327511661126047!
--
. Garth Webb
. [EMAIL PROTECTED]
.
. shoes * * schoenen * * chaussures * zapatos
. Schuhe * * pattini * * sapatas *
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
address
was not grouped.
What can I do or where did I go wrong?
Thanks!
Aaron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
. Garth Webb
. [EMAIL PROTECTED
]
--
. Garth Webb
. [EMAIL PROTECTED]
.
. shoes * * schoenen * * chaussures *
zapatos
. Schuhe * * pattini * *
sapatas *
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED
iptable
GROUP BY ip
ORDER BY num DESC
LIMIT 10
--
. Garth Webb
. [EMAIL PROTECTED]
.
. shoes * * schoenen * * chaussures * zapatos
. Schuhe * * pattini * * sapatas *
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
was transpose the cs_fld table with the cs_fld_cs_tbl_l and bam! I
get the more efficient time.
My question is: How do I determine which table should be on which side of
the join statement?
Thanks to all who respond - I really am stumped on this one.
--
. Garth Webb
. [EMAIL PROTECTED
.
__
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail
--
. Garth Webb
. [EMAIL PROTECTED]
.
. shoes * * schoenen * * chaussures * zapatos
. Schuhe * * pattini * * sapatas *
--
MySQL
on how large a particular insert
can be, but this error looks like perl is truely running out of memory,
rather than being denied by MySQL.
--
. Garth Webb
. [EMAIL PROTECTED]
.
. shoes * * schoenen * * chaussures * zapatos
. Schuhe * * pattini * * sapatas *
--
MySQL General Mailing List
You could also try:
SELECT owner, COUNT(*) FROM pet GROUP BY owner;
SELECT FOUND_ROWS();
On Mon, 2004-06-14 at 20:41, Dave Torr wrote:
Thanks - this did not work for me as I am on 4.0.17 - presumably this works
on 4.1 (seems to need the SubQuery feature)? If so I will upgrade
You might have better luck with this on the [EMAIL PROTECTED] list,
re: why this doesn't work. This works for me though:
$pk = $dbh-{mysql_insertid};
On Mon, 2004-06-14 at 21:42, Daniel Kasak wrote:
Hi all.
I'm writing an app in Perl / Gtk2, and I'm having trouble with DBI's
since i counted a 0 value in the distinct
part ...
- hcir
That's what I needed. Thanks!
Note that this solution will be off by one if there aren't any zeros in
your data. Try this:
select count(IF(field0,NULL,1)) +
count(distinct IF(field0,field,NULL))
from test;
--
. Garth
, and events..?
To simplify, is It better to have many smaller lookup tables or one big
one?
Thanks,
Taylor
--
. Garth Webb
. [EMAIL PROTECTED]
.
. shoes * * schoenen * * chaussures * zapatos
. Schuhe * * pattini * * sapatas *
--
MySQL General Mailing List
For list archives: http
to create your pages. Only after you've
figured out all the intermediate steps will it be possible to fix the
code dreamweaver outputs when it goes wrong.
Garth
--
. Garth Webb
. [EMAIL PROTECTED]
.
. shoes * * schoenen * * chaussures * zapatos
. Schuhe * * pattini * * sapatas *
--
MySQL
? How?
-Paul
--
. Garth Webb
. [EMAIL PROTECTED]
.
. shoes * * schoenen * * chaussures * zapatos
. Schuhe * * pattini * * sapatas *
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Thu, 2004-05-06 at 07:24, luther van dam wrote:
I am new to MySQL but I some basic database experience.
I have about 50,000 rows of data in a CSV file.
Where I can find some examples of SQL scripts that show how to:
a. Create a database X.
b. Create a table Y.
c. Import the 50,000
On Mon, 2004-05-03 at 10:39, Boyd E. Hemphill wrote:
My boss says that if you do a select statement against a table the
result set always comes back in the same order. I say that this is a
myth and that the result is random, except when some ordering is
specified in the SQL statement.
Who
database specific order, they might as well be random.
bob
At 12:55 PM 5/3/2004, Garth Webb wrote:
On Mon, 2004-05-03 at 10:39, Boyd E. Hemphill wrote:
My boss says that if you do a select statement against a table the
result set always comes back in the same order. I say
On Fri, 2004-04-30 at 06:03, Richard A. DeVenezia wrote:
I'm running 4.1.1a-alpha-max-nt using innodb tables with foreign keys .
I know how to use SHOW TABLE STATUS to see the referential linkages in the
COMMENT column.
Supppose I am typing away in MySQL monitor:
Q: Is there a way to
On Mon, 2004-04-26 at 14:59, Matthias Eireiner wrote:
hi there,
I have a basic question:
how can I simplify multiple OR statements in a WHERE clause where I have
only one column to which I refer?
e.g.
SELECT word FROM word_table WHERE id = 1 OR id = 34 OR id = 78 OR id = 8787
OR ...
WHERE queue_time BETWEEN date_format(curdate(),
%Y%m%e00) AND date_format(curdate(), %Y%m%e235959);
--
|- Garth Webb -|
|- [EMAIL PROTECTED] -|
signature.asc
Description: This is a digitally signed message part
]
--
|- Garth Webb -|
|- [EMAIL PROTECTED] -|
signature.asc
Description: This is a digitally signed message part
address. **
--
|- Garth Webb -|
|- [EMAIL PROTECTED] -|
signature.asc
Description: This is a digitally signed message part
that the slave and master alternately
locked, rather than locking all the table you'll use. That way
processes on the master that just want to read the data don't have to
wait for a lock.
--
|- Garth Webb -|
|- [EMAIL PROTECTED] -|
signature.asc
Description: This is a digitally signed
-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp
--
|- Garth Webb -|
|- [EMAIL PROTECTED] -|
signature.asc
Description: This is a digitally signed message part
may miss something obvious here but as I
said I have limited knowledge about sql. I would be much grateful for any
tips.
Lecho
--
|- Garth Webb -|
|- [EMAIL PROTECTED] -|
signature.asc
Description: This is a digitally signed message part
Attributes
unsigned
Null
Not_null
Default**
?
Extra
auto_increment
I'm not sure what to enter for Default**. Can someone tell me what I'm
missing?
I'm using MySQL5.0alpha w/PHP4.3.4 on W2K3.
Thanks
--
|- Garth Webb
when you sort.
So what exactly is your question? A question ans some examples of
things you have tried already would help.
--
|- Garth Webb -|
|- [EMAIL PROTECTED] -|
signature.asc
Description: This is a digitally signed message part
'
and '20031231235959';
?
--
|- Garth Webb -|
|- [EMAIL PROTECTED] -|
signature.asc
Description: This is a digitally signed message part
If you want the last page seen, then you could change the 'min' to a
'max' in the statements above.
--
|- Garth Webb -|
|- [EMAIL PROTECTED] -|
signature.asc
Description: This is a digitally signed message part
:
Greetings -
Been scouring the docs for this all day and I come up with nothing for
'delimiter' - Id like to change the default delimiter in mysql to something
other than tab.
Is there a command to do this, and what are the options?
Thank you!
David
--
|- Garth Webb -|
|- [EMAIL
)
from your_table
where date between '2004-02-01 00:00:00' and
'2004-02-29 23:59:55'
group by Unit;
--
|- Garth Webb -|
|- [EMAIL PROTECTED] -|
signature.asc
Description: This is a digitally signed message part
the first 2000 or so earliest dates cannot be
selected. All dates after this 'blackout' period can be selected
without a problem.
--
|- Garth Webb -|
|- [EMAIL PROTECTED] -|
signature.asc
Description: This is a digitally signed message part
32 matches
Mail list logo