In the last episode (Jan 16), Haluk Karamete said:
> How do I do case insensitive searches and replace operations? Is there an
> easy way to do this? Like some sort of a server level setting telling
> mySQL to ignore case for once and for all?
For searches (i.e. comparisons in the WHERE clause),
Thank you for your reply... But isn't "like" very very slow in
comparison to a none-like straight search?
Isn't it an overkill for a case sensitivity issue?
It appears to me that like has its own usage arena and case
sensitivity issue won't just justify the use of it...
MSSQL can be configured to
use LIKE
On Jan 17, 2012, at 10:36 AM, Haluk Karamete wrote:
> How do I do case insensitive searches and replace operations?
> Is there an easy way to do this? Like some sort of a server level
> setting telling mySQL to ignore case for once and for all?
>
> --
> MySQL General Mailing List
> F
How do I do case insensitive searches and replace operations?
Is there an easy way to do this? Like some sort of a server level
setting telling mySQL to ignore case for once and for all?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
On 1/16/2012 4:14 PM, bruce wrote:
hi Peter.
Sorry.. Been looking at this for awhile.
In the sample data/tbl I provided, it has two top level root/parents.
Ie, I have two entries that don't have a
parentID. I use 0 to be null.
Mistake. use Null.
The items are (0,1), and (0,8).
Then the ta
hi Peter.
Sorry.. Been looking at this for awhile.
In the sample data/tbl I provided, it has two top level root/parents.
Ie, I have two entries that don't have a
parentID. I use 0 to be null.
The items are (0,1), and (0,8).
The (0,1) item, has a number of descendants. The (0,8) only has a
singl
My two cents are this.
This is the kind of problems they invented transactions for. If you find
yourself doing this on non-transactional tables, you will need to use a lot of
error checking, triggers, application checks and post-cleanups to make it work
somehow. Likely, every once in a wh
On 1/16/2012 12:53 PM, bruce wrote:
On Mon, Jan 16, 2012 at 1:52 PM, bruce wrote:
Hey Authur.
Should have been more clear. I've looked over a number of sites. And
with the exception of the the articles that talk about using the
"Nested List" approach, nowhere did I find data on how to get a
co
On Mon, Jan 16, 2012 at 1:52 PM, bruce wrote:
> Hey Authur.
>
> Should have been more clear. I've looked over a number of sites. And
> with the exception of the the articles that talk about using the
> "Nested List" approach, nowhere did I find data on how to get a
> complete list of the child des
I am using debian squeeze and mysql 5.1.45. I am trying to use mysqldumpslow
-s c -t 10, but I keep getting the following error:
Can't determine basedir from 'my_print_defaults mysqld' output:
--general_log=on. Does anyone have any idea as to why? I am not getting
anything from google.
TIA,
See the piece on trees at www.artfulsoftware.com. It goes into several
variations of how to handle hierarchies.
HTH,
--
Arthur
Cell: 647.710.1314
Prediction is difficult, especially of the future.
-- Neils Bohr
>
> I think what Paul (who wrote a book on MySQL, by the way) was getting at was
> that you risk what database folk call "referential integrity issues" if you
> mess with *any* data without knowing where else it is used.
> [snip]...
that was really an important post, excellently written!
-Govi
Running mysql(5.5) /linux/ php/python
Got a situation with a test env, where I'm dealing with a number of
spawned processes, that might also spawn processes, so I have a "tree"
where I'm looking to determine when the spawned processes have
completed. To manage this cluster/tree of processes, I'm c
> From: Tim Dunphy
>
> ... this is just a test environment so getting rid of those users won't have
> any meaningful impact...
I think what Paul (who wrote a book on MySQL, by the way) was getting at was
that you risk what database folk call "referential integrity issues" if you
mess with *an
On Mon, Jan 16, 2012 at 4:37 AM, mantianyu wrote:
> I have download the
>
> Linux - Generic 2.6 (x86, 32-bit), Compressed TAR Archive
>
> binary edition
>
> and I installed it all followed the INSTALL_BINARY
>
> but at last step I start the service by run
>
> sudo bin/mysqld_safe --user=mysql
>
>
2012/01/16 19:37 +0800, mantianyu
but at last step I start the service by run
sudo bin/mysqld_safe --user=mysql
I got following error message
cifer@Pig:/usr/local/mysql$ 120116 19:15:28 mysqld_safe Logging to
'/var/log/mysql/error.log'.
Your means of starting does not sh
It doesn't particularly say, but this:
> 120116 19:15:29 120116 19:15:29 InnoDB: 1.1.8 started; log sequence number
> 1595675
suggests to me that there's still junk from a previous install around. You
might want to clean that up.
- Original Message -
> From: "mantianyu"
> To: mysql@lis
Just adding an extra note to the already good Shawn response.
Theoretically this is just as any booking system that needs to be run in
transactions (db or not).
What you are doing is not trivial if that makes you feel better.
The problem is basically that the web interface is asynchronous so you h
I wouldn't recommend 'playing' with the grant tables instead use the
designated commands.
Anyway keep in mind that if you modify the grant tables manually you have
to force the reload of the privileges in memory by using the 'flush
privileges'.
Not needed if you use GRANT/REVOKE etc.
Cheers
Claudio
19 matches
Mail list logo
