Hi All,
I am a newbie and use MySQL 4.1.8 on Windows XP, I put my.ini in
MySQL directory. When I add character_set_server = gbk to my.ini,
everything is OK. The Server could normal startup. But when I add
other character_set_xxx to my.ini, such as
[mysqld]
I am trying to load data from a text file into a table using the Load data
infile statement. No matter how I change data types I seem only able to load
in the first row of data into the MySQL table and no more. I have not been
able to trach the source of this error or the cause of it? Does anyone
Let's say I have a table w/ three rows: ID, Time, and Name. when I do:
select Time, Name group by Name Order By Time
MySQL selects one of the Time fields if there are rows with the same
Name and then does the ordering using this selected field (I am not sure
what is the logic but it seems it
On Saturday 18 December 2004 04:12 pm, Sasha Pachev wrote:
Darrell:
Note that MySQL is attempting to parse something that you do not seem to
have in your query. I believe what is happening is that you are overwriting
some buffer somewhere (possibly in the sprintf() call), and then end up
- Original Message -
From: Jalil Feghhi [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, December 19, 2004 3:37 PM
Subject: Order By When Grouping
Let's say I have a table w/ three rows: ID, Time, and Name. when I do:
First of all, I think you mean to say that your table has 3
First, here's where they are:
[EMAIL PROTECTED] /]# find / -name libmysql*
/usr/lib64/libmysqlclient_r.so.14
/usr/lib64/libmysqlclient.so.14.0.0
/usr/lib64/libmysqlclient.so.14
/usr/lib64/libmysqlclient_r.so
/usr/lib64/mysql/libmysqlclient.la
/usr/lib64/mysql/libmysqlclient_r.la
please post the complete outputs of
SHOW PROCESSLIST;
and
SHOW INNODB STATUS
during such CPU peak.
Daniel
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up
I was having trouble importing a particular csv file
into a MYSQL table, so I designated most of the fields
VARCHAR. Now that all my data is finally in the table,
I'm weeding out various mistakes and redesignating the
fields. But I'm hung up on a numerical field which
features 1) some numerals