Hi,
I was just wondering if anyone has any tricks for speeding up huge queries
that require a LIKE comparison, and also a wild card at the front and back
of the search term. For example:
SELECT my_id FROM my_table WHERE my_value LIKE '%ABCDEFG%' LIMIT 50;
I know that in a query such as this, my
Hi,
Could you seperate the letters into one column and the numbers in another...
Then you could group by the Alphabetical column, and order by the numerical
column...
Regards,
Chris Stark
-Original Message-
From: Alliax [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 12, 2002 4:53
able to combine the results on the fly, as it takes a really long time to
perform all the SQL statements I need on the 350 million row table. Maybe I
am thinking about this problem the wrong way, but if anyone has any
suggestions, please let me know.
Thanks in advance,
Chris Stark
Hello,
Is there any way to grant a user only SELECT permissions on a set of tables
in MySQL, but to also allow them to have CREATE, DROP, and INSERT on the
Database itself??
What I want is a database where the users cannot modify the core tables, but
I want them to be able to CREATE and DROP t
Hello,
I have a question, and hopefully someone out there can help me out. I have
a lot of really large numbers (or should I say small, large in size ) that I
need to store in my MySQL database. Numbers like:
2.8E-50 or 0.049zeros028
Anyway, I need to store these numbe
...
Chris
-Original Message-
From: Manish Mehta [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 15, 2002 12:33 AM
To: Chris Stark
Subject: Re: Begin work
Where "Begin work" Works process used mainly.
Manish
- Original Message -----
From: Chris Stark <[EMAIL PROTECTED
"This statement signals the successful end-of-transaction. A transaction is
a group of SQL statements whose changes are logically connected and can be
made permanent or undone as a unit. All updates made during this
transaction are made permanent, all row locks are released, and active SQL
SELEC
Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 11:49 PM
To: Chris Stark; [EMAIL PROTECTED]
Subject: Re: Disappearing of New Inserts to MyISAM table
At 23:05 -0500 3/14/02, Chris Stark wrote:
>Hi Everyone,
>
>I am in kind of a jam, and I could use
Hi Everyone,
I am in kind of a jam, and I could use some help. Hopefully someone out
there has encountered something similar to this. I have a MySQL database,
and I am using Java to make the connection to the database. At one point in
the execution of my app, I need to issue an ALTER TABLE co
Hello,
Depending on what types of values are in your table, and the types of
selects that you are going to perform, you will most likely notice a speed
change if you were to INDEX some of your attributes...Just look up INDEX in
the mysql manual...
I notice the largest improvement when I INDEX on
Hi,
I am having a problem with the configuration of the mysql server or client.
I have a very large query that I need to send to MySQL from Java. The query
has approximately 5000 individual items in the where clause. (i.e. WHERE
i!='AP' AND i != 'J3' AND...to 5000).
When I try to execute the Q
11 matches
Mail list logo
