dont know what
direction would be best to further diagnose this.
If you have any advice , it would be greatly appreciated.
thanks for your time!
Aaron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e the lock delays on a
slow SELECT statement?
Thanks !
Aaron
ake around 5 , and some will take ridiculously long times. I think that
has to do perhaps with the amount of rows matching before the ORDER BY?
I've included all the information I can think of below if anyone feels like having a
look, It would be be greatly appre
val__15Item_func_round + 228
0x82deed4 _end + 1156532
0x8048101 (?)
Does anyone know what this means exactly?
If it helps , we're running Red Hat 6.2 , Linux 2.2.19-6.2.12smp . I got it running on
a similarly configured machine with no problems , so Im kinna stumped.
Thanks!
Aaron
; is not fixed because of errors
Try fixing it by using the --safe-recover (-o), the --force (-f) option or by
not using the --quick (-q) flag
Then, I can fix the problem by using the --safe-recover option , but as soon as
a delete is done on the table , it corrupts again.
Anyone have any ideas?
Tanks,
Aaron
delete a record
again.
I have also noticed that the only tables that are corrupting are ones that have
fulltext indexes.
Here is some more info , if anyone can help , it would be greatly appreciated.
Should I consider rebuilding the full text indexes?
Thanks,
Aaron
mysql> DELETE F
Hi Gleb , thanks for the answer. Thats exactly what the problem was. I
needed to rebuild the fulltext indexes on my tables. After I did that , the
problem seems to have magically disappeared. :)
Cheers,
Aaron
- Original Message -
From: "Gleb Paharenko" <[EMAIL PROTECTED]
Hi all ,
I have a relatively simple query that is taking longer than I think it
should. Can anyone possibly give me some idea why this might be or any
potential bottleneck areas I might want to check out?
thanks!
Here is some information.
The query below takes around 8 seconds, and return
usually* in the search criteria.
everything is ordered by deletedate to get the most recent results
first.
What should the thinking be when deciding how to best index this table
for speed of searches?
All advice welcome and appreciated!
Thanks,
Aaron
How can I select the last record that was inserted? An ASP/VB example would
be great too!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Great - thanks!
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: March 10, 2004 5:36 PM
To: 'Aaron '; '[EMAIL PROTECTED] '
Subject: RE: @@identity
Rough example. Assuming that you are using the same connection since
last_insert_id() is
..., 4096) = 1782
--- SIGSEGV (Segmentation fault) ---
+++ killed by SIGSEGV +++
>How-To-Repeat:
just run mysqladmin with any options
>Fix:
>Submitter-Id:
>Originator:Aaron Newcomb
>Organization:
>MySQL support: none
>Synopsis: mysqladmin cause
iated.
Aaron
-
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-m
else might I try?
Thanks,
Aaron
-
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]>
T
I have a very simple database I am trying to backup.
I run myslqdump and it gives me the code below.
Which does nothing but cause errors when I try to run it.
Thank you in advance for your help
-Aaron
-- MySQL Administrator dump 1.4
Right, that is what I am doing, but it does not work.
Have you used mysqldump successfully?
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Aaron Morris" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, November 15, 2005 1:40 PM
Subject
suggestions? Thanks!
--
Aaron Axelsen
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to further investigate.
Any other suggestions are welcome, thanks!
-- Aaron
[EMAIL PROTECTED] wrote:
> If you are running MySQL on Windows, then I'm wondering
> whether you are having a problem with running out of
> available ports, for clients to connect to MySQL on.
>
> This may
ng to drop/re-import (using a single process),
the larger tables continue to fail (though at different points) while some
of the small-medium sized tables made it across.
Anyone else run into this before? Ideas?
Thanks,
-Aaron
This doesn't work the same way as system RAM though. You can't extend your
innodb buffer pool onto a block device or filesystem. Though this
technology would be good for segregating things like InnoDB logs and mysql
binary logs.
-Aaron
On Thu, Jan 22, 2009 at 7:40 AM, mos wrote:
as an excellent point with innodb-file-per-table as well. Just
make sure a single table will never grow to more than the maximum file size
of your filesystem.
Good luck,
-Aaron
On Fri, Jan 23, 2009 at 1:18 PM, Daevid Vincent wrote:
> We have some INNODB tables that are over 500,000,000 row
ldump/import
necessary to preserve data integrity?
If a file copy doesn't work, why specificially would it fail?
Thanks,
-Aaron
This is confirmed working on a small test set with MySQL 4.1.22
transitioning from SPARC to X64. Thanks everyone!
-Aaron
Here's the test set we used:
CREATE TABLE `test_innodb` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`bigint` bigint(11) DEFAULT NULL,
`float` float DEFAULT
n't terribly large would be to
cram as much RAM in the host as you can. If you've only got a portion of
your data that's heavily accessed, keeping it in RAM would be ideal.
-Aaron
On Mon, Feb 23, 2009 at 9:17 AM, Brent Baisley wrote:
> SCSI isn't necessarily faster no
build the query. Is
there some way of doing that?
Thanks,
-Aaron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ce they're both writable.
-Aaron
On Wed, Jul 8, 2009 at 1:38 PM, Cantwell, Bryan wrote:
> I have successfully set up a replication master/slave scenario with my
> MySQL 5.0.51a
> Now in the event of a fail over to the slave (an identical appliance), I
> want the old master to becom
;html'. The only common they all have is the period
before the extension. Anyone created a nested substring query that
can do what I am looking to do?
Thanks,
Aaron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/m
re wording. I want to cut that off. Also, some paths do not
have an extension and I am trying to ignore those. So simply. I am
just trying to pull out the file extension but there were some
conditions I did not list.
-Aaron
>
> SUBSTRING_INDEX should do what you want.
>
>
Sorry Jay,
Here is what I came up with.
select substring(substring_index(myfile,'.',-2),1,4) AS MyColumn from
mydatabase group by MyColumn;
That appears to yield what I need. I just need to filter out the
results that do not have an extension.
-Aaron
On Thu, Jun 10, 2010 at 9:
d tweak to solve
this specific issue. Server is a dual-quad core w/ 4GB of RAM,
although it's not dedicated to MySQL (webserver and some other
database centric background jobs run). Table1 however is on a
dedicated RAID1 disk pair and is getting regular inserts/deletes (it's
a log table).
g-subqueries.html
>
> If you have further questions after doing that, show the table structures,
> the query, and the explain output.
>
--
Aaron Turner
http://synfin.net/ Twitter: @synfinatic
http://tcpreplay.synfin.net/ - Pcap editing and replay tools for Unix & Windows
Hi all
i use mysql database,when i use mysql replication ,the slave host do not
replication,i check the error message,i found error message,it is 'row is
too large', i do not understand why,please tell and help me ,thanks
compare the index field in Table A to the index field in
Table B. I would like to see all records where the index in Table A
does not exist in Table B.
Thoughts? Suggestions?
Much appreciated!
-Aaron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Thanks Peter and Baron, these both worked well.
The "left join on" took .1919 seconds and the "left outer join as"
took .1780 seconds.
=)
On Oct 26, 2007, at 11:37 AM, Peter Brawley wrote:
Aaron
An exclusion join:
SELECT a.col
FROM a
LEFT JOIN b ON a.col=b.col
WHER
Will you be using the MyISAM or InnoDB table engines?
I had heard that InnoDB uses 16k blocks internally, so that might be a good
starting point, though I'd love to have someone confirm or deny that this is
actually true.
-Aaron
On Fri, May 9, 2008 at 12:01 AM, Iñigo Medina García <
ifferent points
within the InnoDB data file. In a business intelligence application where
there's not much deleting this probably isn't a concern...
I think the best way to approach it may be to look at your average row size
and base your InnoDB and filesystem block sizes around tha
why doesn't this work? the select works perfectly
create view cost_report as
SELECT c_name, d_manuf as Manufacturer, d_model as Model, count(1) as
"Number Enrolled",
d_price as "Monthly Price", count(1)*d_price as "Cost"
FROM `b_devices` A
left join b_device_types B
on A.d_id = B.d_id
left join
les have been added because of data growth.
My questions are these:
* How does InnoDB store VARCHAR information? Is it based on the
column max length?
* How does InnoDB decide to re-use free blocks within the data files?
Are rows prone to fragment?
Thanks,
-Aaron
--
MySQL General Mailin
Generally your error log will be .err in your data_dir.
-Aaron
On Thu, Jun 26, 2008 at 8:46 AM, <[EMAIL PROTECTED]> wrote:
> Sorry about the long signature in the email. I forgot to remove it...
>
> Guillermo
>
>
>
>
>
>
> From:
> [EMAIL PROTECTE
nsfer mechanism
(FTP, scp, etc.).
-Aaron
On Thu, Jun 26, 2008 at 5:09 PM, <[EMAIL PROTECTED]> wrote:
> See Thread at: http://www.techienuggets.com/Detail?tx=42035 Posted on behalf
> of a User
>
> Hi,
>
> I'm running MySQL 5.0.51 Community edition. I have a half a gigabyte
but we 'manage' the database through phpMyadmin.
Thank you for your help!
Aaron N.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
2GB of the key_buffer
alocation and put it towards the innodb buffer pool
What are the system's specs? What's it's underlying storage? What flags
were used when you created the filesystem(s)? What OS/Version of MySQL are
you running? Could you send us some iostat output?
Thanks
We'd need more information on what the where clauses of the queries
look like to assist with this.
-Aaron
On 9/5/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
> Hi,
>
> What would you say about the below table . What can i do to make it more
> effi
rays and can offer
performance capabilities way beyond what can be practically achieved by
using direct attached storage.
-Aaron
On Thu, Sep 25, 2008 at 6:38 PM, Michael Dykman <[EMAIL PROTECTED]> wrote:
> Hello all,
>
> I recent started employment with a company which has a lot of
e to do a full mysqldump
based migration.
Thanks,
-Aaron
value is not
in any row in D.
for example:
C =
1
2
3
4
5
6
7
8
11
D =
2
4
6
8
10
and the statement would return:
1
3
5
7
11
Probably an easy question for those of you more experienced but I have no
clew.
Thanks in advance.
Sincerely
Aaron Cannon
- --
Skype: cannona
MSN/Windows Messenger: [EMAIL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
It is unfortunate that mysql does not offer a binary version with ssl
support for Linux. Does anyone know why? It can't be for export reasons,
as they do offer a windows version with SSL support.
Aaron Cannon
- --
Skype: cannona
MSN/Wi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Actually, I think he was asking if the sized used by the storage engine
would change if you used for example int(2) as apposed to int(10). My guess
is it would not, but that's just a guess.
Aaron Cannon
- --
Skype: cannona
MSN/Windows Mess
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
If it's any consolation, I got the exact same warnings. However, I don't
know if it's normal either.
- --
Skype: cannona
MSN/Windows Messenger: [EMAIL PROTECTED] (don't send email to the hotmail
address.)
- - Original Message -
From: "Jerry
.sql.bz2.3 db.sql.bz2 \
>db.sql.bz2
6. decompress the db.sql.bz2 file
bunzip2 db.sql.bz2
7. import db.sql into wherever.
Hope this helps.
Aaron
--
Skype: cannona
MSN/Windows Messenger: [EMAIL PROTECTED] (don't send email to the hotmail
address.)
- Original Message --
again!
>Fix:
Remove the following section from /etc/my.conf:
[mysql.server]
user=mysql
basedir=/var/lib
In /etc/init.d/mysql, parse_server_args sets $bindir=/var/lib/bin.
So, /usr/bin/mysqld_safe is not found.
>Submitter-Id: Aaron Scamehorn
>Originator:
>Organization:
Cognitive
rs
credit cards. There are too many ways security can be compromised on such
systems. If that is in fact the case, I would suggest you outsource the
customer billing. Remember also that security breaches of this type can
seriously damage the reputation of any organization.
Aaron
- --
Skype: cann
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Googling for
ASP AES
I found several promising results.
- --
Skype: cannona
MSN/Windows Messenger: [EMAIL PROTECTED] (don't send email to the hotmail
address.)
- - Original Message -
From: "Neil Tompkins" <[EMAIL PROTECTED]>
To: <[EMAIL
int
date datetime
Essentially, the client enters his id and it creates a record in the
signin table.
I need a query that can identify all the clients who signed in for the
first time during a specific month. I have fought this one for a
couple of days now and just can't seem to get it.
--
27;
'--sysconfdir=/etc' '--datadir=/usr/share'
'--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info'
'--includedir=/usr/include' '--mandir=/usr/share/man'
'--enable-thread-safe-client' '--with-comment=MySQL Comm
http://www.birdsoft.demon.co.uk/proglib/slowpipe.htm would seem to do
what you want... I havent tried it yet, but noted the URL for the next
time I needed that functionality.
- Original message -
From: "Amit M Bhosle" <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Date: Fri, 13 May 2005 09
the 'show processlist;' command can display what threads are
encrypted and which ones aren't?
thanks
aaron
__ __ __ __
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To un
its talking to is a mysqlsql version 4.0.13 on
unix)
i am using openssl version openssl-0.9.7a and mysql-4.0.17. Has anyone else seen this
type of error before?
thanks for the help!
Aaron
__ __ __ __
--
MySQL
You can add a version field to each row. Then add a seperate table with
info with a list of the versions and a flag for deleted. Queries would
look for each record that has the highest version number thats not
deleted. Having a lot undo/redo info can get kind of complicated,
especialy with multip
s is the user accounts. I've set up the user to be able to
connect from anywhere. Summary(user: xxx, host: %, password: Yes,
privileges: ALL PRIVILEGES , grant: Yes). I used phpmyadmin to set up
the accounts.
Thanks in advance,
Aaron-
--
MySQL General Mailing List
For list a
in your replies.
Thanks again.
Aaron-
On Jan 10, 2004, at 3:20 PM, Johannes Franken wrote:
* Aaron Gerber <[EMAIL PROTECTED]> [2004-01-10 21:33 +0100]:
Locally, I can connect to the MySQL server [...]
but I can't connect if I put in the IP address (locally or remotely)
Maybe mysqld is c
So I've got fairly big sized table (20,000 records) which has an ENUM
row. I need to change the name of one of the ENUM options. For
example, if the ENUM value was 'blue' before, it needs to be 'purple'
now. What's the best way to do this?
Thanks,
-Aaron
Perhaps just something trivial but both numbers are differing:
> SELECT * FROM book_details WHERE ISBN = '1---1'
and
>and I've put a test ISBN number in of 1--111-11
In any case I have ran a test on my servers with mysql V 4.0.13 and things
work accordingly.
--+
I am still getting the output I had before in the 77,000+ results being
returned.
I am at wits end here and don't know where else to look *shrugs*
ANY clues? Do you want to see some of the table data?
Thanks
Aaron
> -Original Message-
> From: Andy Jackman [mailto:[EM
one help guide me to get the results of #1 but with the WHERE of
#2?
Thanks so much!
Aaron
Hey.
The code that I'm trying to get to work is as follows. The problem is
with the 7th, 8th, and 9th lines...
Test MySQL
Error " . mysql_errno() . ": " . mysql_error() . "");
elseif (mysql_num_rows($result) == 0)
echo("Query executed successfully!");
else
{
?>
Variable_nameValue
")
ly utilized this feature.
Does anyone out there have any input?
Thanks.
Aaron
Sure enough... I just installed the latest 4.1 linux binaries, I didn't
realize that the server itself had to be compiled with the debug enabled
(although now that I realize that it makes complete sense). It would be
nice if the documentation for mysqlimport would at least make note of this.
Thank
THEN changes the first character of each
result to an upper case?
Example:
Currently in DB: AARON
to Lowercase: aaron
to Uppercase: Aaron
Any idea on if I can do this and how I might approach it?
Thanks so much
Aaron
d to work? Or is the way I am
simulating this case flawed? I must say that the documentation is not
very verbose about server variables and so wasn't extremely helpful to
me in solving this problem.
If there's another better way to solve my locking issue, I would love
to hear tha
mers AS t1, productb_customers AS t2 WHERE
t1.email != t2.email
When I do this query. I get 486,057 results returne.
Where am I going wrong? Any ideas?
Thanks so much for the help!
Aaron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.
ll of
those customers who DO have email address that matches in each table?
Thanks again guys. Very much appreciated!
Aaron
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: July 9, 2004 12:17 PM
> To: Aaron Wolski
> Cc: [EMAIL PROTECTED]
&
Well well...
That worked too!
Damn... this is starting to make life easier :)
Thanks again. Very much appreciated!!!
Aaron
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: July 9, 2004 2:00 PM
> To: Aaron Wolski
> Cc: [EMAIL PROTECTED
.last
For some strange reason it doesn't seem to group the email addresses.
I'd be hard pressed to find every occurrence out of 1000 records, but I
DID quickly spot two exact same records which means the email address
was not grouped.
What can I do or where did I go wrong?
Thanks!
Aaron
-
Yes sir. Exactly!
A
> -Original Message-
> From: Victor Pendleton [mailto:[EMAIL PROTECTED]
> Sent: July 13, 2004 11:15 AM
> To: 'Aaron Wolski '; '[EMAIL PROTECTED] '
> Subject: RE: Why this query doesn't group the email addresses
Hey guys,
I have a column in a table called 'first'.
Currently all records are upper case. Is it possible for me to do a
select statement that makes all chars after the first char lower case?
Example:
Current: AARON
After: Aaron
I think this is possible.. just don't know how
ry is that is
groups all the columns (first,last,email) into one column.
What I would like is just the 'first' column.
Something tells me this isn't possible?
Thanks to you as well for the help. I wouldn't have figured it out for
myself that's for sure.
Aaron
> -Ori
varchar, sir.
> -Original Message-
> From: Wesley Furgiuele [mailto:[EMAIL PROTECTED]
> Sent: July 13, 2004 1:14 PM
> To: Aaron Wolski
> Cc: [EMAIL PROTECTED]
> Subject: Re: Why this query doesn't group the email addresses?
>
> What type of field is the
I'm running 3.23.49 on a Win2k machine and wonder if anybody has some advice on how to
write queries dealing with IP addresses. Specifically, I have a table with an ip
address field. I want to be able to do queries based on subnet. Has anybody got
anyting like this?
--
Aaron Clausen
[
Run all your tables thru this. Save the script as xinno_convert. As in
xinno_convert < foo.sql | mysql
Suposedly you can also alter a table to innodb. But that never worked
for me it just looped using cpu for days. So I made this script which
worked fine. Other than converting implicit lockin
Hello,
I was wondering if someone could provide a brief description for both of
the following attributes within the 'db' table:
'create_tmp_table_priv' and 'References_priv'
Any information you can provide will be helpful.
Thanks,
Aaron
--
MySQL
Yes.
Or find a host that will give you ability for multiple databases.
HTH
Aaron
> -Original Message-
> From: David Fleming [mailto:[EMAIL PROTECTED]
> Sent: April 2, 2004 10:30 AM
> To: [EMAIL PROTECTED]
> Subject: Administrative limitation
>
> (newbie questi
right syntax to use
near 'AS percentage FROM CartTable WHERE company ='1' AND submitted='
Any clue why this would no longer work?
Thanks!
Aaron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am trying to write a script that can take logs from our mail server, boil down the
rejections to determine the sources of distributed SMTP dictionary attacks against our
mail server.
Basically I have a table "send_failures like this that gets fed with the raw data from
the logs:
host_ip
Thanks Paul - it worked perfectly. And for anyone else listening, modifying
the table did not adversely affect the data (although I did back up just in
case). --Aaron
On 11/1/02 7:34 PM, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
> At 15:25 -0600 11/1/02, Aaron Merri
oring matches. other times
> it works fine. has anyone else had this experience with it?
>
> thanks,
>
> aaron.
>
>/ \
> |
your problem being? perhaps you fail to realize that replace(1) is part of
the mysql distribution.
aaron.
so said [EMAIL PROTECTED] in 1.6K bytes at Tue, Dec 17, 2002:
> Please shove this up your ass
> - Original Message -
> From: "Aaron Brick" <[EMAIL PRO
the database
server over to Linux in the next six months. But MySQL has been rock solid.
I have lost no data, save through my own stupidity, at any point. I would
recommend it without reservations.
--
Aaron Clausen
-
ere are no tags in the Subject lines of the messages sent to
the list, that is what I usually use to filter messages.
Does anyone have any tips for filtering these messages using Eudora? I
just sub'd to 7 different MySQL lists and cannot get any of my filters to
work right. and sorry for th
ng
mysqlbackup. Works fine and I have used it for restorals on a number of
occasions. Even better, mysqlbackup generates SQL files, which, with a
little manipulation, can be imported into other database systems.
--
Aaron Clausen
--
counting system, and to test out bug fixes, new features, etc., I'll just
dump the running database and pipe it into a test database. I found
mysqldump to have a bit of a learning curve, but I could not survive without
it now.
--
Aaron Clausen
--
Cute =)
(MySQL sql query queries smallint =)
Aaron Krowne
On Thu, Jan 09, 2003 at 04:36:12PM +0100, [EMAIL PROTECTED] wrote:
>
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of t
ight on this type of data storage?
--
Aaron Conaway
Network Engineer III
Verisign, Inc. -- Telecom Services Division
http://www.verisign.com
Office: 912.527.4343
Fax: 912.527.4014
-
Before posting, please check
Thanks to Peter, Ravi, and Dan. That's exactly what I needed to know.
--
Aaron Conaway
Network Engineer III
Verisign, Inc. -- Telecom Services Division
http://www.verisign.com
Office: 912.527.4343
Fax: 912.527.4014
-Original Message-
From: Peter Hicks [mailto:[EMAIL PROT
...
Aaron
-
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]&
gt; select inet_aton("172.20.20.2");
+--+
| inet_aton("172.20.20.2") |
+------+
| 2886996994 |
+--+
1 row in set (0.00 sec)
--
Aaron Conaway
Network Engineer III
V
How-To-Repeat:
I suspect there is a bug in the ODBC driver in relation to blobs. I'm now
using 3.51.06, but was having this same problem on 3.51.05.
I'm using Visual C++ and their CRecordset wrapper for the ODBC calls. I'm
using the positioned updates.
As long as I keep the binary data I'm trying
erformance
problems as the table grows.
Would joins of tables with character based primary keys be slower than
those with numeric based keys? Has anyone had experience implementing a
character-based primary key in a table of non-trivial size (> 500,000
rows)? Thanks for any assistance or poi
wondering if there was a work around for MySQL.
Thanks, Aaron
-
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
MySQL doesn't support LIKE does it? I got an error when I tried.
-Original Message-
From: Nathan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 1:04 PM
To: Rutledge, Aaron
Subject: Re: LIKE work around??
Um... keep using LIKE? Just a thought... :-)
- Ori
1 - 100 of 190 matches
Mail list logo
