I don't know you table structure but something like this would do it...
SELECT * from QB as tbl1
JOIN relAB as tbl2
ON tbl2.A=tbl1.A
where tbl2.a='a1'
Butch Bean
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 09, 2002 7:24 AM
To: [EMAIL
'
SELECT * from QB as tbl1
LEFT JOIN relAB as tbl2
ON tbl2.B=tbl1.ref
where tbl2.B='a1'
-Original Message-
From: Nuno Teixeira [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 09, 2002 11:18 AM
To: Butch Bean
Cc: [EMAIL PROTECTED]
Subject: Re: is possible 1 query with 2
'
|
| SELECT * from QB as tbl1
| LEFT JOIN relAB as tbl2
| ON tbl2.B=tbl1.ref
| where tbl2.A='a1'
-Original Message-
From: Nuno Teixeira [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 09, 2002 12:45 PM
To: Butch Bean
Cc: [EMAIL PROTECTED]
Subject: Re: is possible 1
Use SELECT * FROM Table1 WHERE BINARY name LIKE K%
It will probably slow the search...
You can also define the table a BINARY but 'Most' will be different than
'most'
Butch Bean
-Original Message-
From: savaidis [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 09, 2002 3:07 AM
I don't know you table structure but something like this would do it...
SELECT * from QB as tbl1
JOIN relAB as tbl2
ON tbl2.A=tbl1.A
where tbl2.a='a1'
Butch Bean
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 09, 2002 7:24 AM
To: [EMAIL
'
SELECT * from QB as tbl1
LEFT JOIN relAB as tbl2
ON tbl2.B=tbl1.ref
where tbl2.B='a1'
-Original Message-
From: Nuno Teixeira [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 09, 2002 11:18 AM
To: Butch Bean
Cc: [EMAIL PROTECTED]
Subject: Re: is possible 1 query with 2
'
|
| SELECT * from QB as tbl1
| LEFT JOIN relAB as tbl2
| ON tbl2.B=tbl1.ref
| where tbl2.A='a1'
-Original Message-
From: Nuno Teixeira [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 09, 2002 12:45 PM
To: Butch Bean
Cc: [EMAIL PROTECTED]
Subject: Re: is possible 1
copies but when any
of those copies get to this Inner Join it is slow and is tagged as a MySQL
Slow query.
Are there settings I should be making on the Server?
Is there a better way or method to make a query like this go faster?
Thanks
Butch Bean
Table type is MyISAM
EXPLAIN returns the following
: MS Word MyODBC !?!?!
Hi folks, hi butch,
yes, I do have MS query installed, but where to start? Is there a FAQ or
HOWTO or just some sample-scripts? I just need the first steps, then I think
I can walk alone ...
rgds,
Felix.
- Original Message -
From: Butch Bean [EMAIL
Yes, using MS Query which comes with Office
ODBC must be installed and working with a DSN set to you MySQL database
then...
See if you have MSQuery installed... if you do the file name is MSQRY32.EXE
in your Office directory.
If MSQuery is not installed, find your Office 2k CD and run setup.
-fetchrow_array()...
.
I use VB and Perl and the examples I could give you can get lengthy
This example would be very slow in comparison
SELECT *
FROM contacts
ORDER BY age DESC
LIMIT 1
Butch Bean
-Original Message-
From: Richard Morton [mailto:[EMAIL PROTECTED]]
Sent: Sunday
PROTECTED]; Richard Morton; DL Neil;
[EMAIL PROTECTED]
Subject: RE: Selecting the row with largest number in a column
At 10:06 -0500 1/28/02, Butch Bean wrote:
Richard,
I use this with all kinds of situations.
I am using this function and others like it on tables with 100k to 3m
records.
They always
You are correct... my apologies, I was thinking in VB where I built a
handler to let me sent multiple sql statements in one chunk and where the
'@' doesn't matter.
BB
This Works as a test...
my $getbigage = $dbh-prepare(
SELECT \@maxage:=max(age) from contacts);
my $getbigage1
A camera-ready document is what is sent to a printing service. The
print-out may have crop marks or color information.
bb
-Original Message-
From: Andrew Gould [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 28, 2002 12:35 PM
To: David S. Jackson; [EMAIL PROTECTED];
[EMAIL PROTECTED];
The fastest way I found would be:
SELECT MAX(age) FROM contacts
good luck
bb
-Original Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 26, 2002 12:14 PM
To: Richard Morton; [EMAIL PROTECTED]
Subject: Re: Selecting the row with largest number in a column
it in MySQL with MySQL load tools and manipulate
the data in MySQL.
Butch Bean
-Original Message-
From: Peter Reck [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 7:16 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: SOFTWARE to IMPORT CONTACT INFORMATION from MySQL
Dear
Make sure you have MySql running on the second machine!
mysqldump -h sourcehost -v -uroot --opt --compress sourcedb | mysql -h
targethost -uroot -C -w sourcedbCopy
More examples in the manual...
http://www.mysql.com/documentation/mysql/full/manual_toc.html#Upgrading-to-a
rch
First try:
mysqld-max-nt -remove
When its the first time running use:
mysqld-max-nt --standalone
-So you can see what is happening...
Shutdown
Then:
mysqld-max-nt -install
Restart as a service.
I just went through this last night...
Butch Bean
-Original Message-
From
, but what about windows...
I have MySQL version 3.23.43 windows...
Butch Bean
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: Re: Help turning on raid on MySQL windows version
At 20:29 22/10/2001 -0400, Butch Bean wrote:
Hi!
I had consulted the MySQL developer Tonu the responsible of the
RAID code about the use of RAID on Windows and he said me that
wasn't tested it on Win32
You can define unique keys
CREATE TABLE MyTable (
X char(50),
Y char(25),
Z char(15),
Count_ int(11),
INDEX X (X),
INDEX Y (Y),
UNIQUE XY (X,Y));
and use a sql like INSERT IGNORE INTO MyTable VALUES(X,Y,Z) keep in mind
that the keys will grow fast.
The IGNORE stops error messages when the
I used MyAccess2000, it connects through ODBC inside Access. You can create
tables, import Access to MySQL or MySQL to Access and it will display table
SQL and indexes, its $30usd http://www.accessmysql.com/
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent:
Has anybody turned on raid for the windows version?
Turning this feature on in Unix appears simple, but what about windows...
I have MySQL version 3.23.43 Linux windows and I need them both configured
the same way.
Butch Bean
mysqld-nt.exe Raid is
still not enabled.
What have I done wrong? Can anyone help?
Thank you.
Butch Bean
Informative Software Computer
[EMAIL PROTECTED]
PH: (856) 858-5135
FX: (856) 858-2224
-
Before posting, please check
: Re: How can I turn on Raid support in windows 2k
Butch Bean wrote:
I downloaded MySql v3.23.43 binaries to see if I could make use of the
system for my database 'stuff'. I have several tables that when loaded
will
be 2gb and the concept of raid support would be appealing.
Raid does not seem
I downloaded MySql v3.23.43 binaries to see if I could make use of the
system for my database 'stuff'. I have several tables that when loaded will
be 2gb and the concept of raid support would be appealing.
Raid does not seem to be enabled on the default download. Because of this I
downloaded
26 matches
Mail list logo