Hello,
I think your tables have a collation different from the connection collation.
Open mysql client:
mysql show variables like 'colla%';
+--+---+
| Variable_name| Value |
+--+---+
| collation_connection
Hello.
May be you should think about the ENUM type. See:
http://dev.mysql.com/doc/mysql/en/enum.html
For example:
create table mon(mon enum('Jan','Feb','Mar','Apr' , 'May' , 'Jun' , 'Jul' ,
'Aug' , 'Sep' , 'Oct' , 'Nov' , 'Dec') , a int);
insert into mon values('Jan',5);
insert
Hello.
See:
http://dev.mysql.com/doc/mysql/en/charset-collation-charset.html
Cecep Rosuludin [EMAIL PROTECTED] wrote:
Dear All,
I found an error in mysql message, when I tried to excute this sql in mysql=
front:
select
Hello.
You can enable logging on the server. See:
http://dev.mysql.com/doc/mysql/en/log-files.html
You need the error log, query log, slow log. But be careful!
Heavy loaded server can produce a lot of messages and your
files will grow quickly. If you use InnoDB, you can enable
the
Hello.
How to create the default?
Put the following line into [mysqld] section of your config file:
default_character_set=utf8
See:
http://dev.mysql.com/doc/mysql/en/charset-defaults.html
I just upgraded from 4.0.8 to 4.1.9.
After upgrading, some times it is necessary to do
Hello.
Yes. For example:
mysql select count(*) from yo group by a order by a desc;
+--+
| count(*) |
+--+
|6 |
| 12 |
|3 |
+--+
3 rows in set (0.00 sec)
mysql select count(*) from yo group by a order by a asc;
+--+
| count(*)
Hello
I am trying to run the following query on my server:
select Documents.ID,
Name
from Documents,
DocumentFiles,
DownloadLog
where Documents.ID = DocumentFiles.Document and
DocumentFiles.ID = DownloadLog.DocumentFile
order by DownloadLog.AddedOn desc
limit 5
-
Please visit www.tiscali.co.za
-
Hi there,
I'm trying to install MySQL-3.28.55 on a RedHat Linux 2.4.20-8 server.
When I run the make command after the configure command, i get the following
response just before
Dears,I have slackware10.I install it completely.
But when i use /etc/rc.d/rc.mysqld start ,I recieve following mesage :
mysql ended
Please guide me that i can configure mysql in slack.
Yours,Mohsen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Mohsen Pahlevanzadeh wrote:
Dears,I have slackware10.I install it completely.
But when i use /etc/rc.d/rc.mysqld start ,I recieve following mesage :
mysql ended
Please guide me that i can configure mysql in slack.
Yours,Mohsen
- look in the .err file (probably located in your data directory)
Greetings!
I have a question about MySQL licences. I'm developing a web application
for my customer to install and use on his local network (I use PHP to
develop the application). The application will be installed on a machine
(server) on the same personal network. In this scenario, what is the
Hey - It's been awhile since I set up mysql on a box (it's one of those
things where I teach myself, do it once, then forget it, heh) - but I seem
to remember you need to do some things to initialize the databases and set
initial privileges before it will work - su to the mysql user and run
I suspect mysql is doing the DISTINCT before the ORDER BY. One of the
reasons I avoid DISTINCT when possible. Try:
SELECT Documents.ID, Name
FROM Documents, DocumentFiles, DownloadLog
WHERE Documents.ID = DocumentFiles.Document
AND DocumentFiles.ID = DownloadLog.DocumentFile
GROUP
Hi,
I just downloaded mysql-essential-4.1.9-win32.msi, and as I understood,
the C API supposes to be in here.
Where exactly? I can't find it
Thanks,
__
Judith Shuva
http://dev.mysql.com/downloads/
Please note the section of Official APIs
# Application Programming Interfaces (APIs)
* Official APIs:
o The C API is included with the server, above.
J.R.
-Original Message-
From: Shuva, Judith [mailto:[EMAIL PROTECTED]
Sent: Tuesday,
Hi J.R.
Thanks for your answer.
I saw that the API suppose to be in the MySQL server, so I downloaded
mysql-essential-4.1.9-win32.msi, but after the installation, I can't
find the API in the MySQL folder...
Please, HELP!
Thanks,
Judith
-Original Message-
From: J.R.
Here's a little more info for you.
http://dev.mysql.com/doc/mysql/en/c.html
J.R.
-Original Message-
From: Shuva, Judith [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 25, 2005 9:08 AM
To: mysql@lists.mysql.com; J.R. Bullington
Subject: RE: Where can I download The MySQL C API??
Hi
I am not sure what you mean by getting MySQL C API.
The API are built in libmysql.lib and libmysql.dll or
mysqlclient.lib. The header files are in include
directory.
Just include them in your project and start coding.
Hope I was of help.
Karam
--- Shuva, Judith [EMAIL PROTECTED]
wrote:
Hi
Hello,
my /var/lib/mysql directory contains many -bin.xxx files, some of
which date back to October 2004. What exactly are these files? Can I
safely remove the older ones?
Many thanks.
Philippe
-rw-rw1 mysqlmysql1073741948 Oct 16 15:00
/var/lib/mysql/mydb-bin.029
-rw-rw
On 25 Jan 2005 at 16:07, Shuva, Judith wrote:
Hi J.R.
Thanks for your answer.
I saw that the API suppose to be in the MySQL server, so I downloaded
mysql-essential-4.1.9-win32.msi, but after the installation, I can't
find the API in the MySQL folder...
Please, HELP!
Hi,
The MySQL
On Tue, 25 Jan 2005 08:44:45 -0500, Michael Stassen
[EMAIL PROTECTED] wrote:
I suspect mysql is doing the DISTINCT before the ORDER BY. One of the
reasons I avoid DISTINCT when possible.
Isn't this supposed to be correct? Ordering has to take place as the
very last operation, after any
Philippe de Rochambeau wrote:
my /var/lib/mysql directory contains many -bin.xxx files, some of
which date back to October 2004. What exactly are these files? Can I
safely remove the older ones?
- these are the bin logs, used in replication. MySQL writes all INSERT,
UPDATE, etc., and DDL
Kevin Cowley
RD
Tel: 0118 902 9099 (direct line)
Email: [EMAIL PROTECTED]
Web: http://www.alchemetrics.co.uk
- to remove the bin logs:
PURGE MASTER LOGS TO 'filename'; (where filename is the
name of the last bin log to keep)
I prefer RESET MASTER - it clears and deletes
Hello,
I am running mysql 4.1.7 on Win2K.
I have two tables:
CREATE TABLE `child` (
`id` int(11) NOT NULL default '0',
`name` char(1) NOT NULL default '',
PRIMARY KEY (`id`,`name`)
Hello, I'm a newcomer to MySQL and to databases in general. I'm using MySQL
4.1.9 on a x86-system running Windows XP Pro SP2. I am trying to use the
MySQL C api and I've made the following test program in C (hope the
indentation isn't lost):
#include mysql.h
#include stdio.h
#include stdlib.h
Works fine on WinXP 4.1.8. Only generates warning:
mysql show warnings;
+-+--+--+
| Level | Code | Message
|
There is certainly *something* wrong if the ALTER TABLE statement causes the
server to hang; the statement should either succeed or fail with an error
but in neither case should the server hang.
I'm still back on 4.0.15 so I'm not in a great position to try the code
myself but I see a few odd
There was a serious (threat of data loss) bug in 4.1.7 InnoDB . I'm not
very familiar with the specifics, but this problem could be that.
In any case I'd be scared to run InnoDB on a 4.1.7 without fully
understanding the problem. You should definitely consider upgrading to
4.1.8 , or, at the
You can use FIELD in the ORDER BY. See pp. 330 of the
MySQL Cookbook, or FIELD in the MySQL docs:
http://dev.mysql.com/doc/mysql/en/string-functions.html
mysql SELECT * FROM test;
+--+---+
| name | month |
+--+---+
| foo | Mar |
| bar | Jan |
| baz | May |
| quux | Nov |
Can somebody try this on 4.1.7?
I will download 4.1.8 tomorrow and check it out.
Damn...my connection is slow (on a dialup) and 35MB of
download...h
Regards,
Karam
--- Chris [EMAIL PROTECTED] wrote:
There was a serious (threat of data loss) bug in
4.1.7 InnoDB . I'm not
very familiar
Thanks for your ultra detailed reply.
The tables are just samples (no where related to
actual table). Well I am not that bad in db designing
also ;)
I checked the manual - you indeed can execute two
statements like this in one. And if you see the query
I am even changing the table type in the
Dear all,
I need SSL support for MySQL. I've checked the documentation and it
seems that for windows there is no SSL support in the binaries. In
addition the documentation in the examples is for Linux.
Has anyone has used MySQL with SSL in windows? If so ... how? How easy
is to set it up? What
Hello,
I just checked with the same version at home and it
works.
Dont know whats the problem at office.
Will check again?
Karam
--- Artem Koltsov [EMAIL PROTECTED] wrote:
Works fine on WinXP 4.1.8. Only generates warning:
mysql show warnings;
Even I had the same problem and couldnt use SSL on
windows.
The developers have legal issues when using SSL on
windows. I think there is some development going on
using CryptoAPI but I am not too sure.
My advice, dont even try on Windows. Atleast it was a
big pain in ass for me.
Karam
--- Jose
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
I use a mysql server on red hat 9 linux box with PIII 733 Mhz cpu and
256 MB memory. On this machine we use an adserver with a mysql
backend. All click and view logs are kept in mysql tables. The number
of the advertisements are increasing and
Hardware improvements would certainly help.
There are two things that immediately spring to mind
1) double or quadruple the ram
2) increase/change your discs - add high speed SCSI/SATA putting the
database and swap space on these discs.
The final option is to look at a two
Hello,
I use a mysql server on red hat 9 linux box with PIII 733 Mhz cpu and
256 MB memory. On this machine we use an adserver with a mysql
backend. All click and view logs are kept in mysql tables. The number
of the advertisements are increasing and so do the server's overhead.
Some times I can
Does repair table work in this case?
--- Logan, David (SST - Adelaide)
[EMAIL PROTECTED] wrote:
Hi Vicki,
If you have a backup of the .MYD file, you should be
able to copy this
over the existing one and run myisamchk -r to
rebuild the index.
Regards
David Logan
Database
Hello.
The complete answer on your question you can receive at [EMAIL PROTECTED]
S?rgio Almeida [EMAIL PROTECTED] wrote:
Greetings!
I have a question about MySQL licences. I'm developing a web application
for my customer to install and use on his local network (I use PHP to
Hello.
You should find the clues in the error log, which is usually located in the
data directory.
See:
http://dev.mysql.com/doc/mysql/en/starting-server.html
Mohsen Pahlevanzadeh [EMAIL PROTECTED] wrote:
Dears,I have slackware10.I install it completely.
But when i use
Hello.
See:
http://dev.mysql.com/doc/mysql/en/binary-log.html
Philippe de Rochambeau [EMAIL PROTECTED] wrote:
[-- text/plain, encoding 7bit, charset: US-ASCII, 25 lines --]
Hello,
my /var/lib/mysql directory contains many -bin.xxx files, some of
which date back to
Frederic Wenzel wrote:
On Tue, 25 Jan 2005 08:44:45 -0500, Michael Stassen
[EMAIL PROTECTED] wrote:
I suspect mysql is doing the DISTINCT before the ORDER BY. One of the
reasons I avoid DISTINCT when possible.
Isn't this supposed to be correct? Ordering has to take place as the
very last
Thanks for your reply Brent. It was really useful.
Looks like Opteron would be a good choice since there
wont be several multiple queries at the same time but
instead we will be happy if the single query runs
fast. You had mentioned adding more RAM would help,
how much RAM would be ideal ? Does
[EMAIL PROTECTED] :
When use query with 'like' condition,it would cost too much time.
Mysql is using innodb structure ,but not myisam.
We haven't test how diff between innodb myisam.
But now the performance is too low.
We plan to separate the table group by date or specified flag.
It seems
Dear Scott Haneda:
Thx.
I also try add the key for
'server_name',it cost 3 hours,but it still not yet
completed.
For some reason, wehave broken adding
key process. _
We now engage on spliting table, hope this
45 matches
Mail list logo