Recently I went through a link related to this question. check the below
link.
I haven't checked the script, hope it will be useful.
http://tequilaphp.wordpress.com/2010/07/05/searching-strings-in-a-database-and-files/
Regards,
Jay
MySQL DBA
On Thu, Aug 12, 2010 at 2:31 AM, Carlos Mennens wrote:
I have a database called 'gaming' and with in that database there are
several tables and data. I was asked to find a module called 'ako
ldap' and disable it (setting it from 1 to 0). My question is how in
MySQL do I search for a string if I don't even know what table to
search in? I know how to sea
Yes, that's it. I should be typing "STRAIGHT_JOIN" instead of "STRAIGHT
JOIN".
Thanks!
Mike Spreitzer
The relationship looks righteous enough but I note that you use
'straight join' in your expression, rather than 'straight_join' as
indicated in the manual
(http://dev.mysql.com/doc/refman/5.1/en/join.html).
Perhaps the message is a red herring and your trouble is elsewhere?
- michael dykman
On
Why is it that a field name that works fine for a JOIN is invalid in a
STRAIGHT JOIN?
mysql> show create table fldsndm;
+-+--
On 8/9/2010 5:27 PM, Yves Goergen wrote:
Does anybody know how to use SSL-secured connections to a MySQL server?
Has anybody done that at all?
In the manual I have now found the following statement:
http://dev.mysql.com/doc/refman/5.1/en/ssl-options.html
Note that use of --ssl does not require
I finally started trying to optimize along the memory-based lines you
suggested. I am surprised to find that the query plan is to enumerate the
memory-based table and then pick out the hundreds of related rows from the
much larger MyISAM table. What's going on here?
`show create table` says t
use Google :)
On Wed, Aug 11, 2010 at 10:02 PM, PRATIKSHA JAISWAL <
pratikshadjayswa...@gmail.com> wrote:
> Hi Prabhat,
>
> Thanks a ton for sharing your blogs with us.
>
> I am learning mysql database. I am very good at PostgreSQL.
>
> Do you have any other material where in i can go for Mysql C
How does one do that? How do you drop auto-increment attribute then drop the
index then restart the auto increment value where it was before you dropped
it?? I did not know you could do that.
The reason I ask is because the dbf_UID is a unique id tag the coders use to
identify a product by ma
Yowsers! I expected that eliminating half of the string manipulation would
help, but I never imagined that the difference would be so great.
The SELECT now runs in well under a second.
=
SELECT pub_id FROM pub WHERE pub_code = 'DC' INTO @PUBID;
DROP TEMPORARY TABLE IF EX
>-Original Message-
>From: Travis Ard [mailto:travis_...@hotmail.com]
>Sent: Tuesday, August 10, 2010 6:53 PM
>To: 'Jerry Schwartz'; mysql@lists.mysql.com
>Subject: RE: Slow query using string operator
>
>Can you create a second, indexed column in your feed_new temp table that
>includes the
Hi Jerry, all!
I second Travis' advice:
Travis Ard schrieb:
> Can you create a second, indexed column in your feed_new temp table that
> includes the title without the year appended? That might allow you to get
> by with a single pass through the larger prod table and avoid reading rows
> from
check this,
http://adminlinux.blogspot.com/2009/12/mysql-tips-calculate-database-and-table.html
Thx
On Wed, Aug 11, 2010 at 5:23 PM, PRATIKSHA JAISWAL <
pratikshadjayswa...@gmail.com> wrote:
> Hi,
>
> Thanks all for your help.
>
> >>
> ---Database & Table wise Size in MB---
> SELECT TABLE_SCHE
Hi,
Thanks all for your help.
>>
---Database & Table wise Size in MB---
SELECT TABLE_SCHEMA AS 'Database', TABLE_NAME AS 'Table',
CONCAT(ROUND(((DATA_LENGTH + INDEX_LENGTH - DATA_FREE) / 1024 / 1024),2),"
Mb") AS Size FROM INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA = "dbname";
>>---Database &
14 matches
Mail list logo
