Anybody can tell me about way which will force the mysqld write more
information into logs (.err file)?
My mysqld restarted every 20-30 minutes without reasonable info in log
file and I dont understand why it occurs.
I see only string mysqld restarted and nothing more! :(
Example of log:
I tend to use temporary tables a lot, because I'm doing one-off
manipulations where efficiency is not the primary concern and because it
helps me think things through. Nonetheless, I've been wondering about this:
SELECT `x` FROM `t1` JOIN (SELECT `x` FROM `t2`) AS `t3` on `t1`.`y` =
`t3`.`y`;
Hi there,
I'm using Mysql server version:5.0.51a-3ubuntu5.4 (Ubuntu)
I have a doubt using accent-insensitive searches in mysql
I created a database with character set utf8
with a lots of names inside, something like that:
mysql select name from users;
++
| name
If you can not eliminate your temporary tables, you have to adjust
the
following parameters in my.cnf [mysqld]
max_heap_table_size=1G
tmp_table_size=1G
You're making a lot of assumptions about this guy's setup. You
shouldn't just tell
him to apply these kinds of settings as you don't what
Hello All,
I can't get trim to trim the blank space from a TEXT field in the query below
and was wondering if someone could tell what I am doing wrong?
SELECT TRIM(notes) FROM work_notes;
Thanks for any help as I am at a complete loss.
Richard
--
MySQL General Mailing List
For list
http://www.mydigitallife.info/2007/04/23/remove-or-trim-first-or-last-few-characters-in-mysql-database-with-sql/
Richard Reina wrote:
Hello All,
I can't get trim to trim the blank space from a TEXT field in the query below
and was wondering if someone could tell what I am doing wrong?
SELECT
Works for me. I assume you're only trimming blanks from the beginning
and/or end of the string. I have found that it will not trim tabs. Try a
command like:
select concat(', trim(notes), ') from work_notes
On Fri, Apr 17, 2009 at 2:17 PM, Richard Reina rich...@rushlogistics.comwrote: