hi all,
I've searched a bit, but didn't find any documentation on how to use unicode in mysql
4.0.14 or 4.0.X. Any ideas or links?
Thanx in advance
Nitin
I am running mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)
on redhat 9. I have defined a simple database as follows:
DROP DATABASE IF EXISTS xhistory;
CREATE DATABASE xhistory;
USE xhistory;
CREATE TABLE category
(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
parent_id INT,
Hi Dean,
If I'm not mistaken, it looks like you are just joining the two tables
(list_rank and entry) and not specifying which matching records you want
(with a where... clause), so mysql is matching each row in one table with
each row in the other table. That will be a HUGE result set, so it
Hi Dean,
I have populated the database, which has 6319 records in the list_rank
table
and 2472 records in the entry table. Everything looks fine, and I can
easily
do the simple queries such as:
mysql select * from list_rank;
However, when I run the following simple join, mysqld seems
Hi all,
Platform RH linux on Dell with MySql 4
I changes the directory to where the data file was picked up from to a symbolic link
and now get the error
Can't get stat of '/home/test/data_in/TEST.TXT' (Errcode: 13)
So all I did was to change ~test/data_in to a sym link to ~txn/data_in
[EMAIL PROTECTED] wrote:
Description:
The included sql test script (output of mysqldump 10.2 (create table statement and
insertion of 250 records into this table) with added check for table integrity)
results in corrupted table and error message 'Found key at page 36864 that points
Curley, Thomas [EMAIL PROTECTED] wrote:
Platform RH linux on Dell with MySql 4
I changes the directory to where the data file was picked up from to a sy=
mbolic link and now get the error
Can't get stat of '/home/test/data_in/TEST.TXT' (Errcode: 13)
So all I did was to change
Hi all !
I have two systems.
one with mysql-version: 3.23.37
other with mysql-version: 3.23.58
now i want to take the backup of 3.23.37 data and copy to 3.23.58 ...
i know i can take backup using mysqldump command ... and then copy using mysql
commands
but as mysql create folder for
SQL
I have the same situation.
I set skip-name-resolve in my.cnf.
But sometimes mysqld get all CPU.
I can't notice strong dependences between name resoving and mysqld stuped.
Hello,
Most of the time, MySQL 4.0.16 runs absolutely fine on my FreeBSD 4.9
system. However, today, unexplicably,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Binay --
Saw your post over in php-general but it's better over here :-)
...and then Binay said...
%
% Hi all !
Hi!
%
% I have two systems.
% one with mysql-version: 3.23.37
% other with mysql-version: 3.23.58
OK.
%
% now i want to take the
I have just moved from MS Access to MySQL, I haven't really got going
yet, and I am a little confused at how I interact with a db created in
MySQL. In the past I have always kept my database in its associated
website folder within wwwroot. However, I have been advised to keep it
in
Hello,
I have a simple table test like
create table test (value varchar(10));
in witch I have insert two lines:
insert into test values('bla');
insert into test values('BLA');
The first think is that I cannot add a primary constraint on test because
On Friday 28 November 2003 14.51, Lemasson Sylvain wrote:
Hello,
Hi
The first think is that I cannot add a primary constraint on test because
Mysql do not make the difference between 'bla' and 'BLA'. It is case
insensitive. I have the same problem when I do: select * from test where
Sorry about the double posts...
But I forgot something...
On Friday 28 November 2003 14.51, Lemasson Sylvain wrote:
Can something be done so that mysql be case sensitive ?
If you only need case-sentivitity on selects read this:
http://www.mysql.com/doc/en/Case_Sensitivity_Operators.html
The
First off, I'd like to say hello. I just signed up for the list today.
I'm having some weird things happen on my slave server. I'll give more
details in a second, but to sum it up, its creating thousands of
'host-relay-bin' files and the 'host.err' file is getting filled with
what looks like
Here's my situation. I'm implementing radiusd on a solaris box using a
mysql database that's on a remote windows host. I've managed to get a
user authenticaed (still with the CLID unknown message, but I'll move
on. Hope that's OK to do.) I had added that user manually from a mysql
command
Hello
I recently downloaded 4.1beta
when i run the DB initialisation utilities I get
D:\MySQL\mysql\binmysqld-opt --skip-grant-tables
031128 16:18:09 Can't find messagefile 'I:\MySQL\share\english\errmsg.sys'
I:\MySQL was my old (now deleted) folder
I suspect that I can set the MySQL path via
Hello,
How can I enable MySQL 4.0.16 log ?
I just compiled and installed it in my RedHat 9.0 system, but I cant see any log
files. I use
default /etc/my.cnf from my-large.cnf.
Sorry, if this question is too newbie, but I cant understand clearly reading MySQL
manual.
Thanks for helping me :)
I created a table as follows:
mysql CREATE TABLE test (
- age INT(3),
- CONSTRAINT CHECK (age 0)
- );
Query OK, 0 rows affected (0.00 sec)
I then inserted -1 into the table, which it shouldn't
have let me do.
mysql insert into test values (-1);
Query OK, 1 row affected (0.00 sec)
mysql
Greetings, my hands on school project is a small real estate database.
I am using MySQL 3.23 without InnoDB, but would like to migrate to 4.x
w/InnoDB at some point.
I would greatly appreciate any feedback on this design.
These are the business rules:
1) 1 matter may have several vendors
Hi,
I created a table as follows:
mysql CREATE TABLE test (
- age INT(3),
- CONSTRAINT CHECK (age 0)
- );
Query OK, 0 rows affected (0.00 sec)
I then inserted -1 into the table, which it shouldn't
have let me do.
mysql insert into test values (-1);
Query OK, 1 row
May be this not the good mailing list. I have recently installed maxdb. I have create
succefully a database instance but when I try to launch it (admin or onlyne mode) I
have a runtime environment error saying I must have a look to the application event
log. Where could I found this apllication
Hi
I am a webdesigner/hosting reseller
my question is this:
I am hosting various different CMS attached to mysql databases and hope
to host more in the future
How many different tables can I safely store in the same database?
I am currently storing tables from three different CMS on the same
Hi
Im a more than a lil confused about how to set up multiple
users for EXTERNAL access to MySQL.
Ive granted permissions to the Local user, but how to I grant permissions
to external users ?
Sincerely,
--
M i l e s
President Toolbox Architect
MagicMiles Software
(413) 374 - 5161
PO Box
How are you starting mysql? as a service? I dont think it keeps a log
file by default.
If you are not starting mysql as a service, start it with the
--log-error=/var/log/mysqld --log-warnings
flags. If you are starting it as a service, add those flags to your
mysql file inside
Dear All
I want to send a MySQL database to a client by email. Which is the best way
to do it?
Michael Johnson
Director
BPEnet Humphrey Consulting Limited
13 Austin Friars London EC2N 2JX
Tel +44(0)870 922 0247
Fax +44(0)1323 419554
email [EMAIL PROTECTED]
URL www.bpenet.net
Also in Dublin
- Subject: Send someone a database
-
- Dear All
-
- I want to send a MySQL database to a client by email. Which is the best
- way
- to do it?
Michael,
I usually just dump the database to a file, zip/rar/arj it and send as a
file attach.
Use mysqldump like this;
mysqldump -u USER -h
michael johnson wrote:
Dear All
I want to send a MySQL database to a client by email. Which is the best way
to do it?
Michael Johnson
Director
BPEnet Humphrey Consulting Limited
13 Austin Friars London EC2N 2JX
Tel +44(0)870 922 0247
Fax +44(0)1323 419554
email [EMAIL PROTECTED]
URL
I would mysqldump it, tar it up and send it as an attachment
(hope it isn't too big.) Make sure to tell him to delete the
illegal line of --- before he tries to import it.
michael johnson wrote:
Dear All
I want to send a MySQL database to a client by email. Which is the best way
to do it?
The Manual does not talk about that problem.
For example I have been forced to no longer use GRANT because it creates a
password with * thing at the beginning.
Instead, when I access the user table directly and use OLD_PASSWORD instead
of using PASSWORD, my clients login with no problem.
It
Hi groups,
does anyone know of a way to use myODBC and connect to MySQL 4.1 using its new
passwords?
When I create a password using PASSWORD( ), I can only login using the MySQL client
(the one that comes with MySQL).
But if I create the password using OLD_PASSWORD( ), I can login from both my
Hi group,
I have a problem that I think is not very serious.
All the MySQL 4.1 binaries I downloaded from the MySQL website appear to be
max versions!!!
Ok, their names are mysqld-nt, mysqld, ... but when I do
SELECT version() I always get something containing a MAX thing.
I remember
We ahve a column in our table that has
new info added each time using a JOIN function.
The data is separated using a : separator.
How does one retrieve this info from the colomn and put it
into list format, or check for duplicates, or do a search
in the column for a certan string.
We use PERL
Hi!
On Nov 27, Director General: NEFACOMP wrote:
Hi groups,
does anyone know of a way to use myODBC and connect to MySQL 4.1 using its new
passwords?
When I create a password using PASSWORD( ), I can only login using the MySQL client
(the one that comes with MySQL).
But if I create
Hi Greg,
Here's my situation. I'm implementing radiusd on a solaris box using
a mysql database that's on a remote windows host. I've managed to get
a user authenticaed (still with the CLID unknown message, but I'll
move on. Hope that's OK to do.)
It's OK. Moreover, since that message is
Use GRANT ___your_permissions on database[s] to 'username'@'%'
IDENTIFIED BY 'his/her password'
% will be used if you don't want to restrict that user on a given host or
network
Otherwise, use 'username'@'host_name_or_ip_address' like
'emery'@'192.168.0.50'
if you omit the @ part, MySQL will
From: Bruce Therrien [EMAIL PROTECTED]
Date: 2003/11/28 Fri PM 01:42:14 CST
To: [EMAIL PROTECTED]
Subject: Retrieving info from a Joined column
We ahve a column in our table that has
new info added each time using a JOIN function.
The data is separated using a : separator.
This
From: Paul Fine [EMAIL PROTECTED]
Date: 2003/11/28 Fri AM 11:14:25 CST
To: [EMAIL PROTECTED]
Subject: Please analyze my project table design
Greetings, my hands on school project is a small real estate database.
I am using MySQL 3.23 without InnoDB, but would like to migrate to 4.x
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi!
...and then [EMAIL PROTECTED] said...
%
...
% I don't know of a DB theory rule that says it's a bad idea to have the same columns
in many tables, but it might make the design more compact to take the common stuff and
put it into one table.
If you are using the Load Data function then it doesn't matter. Load Data turns
indexing off and then rebuilds them at the end. If you are using normal inserts then
add the indexes after the import.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
From: David T-G [EMAIL PROTECTED]
Date: 2003/11/28 Fri PM 03:49:17 CST
To: mysql users [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Please analyze my project table design
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi!
...and then [EMAIL PROTECTED] said...
%
...
% I
Thanks guys. I thought that normalization would refer to redundant info not
necessarily the same column names? I would further see the problem with the
design if say phone_number in the agent table and lawyer table contained the
same data, which of course they won't.
I thought about the persons
How closely does the MySQL Service on Win32 platforms conform to any known
standard for installing/removing services?
I raise the question because the vendor that provides the utility we use to
create our installation package claims that MySQL uses non-standard commands
for installing and
% I don't know of a DB theory rule that says it's a bad idea to have the same
columns in many tables, but it might make the design more compact to take the
common stuff and put it into one table.
Oh, there is, indeed. CF normalization :-)
Well of course, but that begs the question, which
Paul,
Thanks guys. I thought that normalization would refer to redundant info not
necessarily the same column names? I would further see the problem with the
design if say phone_number in the agent table and lawyer table contained the
same data, which of course they won't.
The layout would
Gerald,
How closely does the MySQL Service on Win32 platforms conform to any known
standard for installing/removing services?
I raise the question because the vendor that provides the utility we use to
create our installation package claims that MySQL uses non-standard commands
for
[EMAIL PROTECTED] wrote:
From: Bruce Therrien [EMAIL PROTECTED]
Date: 2003/11/28 Fri PM 01:42:14 CST
To: [EMAIL PROTECTED]
Subject: Retrieving info from a Joined column
We have a column in our table that has
new info added each time using a JOIN function.
The data sample makes me rather
Stefan:
I think you have just reinforced my position ... our contention is that
MySQL works the same way as any other application that installs as a
service.
We have a number of applications (written by our own programming staff) that
all use exactly the same procdure used in MySQL to install
Can CHAR/VARCHAR store strings with nul (ASCII 0) in them? It seems it
can't. [I've used CHAR(2), VARCHAR(2), CHAR(2) BINARY, VARCHAR(2) BINARY].
===
create table t1 (
id int not null primary key,
code varchar(2) not null,
David Garamond wrote:
insert into t1 values (3,char(32));
Record 3, 5, and 7 is rejected due to duplicate value.
++--+--+
| id | length(code) | code |
++--+--+
| 1 |0 | |
| 2 |1 | 0|
| 4 |2 | 0 0 |
| 6 |
In the last episode (Nov 29), David Garamond said:
It seems the string in CHAR/VARCHAR is stored as null-terminated ala
C. But why is record 3 rejected too?
Ugh, never mind. I forgot about the automatic trailing blanks removal
feature. Well, since trailing blanks are always removed, it
If I understand correctly, the MySQL source is available. If you are familiar
with the code that registers/starts/stops services you might want to take a
look at it. You might even try sending that section of the code to the vendor
and challange him to tell you how it is non-standard.
Robert Rowe
From: Stefan Hinz [EMAIL PROTECTED]
Date: 2003/11/28 Fri PM 04:45:24 CST
To: [EMAIL PROTECTED]
CC: David T-G [EMAIL PROTECTED], mysql users [EMAIL PROTECTED]
Subject: Re[3]: Please analyze my project table design
% I don't know of a DB theory rule that says it's a bad idea to have the
Hi again,
I have stored UTF-8 encoded usernames in a table and need a properly sorted
output. I tried with 'ORDER BY Name', but it won't sort extended ASCII
characters correctly by their values but rather by some similarity with
other letters. In my example, the Unicode character starts with a
From: Paul F [EMAIL PROTECTED]
Date: 2003/11/28 Fri PM 04:35:04 CST
To: 'mysql users' [EMAIL PROTECTED]
Subject: RE: Please analyze my project table design
Thanks guys. I thought that normalization would refer to redundant info not
necessarily the same column names? I would further
Hello,
Newbie. Be nice now it is the holidays or Santa will poop in your stocking
:-)
I am running snort. It was working fine.
I installed some other programs that use the mysql also. (can't recall
which or what I may have done) and now on a reboot I get this error :
Nov 27 23:07:06 spiderman
Hi,
I tried to set it in mysqld and it still alphabetize the tables...
my mysqldump syntax is this.
mysqldump -acr c:\backup.sql prism
where prism is the database.
All I wanted to happen is for the the tables to be in order of referential integrity
NOT alphabetical
Heikki Tuuri [EMAIL
57 matches
Mail list logo