`jiveForum_catIndex_idx` (`categoryIndex`)
) TYPE=InnoDB
Below are the logs of the first two crashes and some additional comments
from yours truly.
Best Regards, Bruce
031124 16:27:18 InnoDB: Assertion failure in thread 2167428608 in file
row0upd.c line 713
InnoDB: Failing assertion: len == dfield_get_len(dfield
and the the mysql.server stop
script stops mysqld and mysqld_safe then decides to quit... I don't know how
to fix it for OSX... I'm happy to add something to the relevant part of
mysqld.server to kill mysqld_safe's shell if I knew the right shell to kill.
Any ideas here?
Best Regards, Bruce
Using a select statement, how does one
select all records that have a date one day
less than the current date? Searching the archives
and I can't seem to find the answer..
Our database has these fields:
EMAIL, AMOUNT, ID, DATE
The date is in format 00/00/
Thanks
--
Bruce Therrien
Regards, Bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
why this
instance was behaving as if it was set to 1.
Best Regards, Bruce
On 9/25/03 11:27 PM, Bruce Dembecki [EMAIL PROTECTED] wrote:
Hi. We are migrating our Solaris setup to an OSX server. I used InnoDB Hot
Backup to copy the InnoDB files, and copied the .frm files for each of the
databases
'double' for currency; it gives roundoff errors.
Bruce Feist
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Bob Hall wrote:
Bruce Feist has initiated a discussion with me off the list,
Off the list by accident, by the way. I sometimes forget that in this
list I need to do a REPLY ALL. I generally don't go private unless I
want to avoid embarassing someone or need to discuss something genuinely
search for those?
Select distinct on both:
select distinct stateID, cityID
...
Bruce Feist
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, while = .
Bruce Feist
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
nightmares.
I can't think of any reason why you would use a zero-length string in
a database.
Because you know that a given person has no middle name?
To represent no value, as differentiated from not known?
Bruce Feist
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Dan Nelson wrote:
In the last episode (Sep 15), Bruce Feist said:
The application is payroll/personnel. A programmer is tasked with
creating forms for data entry on new employees, including supervisor.
If the user doesn't enter a new employee's supervisor, the
application accepts
--
it suggests that there might be an unlimited, or at least a large,
number, and that not all possibilities have been clearly identified.
Bruce Feist
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
r.seat_num + 1 AND r.seat_num
+ :seats_needed -2)
AND bad.seat_status AVAILABLE
WHERE bad.row_num IS NULL;
SELECT *
FROM good_ranges;
DROP ranges, good_ranges;
Warning: None of the above queries has been tested!
Bruce Feist
--
MySQL General Mailing List
For list archives
(if any) which does not match the t1 row.
Bruce Feist
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
flush logs from the mysql command line works
Jesse Sheidlower wrote:
I recently restarted my MySQL server (4.0.10 in this case) with
the general query log enabled, to help out with some debugging and
optimization issues. After looking at a batch of these, I then
deleted the log file directly,
in his original question. If IDs are needed, try this:
SELECT a.id, a.lname, a.fname, count(b.id)
FROM people a LEFT JOIN people b ON a.lname = b.lname AND a.fname =
b.fname
GROUP BY a.id, a.lname, a.fname
HAVING count(b.id) 1;
I haven't tested this, but I think it ought to work OK.
Bruce Feist
as the one from
'a'. And, the HAVING clause allows us to isolate scores in 'a' which
are second-highest using that information; we then compute the average
score that's at least as high as the second-highest value.
Bruce Feist
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
hello
Please excuse the 'baby' question :) I have a 'digital dataset' of the
streets and
suburbs of my area (ESRI shape format). I used 'shp2mysql.pl' (from mapserv)
to import
the maps/layers into mysql, this worked fine EXCEPT for all the street
maps...perhaps
because they're vector line data as
Richard Bolen wrote:
This gives the count per job which is always 1.
Oops! Quite right. I don't see a way to get the total off-hand.
Bruce
-Original Message-
From: Bruce Feist [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 7:42 PM
To: Richard Bolen
Cc: [EMAIL PROTECTED
Submissions s ON j.jobid = s.jobid
GROUP BY /* all selected columns */
HAVING min(abs(s.status - 1)) 0
I leave it as an exercise to the reader to figure out why this works (if
it does -- I haven't tested it!). If status = 1 is the lowest possible
value for status, you can simplify this a bit.
Bruce
Richard Bolen wrote:
This works! I was then wondering how to get the total number of all
jobs that this condition is true for?
Just include count(distinct j.jobid) in the SELECT list.
Bruce
select j.*
FROM Jobs j LEFT JOIN Submissions s ON j.jobid = s.jobid GROUP BY /*
all selected columns
' and just
specifying the first letter won't work. Or, if you're worried about
trailing z's or other high characters, try name = 'a' and name 'c'.
Bruce Feist
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
a DBMS. Features, stability, security, and so on can be
just as important or more so. No single DBMS is going to win all the
prizes; the trick is to find the one with the right balance.
Bruce Feist
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
. Thanks for any
assistance!
Regards,
Bruce
[EMAIL PROTECTED]
(925) 866-2790
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
/information that might help!!!
Regards,
Bruce
[EMAIL PROTECTED]
(925) 866-2790
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
)10 GROUP BY schedule_id ;
My problem is that I would need to use the count function actually within the
WHERE (clause which is not allowed).
That's precisely why HAVING exists.
SELECT schedule_id,count(schedule_id)
FROM attendance
HAVING count(schedule_id) 10
GROUP BY schedule_id ;
Bruce
in the result.
Try:
SELECT *
FROM (history h LEFT JOIN members m ON h.member_id = m.id) LEFT JOIN
activity a ON h.activity = a.id
WHERE h.date = whatever.;
Bruce Feist
create table members (
id unsigned int autoincrement,
name
)
create table activity (
id unsigned int
it
takes for a full-table scan? Minimal impact on other processes running?
(OK, it can't be this one since it's a dedicated server.) Minimal time
required to restart after a catastrophic failure?
Bruce Feist
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
customization that way. This is
probably similar to what you were describing in your second scenario;
I'm not sure, because I don't know what an 'account relationship' is.
Bruce Feist
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
in for that session, for instance, the
first? If so, try:
SELECT sessionID, userID, min(date), min(time)
FROM sti_tracking
WHERE userID = 999
GROUP BY userI, sessionID
Even if I misunderstood, you can probably adapt this into what you
really want.
Bruce Feist
--
MySQL General Mailing List
For list
Tim Winters wrote:
So what I want to be able to do is single out a user (999) and retrieve
all the sessions he was involved in. But I don't want duplicate session
numbers (one is enough).
Make any more sense?
Yes. The solution I posted earlier should work.
Bruce Feist
--
MySQL General
to be sure.
Bruce Feist
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
this :)
You're welcome. Good luck with it.
Bruce Feist
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
otherguy wrote:
That gets me halfway there
Does it? In your original question, you'd indicated that you only
wanted zips where *both* criteria were met -- enough CIRGs and enough
CILTs. By using a UNION, you'll be getting zips where *either* is met.
Bruce Feist
--
MySQL General Mailing
removing the LIMIT. (The
LIMIT is correct if you want a single row but don't care which one it
is, but from your elaboration that is not the case.)
Bruce Feist
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
query against it, summarizing by accountno, and then
drop the temporary table.
Bruce Feist
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
that there are more political views that you'd like to
track in the future.
However... aren't you worried that a 'politics' table is likely to be
corrupt? g
Bruce Feist
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Bruce Feist wrote:
One
--possibility would be to break the values out into multiple columns,
one
--for each view, and have indexes on each of those columns, or at least
--the views that you consider most important. It might help to make
them
--compound indexes, with each including several views
|
+++-++
|BHE | R2 | local50
|
|BHE | R2 | local 12
|
+++-++
It looks to me like a data problem, where some rows have leading tabs or
spaces before R2 in the prot column and others don't.
Bruce Feist
--
MySQL General Mailing
that it allows and requires the ON clause.
It is also supported by standard SQL usage in other RDBMSs.
Bruce Feist
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
. To illustrate the possible problem, run
the above query on the following data:
dt_tm stocksku qty
dt1 A BB 1
dt1 ABB 2
Jake's query will return a single row instead of two rows. (Sorry,
Jake, I don't mean to put you on the spot!)
Bruce Feist
I have
Jake Johnson wrote:
Nice approach Bruce, but I too won't have any problems with your
case because I am grouping by sku and stock in the sub-query.
You're right; you do avoid the problem with the specific sample data I
gave you. Sorry about that! But, there are still potential problems
because
.
In other words, the trade-off is in simplicity of database design (use
the existing fields) versus simplicity and efficiency in doing
single-row look-ups. The latter is only significant if you expect to be
retrieving the row on its own.
Bruce Feist
--
MySQL General Mailing List
For list archives
and start this slave as it's not in live production, I can't stop
and start the master which feeds live discussion boards.
Any ideas?
Best Regards, Bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm having a problem with some very slow queries that spend a very long
time in the 'Sorting result' state and I'm wondering how sorts are
implemented in mysql and what I can do to optimize these types of queries.
The query looks something like this:
SELECT col1,col2,col3 from table1 where
to the following query
with a NOT EXISTS subquery?
10) Match the following filenames to their corresponding table structures.
And so on. Heck, the commonly asked questions on this list would make a
pretty good test!
Bruce Feist
(retired database instructor / courseware designer)
--
MySQL
bucking the trend of
constantly bucking the trend? I think there's such a thing as being
*too* progressive! g
Bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
and useful.
I have to agree that most certification tests are a brain-dump,
I don't think it has to be that way.
Bruce Feist
(retired database instructor / courseware designer)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
points out, the people that I see complaining
about the lack of skill testing are obviously long-time users very
proficient in MySQL,
Heh. I'm a MySQL newbie. (But I have twenty years of experience with
RDBMSs g).
Excellent discussion, by the way.
Bruce Feist
(retired database instructor
Peter Brawley wrote:
MySQL, like other relational databases, does not support arrays or
pointers.
Of course, relational databases don't allow duplicate rows in table,
either... g I have yet to find a relational database with that feature!
Bruce Feist
--
MySQL General Mailing List
Peter Brawley wrote:
Peter Brawley wrote:
MySQL, like other relational databases, does not support arrays or
pointers.
I didn't write that.
My apologies -- it was written by John Griffin, not Peter Brawley. I
edited carelessly.
Oops.
Bruce Feist
--
MySQL General Mailing
-column index. If you
know the surname, you can still find the author quickly. If you know
only the given name, you cannot.
Bruce Feist
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Heikki Tuuri wrote:
InnoDB is totally C, MySQL half C++ and half C, with a few hundred lines of
x86 Assembler.
Oh? I thought that MySQL ran on Mac OSX as well as various Intel platforms.
Bruce Feist
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
and sales2 should really be a single 'sales'
table with an extra column indicating which month the sales are for (and
maybe one for year as well), but I don't have enough information to be sure.
Bruce Feist
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Patrick Shoaf wrote:
At 09:48 AM 6/4/2003, Bruce Feist wrote:
I suspect that sales1 and sales2 should really be a single 'sales'
table with an extra column indicating which month the sales are for (and
maybe one for year as well), but I don't have enough information to
be sure.
Table sales1
and $longitude separately, and AND them into your WHERE. My
trig is too rusty to do this, unfortunately. Anyway, if latitude and
longitude are indexed (or at least one or the other), doing so ought to
allow the optimizer to narrow down the places which must be scanned
dramatically.
Bruce Feist
='Arihant Jain' and City='Delhi' AND Userid = 1 AND
Qualifyflag IN (1, 2)
UNION
Select CompanyName,City from Company c INNER JOIN accountsorder a ON
c.Companyid = a.Companyid
where CompanyName='Arihant Jain' and City='Delhi' AND Userid = 1
Bruce Feist
--
MySQL General Mailing List
For list archives
above, but it also has corresponding advantages. Leaving out a
feature that was specified in a standard 11 years ago doesn't fall into
this category, though!
Bruce Feist
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
heard of one RDBMS whose name
begins with O and ends in E and has the letters R, A, C, and L int he
middle, which does it this way. Other RDBMS's, such as OpenIngres (the
one I'm personally most familiar with) distinguish between the two, as
MySQL does.
But I certainly understand his confusion!
Bruce
, it still should be unique, and then
increment itself... No?
Not all unique identifiers are computer-generated. If you leave off
AUTO_INCREMENT but still make it a primary key, uniqueness will be
enforced on whatever the application(s) enter(s) as the value, but
nothing will be plugged in.
Bruce
by the user.
Matt Gostick's proposed solution:
Well... if you were given a start date of 2003-01-01 and end date of
2003-01-31...
select *
from table_name
where start_date between 2003-01-01 and 2003-01-31
or end_date between 2003-01-01 and 2003-01-31
Bruce Feist's response
Bruce Feist wrote:
Instead, if the four dates are s1, e1, s2, and e2 (s=start, e=end), we
want:
s1 = e2 /* first range can't start after second range ends */
AND
s2 = e1 /* second range can't start after first range ends */
Bruce Feist also wrote:
Your original suggestion works
, s.solution
FROM os_table o, solution_table s
WHERE (o.os_id s.os_code) = @desired_id;
Why not combine them into a single intriguing non-equijoin?
SELECT *
FROM os_table o, solution_table s
WHERE (o.os_id s.os_code) = o.os_id AND o.os_name = win nt;
Bruce Feist
--
MySQL General Mailing List
-02-01.
Instead, if the four dates are s1, e1, s2, and e2 (s=start, e=end), we want:
s1 = e2 /* first range can't start after second range ends */
AND
s2 = e1 /* second range can't start after first range ends */
Bruce Feist
Matt.
On Wed, 2003-04-02 at 16:32, Sarah Heffron wrote:
How would I do
suggest that you index
on that combination.
Indexing files on the combination of lang_id and directory_id might
help as well.
Bruce Feist
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
case a join
would be needed. (It would not, however, be quite the join shown
below... one query would find the rows with duplicates and yield a
temporary table, and then the second would join that table back to the
original to find the details.
Bruce Feist
-Original Message-
You
like date(), getdate() etc. on it.
This is probably the technique I'll use.
What do you mean by php date?
I mean I am a confused newbie and for some reason I think that PHP has
a date primitive type. Thanks to you and others, I am now straightened
out g.
Bruce Feist
--
MySQL General
AND
contestEntries.ContestNumber = 1
where contestEntries.entrant is null
Bruce Feist
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
15') ) LIMIT 0, 50;
It looks to me as though your use of the UNIX_TIMESTAMP function is
preventing any indexes that you might have from being used. I suggest
that you phrase your queries without them, and index on timestamp if you
haven't already.
Bruce Feist
--
MySQL General
to request the date in a
specific form (ideally one taken from operating system preferences).
Thanks!
Bruce Feist
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
*
FROM tbl_reports r LEFT JOIN tbl_personnel p1 ON r.person1 = p1.per_id
LEFT JOIN tbl_personnel p2 ON
r.person2 = p2.per_id
;
If you need more reasons that denormalized tables are usually not a good
idea, just ask.
Bruce Feist
Charles Kline wrote:
tbl_reports has
alx wrote:
On Fri, 2003-03-28 at 01:39, Bruce Feist wrote:
Usually it's best to work with normalized tables, which would make this
trivial. tbl_reports isn't normalized, since it has a simulated array
of persons in it. Could it be split into two tables:
i'm interested on how
) as sCode FROM tblORI
Any hints would be appreciated.
MySql uses '+' only for numeric addition. For string concatenation, try
the CONCAT function.
Your values are being converted to integers, and become 0, for the
expression you were using.
Bruce
--
MySQL General Mailing List
For list
.
SELECT *
FROM info i LEFT JOIN codes c ON i.IDNum = c.info_IDNum
WHERE c.code IS NULL;
Bruce Feist
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
it to allow NULLs for dra4.id or
dra3.id and dra4.id or dra2.id, dra3.id, and dra4.id, or all four of
them. Like I said, *ugly*.
Bruce Feist
Here is the setup. 3 tables. tbl_personnel, tbl_personnel_dras, tbl_dra
each person in the tbl_personnel table can have 0 - 3 records in the
tbl_personnel_dras
. Is the best way to do this to create
a new table and call it reference_city with items.ItemID and city.CityID as the
columns?
Yes, although I'd probably call it item_city to make it more obvious
what it is.
Bruce Feist
PS If you specify sql,query,queries, or smallint in a message to this
mailing list
a significant amount of data already
entered, you might want to copy the cityid/itemid information from items
into item_city first.
Bruce Feist
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
names.
A lesson to be learnt indeed.
Everything is g.
Bruce
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
ALL
Select * from Temp T WHERE T.Amount 500;
Warning -- my main expertise is with other RDBMSs, and this syntax might
be incorrect for MySql.
Bruce Feist
-
Before posting, please check:
http://www.mysql.com/manual.php
enough to
realize that the order of the conditions is irrelevant. I assume that
this is true of MySql. But, I'm a newcomer to MySql, and I could be wrong.
Bruce Feist
-
Before posting, please check:
http://www.mysql.com
My first recommendation is to switch to ADO. It is much faster.
Bruce Lewis
- Original Message -
From: Thomas Bein [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, March 16, 2003 12:55 PM
Subject: VB6 ODBC Memory problems
Hello,
I have been developing an application in VB60
Peter Brawley wrote:
Absent a list for MySQL-centred products their support, I appreciate
occasional product book announcements.
I agree.
Bruce Feist
-
Before posting, please check:
http://www.mysql.com/manual.php
being still must figure
out what the most effective distribution strategy is.
MySQL is a fine RDBMS; it simply does not implement distribution in its
engine. By claiming that it does, you do a disservice to other RDBMSs
which *do*, and to people looking for such a solution.
Bruce Feist
machine. The DBMS should keep track of which table is
in which database on which computer, and its optimizer should be capable
of figuring out an efficient way of resolving such queries.
Can MySQL do that?
Bruce Feist
- Original Message -
From: james [EMAIL PROTECTED]
Sent: Thursday, March
ON IPPL.listID = PLI.listID
INNER JOIN products P ON PLI.prodID = P.prodID
WHERE PL.validFrom CURRENT_DATE AND PL.validTo CURRENT_DATE
AND P.catID = x AND PE.perID = y
;
Also, I suspect that you wanted = and = in your date comparisons
above.
Bruce Feist
PS: Did you know that if you
management system.
Bruce Feist
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e
is, but this is basically true.)
I won't explain it further now... if you have more questions after
reading, ask away and we'll be glad to help!
Bruce Feist
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
(specifically, if there's any compression or
variable-length rows involved), the update can cause a row to be moved
to elsewhere in its file, much like a delete/insert combination, which
could leave data physically present although logically inaccessible
through the DBMS.
Bruce Feist
(a few
hundred rows in each of about 8 tables), there's a lot of joining going on.
Better ideas are welcome.
Thanks!
Bruce Feist
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
:
SELECT t1.t1id
FROM t1 LEFT JOIN t2 ON t1.t1id = t2.t2id
GROUP BY t1.t1id
HAVING min(abs(t2.t2gid - 192)) 0 OR min(t2.t2gid) IS NULL;
I haven't tested this, but I believe that it will work.
Bruce Feist
The example is actually given in the MySQL manual itself (section
1.7.4.1).
I am trying
subqueries. Instead use a temporary table or a join.
SELECT distinct tbl1.* from tbl1 INNER JOIN tbl2 ON tbl1.coln1 = tbl2.coln2;
should give the same results as your query if there aren't any
duplicates in tbl1.
Bruce Feist
the value 1 to the search script, not Math.
OK, good. That would be more efficient, even if my way *had* worked.
Thanks again Bruce, my favourite type of help, a pointer but allow me
to learn why it works :-)
I'm glad you liked it! It was an interesting question.
Best of all, I think I'm a little
-subquery and
remember the result
2) Evaluate and apply WHERE clause to table f2.
3) Since there is no more summarization to be done, treat the HAVING as
a WHERE clause, and evaluate and apply it to the individual rows, using
result remembered from (1).
And those are the conclusions I draw.
Bruce
and let me know if it works!
Bruce Feist
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED
Egor Egorov wrote:
On Wednesday 05 March 2003 19:34, Bruce Feist wrote:
I'm having trouble getting MySQL running on a RedHat Linux 7.1 machine.
The log file complains that host.MYD is missing; I don't see mention
of this file in the documentation, and it's not on my computer anywhere.
Did
assume it'll take more than a 'touch'!
Bruce Feist
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
'
ought to do the trick for you.
Bruce Feist, also born in 58
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
reader. Other than that, I agree.
Bruce Feist
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED
. An alternative would be to select max(f.totPrice)
and max(f.saleCount) instead.
Bruce Feist
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
overhead -- you're already scanning all the table2 rows because of your
GROUP BY. Or, are you talking about multiple SELECT statements?
Bruce Feist
-
Before posting, please check:
http://www.mysql.com/manual.php
401 - 500 of 586 matches
Mail list logo