I wrote:
Maybe something like this?
SELECT Data1
FROM table_name
WHERE Data3 = 1
GROUP BY Data1
HAVING SUM(Data2 = 141) = 0;
Actually that doesn't make sense. I was thinking of the case where
there's a left join involved. In your case, it should just be this:
SELECT
that
contains a Data1 value of 3, but I do not require that result because it's original
group contains 141
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 19, 2002 11:58 AM
To: Luc Foisy
Cc: MYSQL-List (E-mail)
Subject: Re: Query Question
Because I don't know what Data1 is, thats the result I want to find
-Original Message-
From: Mary Stickney [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 19, 2002 12:10 PM
To: Luc Foisy; MYSQL-List (E-mail)
Subject: RE: Query Question
Why cant you filter on Data1?
I meant
]
[EMAIL PROTECTED]
- Original Message -
From: Luc Foisy [EMAIL PROTECTED]
To: MYSQL-List (E-mail) [EMAIL PROTECTED]
Sent: Monday, August 19, 2002 6:32 PM
Subject: Query Question
Some ficticious data
ID Data1 Data2 Data3
1 1 141 1
2 5 140 1
3 4 142 1
4 3 141 1
5 2 142 1
6 5
I wrote:
Actually that doesn't make sense. I was thinking of the case where
there's a left join involved. In your case, it should just be this:
SELECT DISTINCT Data1
FROM table_name
WHERE Data3 = 1 AND Data2 141;
Ignore that correction. It seems that what you want is indeed
Yes that's it, Thanks!
Ignore that correction. It seems that what you want is indeed this:
SELECT Data1
FROM table_name
WHERE Data3 = 1
GROUP BY Data1
HAVING SUM(Data2 = 141) = 0;
[Filter fodder: SQL]
Luc
Pada Sat, 27 Jul 2002 21:32:48 -0500
Paul Maine [EMAIL PROTECTED] menulis :
$string =1972 Ford Mustang
Using the following SQL statement:
SELECT * FROM whatevertable WHERE whatevercolumn LIKE '%$search%
I want to return all records that have Mustang AND 1972 AND Ford.
my suggestion :
]
To: MySQL MySQL [EMAIL PROTECTED]
Sent: Saturday, July 27, 2002 10:32 PM
Subject: PHP/MySQL Search Engine Query Question
I am currently working on a website that is implemented using PHP and
MySQL.
The site currently has a simple search engine that allows a shopper to
type
in a search string
I am currently working on a website that is implemented using PHP and MySQL.
The site currently has a simple search engine that allows a shopper to type
in a search string that is stored in $search. For example, if a shopper
types in 1972 Ford Mustang
$string =1972 Ford Mustang
Using the
Hello all,
I am trying to build a relatively complex query to get the average and
standard deviation of various testing variables which ultimately will be
filtered/grouped by age and other parameters.
Item #1 shows the original query and output:
select count(Test1000.OID) as N,
avg(Accuracy)
Hello all,
I am trying to build a relatively complex query to get the average and
standard deviation of various testing variables which ultimately will be
filtered/grouped by age and other parameters.
Item #1 shows the original query and output:
select count(Test1000.OID) as N,
avg(Accuracy)
CIO
* http://www.calevans.com
*
-Original Message-
From: Chris Griffin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 9:08 PM
To: [EMAIL PROTECTED]
Subject: SQL design/query question
If this is not the right list for this please direct me to the proper
list.
I have
If this is not the right list for this please direct me to the proper
list.
I have a table of name/address information. I need to keep track of a
weekly event and if they participated or not. I thought I could have a
table of dates and people record ids with just those that participated.
The
You need a LEFT JOIN. Read about it here:
http://www.w3schools.com/sql/sql_join.asp
Go down to the LEFT JOIN section.
HTH,
Jed
I liked it when Chris Griffin wrote this to me:
If this is not the right list for this please direct me to the proper
list.
I have a table of name/address
* http://www.calevans.com
*
-Original Message-
From: Chris Griffin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 9:08 PM
To: [EMAIL PROTECTED]
Subject: SQL design/query question
If this is not the right list for this please direct me to the proper
list.
I have a table of name
I do not understand string comparison. Why doesn't the
following work:
SELECT id, songname FROM songs WHERE songname = Empire;
All I get is: Empty set (0.00 sec)
I know the string exists in the database:
In record 135 exists:
Empire |
| 135 |
Do I have
]
To: [EMAIL PROTECTED]
Sent: Sunday, June 23, 2002 2:27 PM
Subject: Strings query question
I do not understand string comparison. Why doesn't the
following work:
SELECT id, songname FROM songs WHERE songname = Empire;
All I get is: Empty set (0.00 sec)
I know the string exists
* [EMAIL PROTECTED]
Thanks, that worked for song named Empire, however,
when I checked other song names such as songname
called One I get two results:
| id | songname |
+++
| 35 |
You're Still The One |
| 57 |
One |
: Strings query question
Thanks, that worked for song named Empire, however,
when I checked other song names such as songname
called One I get two results:
| id | songname |
+++
| 35 |
You're Still The One |
| 57 |
One
I am trying to execute the following mysql query in a perl script...
my $sth = $dbh-prepare(select * from servers);
$sth-execute();
my @row;
while ( @row = $sth-fetchrow_arrayref())
{
foreach $row(@row)
{
push @SelectedArray, $row\n\n;
}
}
print @SelectedArray;
And I am getting the
Maybe you should say
WHERE category LIKE 'Gambling'
- Original Message -
From: Jeff Field [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 12, 2002 11:42 AM
Subject: ENUM query question
I have a quick question regarding queries that involve values in ENUM
columns
At 12:42 -0500 6/12/02, Jeff Field wrote:
I have a quick question regarding queries that involve values in ENUM
columns. Here's the scenario:
I have an ENUM column (category) that can have the values ('Gambling',
'Geographic', 'Medical', 'Sports'). Most of the records have only one of
the
Yes! My apologies; didn't have my coffee this morning. The column is of
type SET.
Jeff
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 12:50 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: ENUM query question
At 12:42
This query seems to be quite easy, but I still cannot figure
out how to do it.
I have a randomly ordered table. And I want to SELECT that table
by ORDERing it in specific row, and when I'm done I want to
find out numeric position of a raw where the first raw is 1, second is 2
etc.
Of course
I have been battling with a complex query that us giving me a tremendous
headache..
I have a MASTER table with 7 other tables (I can not change the database)
The master table contains values (Key's) which I then need to lookup in
another table that has 2 fields, the Key and a Description field.
I'm having a problem in a query that I'm trying to do.
I have a database of tickets and I want to get the average numbers of
tickets created per agent per hour over a date range in the format:
Hour | Avg per agent
This is what I have so far:
SELECT HOUR(created) AS hourcreated, COUNT(*) AS
PROTECTED]]
Sent: Friday, May 17, 2002 11:52 AM
To: [EMAIL PROTECTED]
Subject: Query question average per hour per agent
I'm having a problem in a query that I'm trying to do.
I have a database of tickets and I want to get the average numbers of
tickets created per agent per hour over a date range
[snip]
I have a database of tickets and I want to get the average numbers of
tickets created per agent per hour over a date range in the format:
Hour | Avg per agent
This is what I have so far:
SELECT HOUR(created) AS hourcreated, COUNT(*) AS sum-per-hour
FROM remedy
WHERE (created='2002-4-25'
How can I delete from a table the results of a join query..
I.e, join two tables together, get the resutls, now want to delete that data from one
of the tables...
Do I have to create a tempory table, hold the data, and delete from the one table data
matching in the temp table,
or can I just
Sorry,
I've been too long in a list where you just answer the questioner and
then the questioner writes a summary of the answers to the list.
Sabine
Sabine Richter wrote:
Hello Taylor,
as far as I see from the documentation and own trials you can just
delete from table where
select id, shortdescription, title from reviews where title REGEXP
'^[0-9#$].*' ORDER BY title ASC
-Original Message-
From: Jay Paulson [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 6:32 PM
To: [EMAIL PROTECTED]
Subject: easy query question
I want to do a query that will find
I want to do a query that will find all the titles I have in my db that
start with numbers and ambigious characters (i.e. 0-9, , #, $ etc...). My
query is below, however I don't know what to change the a too in order for
it to return what I just described.
select id, shortdescription, title
I have a simple search form that allows the user to search a contact db
based on criteria that they choose.
Search by -
first name - text box
last name - text box
region - drop down
loan officer - drop down
I want the user to be able to receive results if they choose all possible
criteria or
PROTECTED]
tel. 0121-242-1473
---
-Original Message-
From: Mark Stringham [mailto:[EMAIL PROTECTED]]
Sent: 28 March 2002 17:21
To: MySQL
Subject: SQL query question - using LIKE
I have a simple search form that allows the user to search
---
-Original Message-
From: Mark Stringham [mailto:[EMAIL PROTECTED]]
Sent: 28 March 2002 17:21
To: MySQL
Subject: SQL query question - using LIKE
I have a simple search form that allows the user to search a
contact db
based on criteria that they choose
with.
But I am certainly open for more suggestion/ feedback.
Thanks
Mark
-Original Message-
From: DL Neil [EMAIL PROTECTED]
To: Peter Lovatt [EMAIL PROTECTED]; Mark Stringham
[EMAIL PROTECTED]; MySQL [EMAIL PROTECTED]
Date: Thursday, March 28, 2002 11:52 AM
Subject: Re: SQL query question
:16
Subject: Re: SQL query question - using LIKE
DL -
Points well taken -
I am using php and doing simple validation
EX - if ($fname !=) {
add fname string to search variable;
}
And if none of the fields have been filled out I'll return an error
msg.
As you mentioned, Peter's logic
Hope somebody can help me on this one
At present I have two tables in my database. The data in question is built
around credit card transactions.
Tables Structure
Headers Table
ID (Primary Key used by the TRANSACTIONID field in the Transaction table)
HEADERDETAILS blah, blah
Transaction
Edwards,
Friday, February 22, 2002, 12:58:23 PM, you wrote:
Eeoen Hope somebody can help me on this one
Eeoen At present I have two tables in my database. The data in question is built
Eeoen around credit card transactions.
Eeoen Tables Structure
Eeoen Headers Table
Eeoen ID (Primary
| David | 302 |
+-+---+-+---+
-Original Message-
From: Dean Householder [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 2:53 PM
To: Roger Karnouk; [EMAIL PROTECTED]
Subject: Re: basic query question
Okay, so I do this and all I end up
I'm fairly new to MySQL, so if anyone could help me I'd really appreciate
it!
What I'm trying to do is join two pictures in a database to each other. My
database holds info about people with variables:
id, lname, fname, engagedto, pic
The engagedto field contains the id of the person they are
At 19.02.2002 10:22, you wrote:
I'm fairly new to MySQL, so if anyone could help me I'd really appreciate
it!
What I'm trying to do is join two pictures in a database to each other. My
database holds info about people with variables:
id, lname, fname, engagedto, pic
Try this, even if I´m
]
Subject: basic query question
I'm fairly new to MySQL, so if anyone could help me I'd really appreciate
it!
What I'm trying to do is join two pictures in a database to each other. My
database holds info about people with variables:
id, lname, fname, engagedto, pic
The engagedto field contains
PROTECTED]
Subject: Re: basic query question
At 19.02.2002 10:22, you wrote:
I'm fairly new to MySQL, so if anyone could help me I'd really appreciate
it!
What I'm trying to do is join two pictures in a database to each other. My
database holds info about people with variables:
id, lname
PROTECTED]]
Sent: Tuesday, February 19, 2002 12:22 PM
To: [EMAIL PROTECTED]
Subject: basic query question
I'm fairly new to MySQL, so if anyone could help me I'd really appreciate
it!
What I'm trying to do is join two pictures in a database to each other. My
database holds info about people
, 2002 12:17 PM
Subject: RE: basic query question
you will have to join the table with itself
and reference it as if it is two tables.
this might be slow however so you might want to make some
specific indexes to speed it up.
This Query will return all the people who are engaged
and a picture
PROTECTED]]
Sent: Tuesday, February 19, 2002 1:53 PM
To: Roger Karnouk; [EMAIL PROTECTED]
Subject: Re: basic query question
Okay, so I do this and all I end up with is
+-+---+-+---+
| id | lname | fname | engagedto
1:04 PM
Subject: RE: basic query question
You're very close:
mysql select p1.lname, p1.fname, p2.lname as engaged_lname, p2.fname as
engaged_fname from members p1, members p2 where p1.id = p2.engagedto;
but the REAL question is What do you want out of the query?
-Original Message-
From
Hello,
I have a question about a query. We have a guestbook and I want to do some
statistics for the messages in it. So I've created a query that looks like
this.
select hour(msg_date_time), count(*)
from messages
where user_id = 'almar'
group by hour(msg_date_time)
It returns the hour and the
Hello Almar
I have a question about a query. We have a guestbook and I want to do some
statistics for the messages in it. So I've created a query that looks like
this.
select hour(msg_date_time), count(*)
from messages
where user_id = 'almar'
group by hour(msg_date_time)
It returns the
* DL Neil
Consider:
a) add a 'construction' table with the row-values 0 through 11
(or 23) and use it to do a left join against the
messages tbl;
b) if the database is not busy, use perl to fire off 12 (or 24)
separate queries.
c) use perl to 'fill in the holes', putting zero values in the
Hello,
I have a question about a query. We have a guestbook and I want to do some
statistics for the messages in it. So I've created a query that looks like
this.
select hour(msg_date_time), count(*)
from messages
where user_id = 'almar'
group by hour(msg_date_time)
It returns the hour and the
Hello Almar
I have a question about a query. We have a guestbook and I want to do some
statistics for the messages in it. So I've created a query that looks like
this.
select hour(msg_date_time), count(*)
from messages
where user_id = 'almar'
group by hour(msg_date_time)
It returns the
* DL Neil
Consider:
a) add a 'construction' table with the row-values 0 through 11
(or 23) and use it to do a left join against the
messages tbl;
b) if the database is not busy, use perl to fire off 12 (or 24)
separate queries.
c) use perl to 'fill in the holes', putting zero values in the
I am trying to validate a user in a login form.
There are 3 things that must be true.
User login name = email_login (from User table)
User password = password (from User Table)
User must be active: activeuser (from Owner table) = 'Y'
I don't know why I'm having so much difficulty with this SQL
I am trying to validate a user in a login form.
There are 3 things that must be true.
User login name = email_login (from User table)
User password = password (from User Table)
User must be active: activeuser (from Owner table) = 'Y'
The Owner table does have a common field with the User
I don't get the question..
you just have to compare the values out from the database with the
values from the user input.
my $sth = $dbh-prepare(SELECT usremail, usrStatus from users where
usrName = ?);
$sth-execute(param{'name'});
my ($email,$status) = ($sth-fetchrow_array);
print invalid
[mailto:[EMAIL PROTECTED]]
Sent: Friday, December 07, 2001 3:27 PM
To: MySQL (E-mail)
Subject: Query question
I am trying to validate a user in a login form.
There are 3 things that must be true.
User login name = email_login (from User table)
User password = password (from User Table)
User must
: RE: Query question
Try this...
$result=mysql_db_query(database_name, Select * from table_name where
email_login like 'name' and password like 'password';);
$numrows=mysql_affected_rows();
$data = mysql_fetch_array($result);
if(($numrows=1)($data[activeuser]=='Y')){
login_script
Thanks for all your suggestions, I apparently had a brain cramp.
Problem solved.
Thanks,
Steve
- Original Message -
From: Steve Osborne [EMAIL PROTECTED]
To: MySQL (E-mail) [EMAIL PROTECTED]
Sent: Friday, December 07, 2001 1:36 PM
Subject: Query Question Additional Info
I am trying
Does anyone know how to write a query to get out the sum of a whole
table column?
SELECT sum(column) FROM table {WHERE where-clause};
Also see the manual.
:wq!
Ralph
-
Before posting, please check:
Does anyone know how to write a query to get out the sum of a whole
table
column?
ex. I'm playing around with a database where customers can buy stuff.
I have a table where I save all the invoices, but now I want to write
a query that sums upp all the prices in the price column in that
table.
As a side note, be sure that you do not use a float for any columns that deal
with money or you will get rounding errors.
--Bill
mysql
Yen-Chu Chen wrote:
Hi,
Assume the name of the column is 'price' and the name of the table is
'table', you could use
SELECT SUM(price) FROM
Hi,
Assume the name of the column is 'price' and the name of the table is
'table', you could use
SELECT SUM(price) FROM table;
On Wed, 26 Sep 2001, Micke wrote:
Does anyone know how to write a query to get out the sum of a whole
table
column?
ex. I'm playing around with a
Not quite. We're not looking for a left join or natural left join.
I'm not sure MySQL or any database can even do this, it may have to be
done (rather unattractively) on the API side.
The data in the two tables aren't tied by ID, and shouldn't mix w/ each
other at all.
To do this, all we've
Ok, we just can't seem to find a solution for this problem. Thought I'd
post it up to see if anyone has any input.
Say you have 2 tables project_notes and daily_notes.
Each table has a timestamp, and a user_id.
Is there any way, in one query, to select all messages from both tables
that were
Sounds like a left join, maybe even a natural join, which I haven't tried yet.
select message
from project left join daily on project.uid = daily.uid
order by timestamp
Check manual for syntax.
Or am I missing something?
- Ken
[EMAIL PROTECTED]
At 05:47 PM 9/6/01 -0700, Michael Garvin wrote:
I'm doing a query like:
select Title from inv where Title LIKE '%TOMMY%' OR Content LIKE
'%TOMMY%' OR Notes LIKE '%TOMMY%' order by Title
What I need is to have the results that match Title LIKE '%TOMMY%' to
appear first and then the rest. I have been doing 2 separate queries and
filtering
hi.
select Title, IF(Title LIKE %TOMMY%, 1, 0) as check
from inv where...
... order by check desc;
hth.
-ravi.
-Original Message-
From: Carl Schrader [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 04, 2001 10:30 AM
To: [EMAIL PROTECTED]
Subject: Query Question
I'm doing a query
.
select Title, IF(Title LIKE %TOMMY%, 1, 0) as check
from inv where...
... order by check desc;
hth.
-ravi.
-Original Message-
From: Carl Schrader [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 04, 2001 10:30 AM
To: [EMAIL PROTECTED]
Subject: Query Question
I'm doing a query
.
-Original Message-
From: Carl Schrader [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 04, 2001 12:13 PM
To: Ravi Raman
Cc: [EMAIL PROTECTED]
Subject: Re: Query Question
Close. Now I need to get the order correct. I need the order like
Tommy
Tommy Lee
Baseball(matched with Tommy
MYSQL DATABASE BLA BLA BLA (I really hate that filter)
Ravi Raman writes:
if i'm understanding what you mean, it seems like you're getting a little
too complicated.
select Title, IF(Title LIKE %TOMMY%, 1, 0) as check
from inv where...
... order by check desc, Title
Even simpler
This question involves table setup questions as much as it involves a
query question. Bare with me, this seems hard to explain.
I have a table that includes records with 3 (relevant to this
conversation) fields (actually 9..more on that later). Each of those
fields have 2 other related fields
Carl Schrader wrote:
Field Special 1 has a related field with a Start Date and another field
for End date.
Field Special 2 has a related field with a Start Date and another field
for End date.
Field Special 3 has a related field with a Start Date and another field
for End date.
IMNSHO,
[EMAIL PROTECTED] writes:
[SNIP]
Isn't it annoying when it refuses to send your mails to the list
and then lets through a ton of spam? Mysql mysql mysql. There. :-E
Carl Schrader writes:
select Title from inv where Title LIKE '%TOMMY%' OR Content LIKE
'%TOMMY%' OR Notes LIKE '%TOMMY%'
I'm doing a query like:
select Title from inv where Title LIKE '%TOMMY%' OR Content LIKE
'%TOMMY%' OR Notes LIKE '%TOMMY%' order by Title
What I need is to have the results that match Title LIKE '%TOMMY%' to
appear first and then the rest. I have been doing 2 separate queries and
filtering
sql optimize
Please help me. I can't understand why i've got this
results.I have very simple table with name cz
Field TypeNullKey Default Extra Privileges
tv int(11) MUL 0 select,insert,update,references
rez_id int(11)
hai
In mysql it can be done but do anyone know how to join table in DBASE?
The situation :-
table 1
-
EM_id
EM_gender
table 2
-
EN_id
EN_name
The question is how to select all field from table1 and EN_name from table2 at
one query? .The EM_id and EN_id is same.Is
Hi,
Can any of you query experts tell me if this is possible in a query?
I have 3 tables, categories, products, groups.
Groups table consists of categoryid and productid, it just keeps track of which
categories have which products.
I need a query(if possible) that would basically say:
Select
Hi, I am having a small formatting problem maybe someone can help with.
I have a query that does a left outer join, which generates a table with a
few NULL values in some columns. All okay so far. But what I need to do is
sort on this column, and I need to put NULL values at the end. Normally
query question
Hi, I am having a small formatting problem maybe someone can help with.
I have a query that does a left outer join, which generates a table with a
few NULL values in some columns. All okay so far. But what I need to do is
sort on this column, and I need to put NULL values
I have a table where patient visits are logged each visit, the table is:
patientnumber,visitdate,location
I need to select and count the number of records that have 2 or more entries
with the same patientnumber
in sql-english:
select count(*) where there are two or more records with the same
Hi,
Since you have over 10,000 member ids it depends on
the exact appln that you have.
If the length of the SQL query increases above a
certain length (i am not sure abt the exact figure),
an error is thrown saying query too complex.
such wont be the case in your former method.
but,
if there
Hello everyone. I am new to this list and hope it's the right one for
my question. This may be really obvious, but I can't seem to figure it
out...so here's the problem:
I have a table that stores network incident report information, IP
address, dates, type of incident, report name, etc. I am
You are doing a text compare, and they have to match exactly,
including leading zeros after the dots.
You might look at storing them as integers. MySQL has to functions
INET_ATON() and INET_NTOA() to convert them back and forth to strings.
Erica B. Tanner wrote:
Hello everyone. I am new to
I have a table which contains a date column and an order_number column. I
need to formulate a query syntax to return the total number of orders for
each day in a given month (if any). Can someone help me with the syntax
please as I've been stumbling around with it all day without success.
Many
Thanks to all for the suggestions!!
Turns out, if I use a regular expression instead of a text compare I get the desired
result!! :)
Thanks!
Erica
Gerald Clark wrote:
You are doing a text compare, and they have to match exactly,
including leading zeros after the dots.
You might look at
where MONTH(date) = 4
to limit the rows to all days in april, for example.
hth.
-ravi.
-Original Message-
From: Graham Nichols [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 11:23 AM
To: [EMAIL PROTECTED]
Subject: Newbie group/count query question
I have a table which
On Tue, 1 May 2001, Graham Nichols wrote:
I have a table which contains a date column and an order_number column. I
need to formulate a query syntax to return the total number of orders for
each day in a given month (if any). Can someone help me with the syntax
please as I've been stumbling
I have a members table which stores, among other things, a Member ID and a
Points field. We get reports sent to us in a CSV format, with a list of all
Members signing up for a certain offer. Basically, what I need to do, is
create a query like this:
UPDATE members SET points = points +
Hi there,
So a question
I have two tables. And i want to... (i just show you)
Table 1.
OwnerChar(30)Uniqe
FileChar(80)
OIDint(not in use yet)
Table 2.
IDintuniqe and so on
OwnerChar
NameChar
adress
It's not possible to do in one step in MySQL.
--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/
"roger westin" [EMAIL PROTECTED] wrote:
So a question
I have two tables. And i want to... (i just show you)
Table 1.
OwnerChar(30)Uniqe
File
I have a query question I can't figure out on my own. Any help is
appreciated...
I have three tables:
create table courses (
rec_num int(5) not null default '0' auto_increment,
name varchar(255),
description varchar(255),
class_time varchar(255),
professor_id int(5
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Excuse the wrapping..
Any ideas on how to speed this up?
takes 10 secs on a p2 300.
If i could get the second table to not scan all 132,775 rows, it
would be great. I have indexes in it:
mysql show keys from suppliersiclink;
401 - 494 of 494 matches
Mail list logo