Hi, all
Does MySQL support Japanese database name and Japanese table name?
How to enable it?
Thanks and regards
Robert
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello
1.I am having problems in connecting my mySql Control center with
Linux can any one suggest me soln for it.
2. Can anyone suggest me Graphical version of MySql for Linux.
3. Is there any way of connecting Windows mysql clients to Linux
mysql server
if anyone has got some idea do
Gerald,
You can't add constraints referencing indices that don't exist.
Create your indecies first.
Constraints don't reference indexes, they reference columns.
These columns exist. When the table type is MyISAM, the syntax
is accepted. When it's InnoDB - it fails.
(
This schema was originally
Jeremy Zawodny wrote:
On Fri, Apr 04, 2003 at 01:22:39PM +0700, David Garamond wrote:
i found this on my server log:
mysqld-max: raid.cc:160: my_off_t my_raid_seek(int, long long unsigned
int, int, int): Assertion `pos != (~(my_off_t) 0)' failed.
and then mysqld shuts down. i start it again
Adam,
this will not work with fulltext. Non-alphanumeric characters will be
ignored and treated as spaces. There remain some chunks like 10 2 4 and
these are too short (less than 3 characters) and will never be indexed.
Sorry, no way. Except for an ugly hack. You may try to replace dots
between
Delz,
what's the reason to put *.doc into a database? Format of *doc is a PITA
and you can't search it.
Store the path to the file instead along with a copy of it's content in
plain ASCII and run a fulltext index on that. Have a look at wvWare to do
the conversion.
Thomas Spahni
On Fri, 4 Apr
Thorsten,
This is right, but on these columns has to be an index set on before you can create
foreign keys with innodb.
So, create the indexes and AFTER that the foreign keys and it should work : )
Thanks for the clarification !
However, moving the foreign key definitions after the table and
-Ursprüngliche Nachricht-
Von: Ian Hartas [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 4. April 2003 12:33
An: Thorsten Schmidt
Cc: [EMAIL PROTECTED]
Betreff: Re: AW: Re: Schema definition fails when converted to InnoDB
Thorsten,
This is right, but on these columns has to be
yes i know that. How? was my question.
I searched the directories for some sort of actual windows
program but didn't see one, and didn't feel like going into EVERY
directory. See I have no idea where the executables should be because i'm
new to the program. Hiding it in a subdir doesn't
Hi all,
In the following table, I declare ID as a PRIMARY KEY. Is it then
necessary to add the parameters NOT NULL AUTO_INCREMENT?
CREATE TABLE company (
ID INT NOT NULL AUTO_INCREMENT,
name VARCHAR(30),
admin_ID INT,
PRIMARY KEY ID,
INDEX admin_ID,
);
Or can I just declare
YAY! somebody is helping me!!!
This is exactly what i needed. Why isn't it right at
square one in a readme or in the manual? maybe i just missed it but, i
swear i looked and looked!
AWESOME !
thanksand cheers!
~kira
- Original Message -
From: PaT!
To: [EMAIL PROTECTED]
From [EMAIL PROTECTED] Wed Apr 2 17:09:15 2003
At 16:53 -0500 4/2/03, Mike South wrote:
In load testing I noticed that, even though all the queries in the
tests are for the exact same tables, at some point in the test
the Open_files variable (from SHOW STATUS) drops very quickly. Does
anyone
From [EMAIL PROTECTED] Wed Apr 2 17:12:36 2003
In the last episode (Apr 02), Mike South said:
In load testing I noticed that, even though all the queries in the
tests are for the exact same tables, at some point in the test
the Open_files variable (from SHOW STATUS) drops very quickly.
Hi,
Anyone know of a way of pre parsing a *.sql file to make sure that it is
syntactically correct , opposed to having to up load a file and when it
breaks loosing everything after the line with an error on it.
Either that or a way of telling it to carry on after finding an error.
i.e. using
I think it's not a matter of before or after. Simply, a foreign key must
also be defined as a key/index. Which comes first in a CREATE statement
matters not a whit.
PB
-
- Original Message -
From: Thorsten Schmidt
To: Ian Hartas
Cc: [EMAIL PROTECTED]
Sent: Friday, April 04,
You could pre-pend EXPLAIN and see if it generates an error.
--
Nick Arnett
Phone/fax: (408) 904-7198
[EMAIL PROTECTED]
-Original Message-
From: Jerry [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 5:46 AM
To: [EMAIL PROTECTED]
Subject: Pre parsing
Hi,
Anyone know
Mark,
Your suggestion was right on. I found a way to get Zeos to reuse existing connections
and the problem went away. It had been suggested that the problem was caused by
WinXP's writeback cache and I was struggling to figure out how I was going to ever
resolve that one.
Thanks for your
Howdy all!!
I have installed a mysql server release 4.0.12-log on Linux i686. I used the source
distribution.
When I executed mysql_install_db for creating db appeared a error message which it
said:
Warning: Ignoring user change to 'mysql' because the user was set to 'mysql' earlier
on the
HELP!
Description:
Try starting daemon
[EMAIL PROTECTED] mysql]# ./bin/safe_mysqld 38;
Starting mysqld daemon with databases from /usr/local/mysql/var
030404 11:32:37 mysqld ended
Trace:
[EMAIL PROTECTED] mysql]# cd var
[EMAIL PROTECTED] var]# ll
total 36
-rw-rw1 mysqlroot
Is there any way to combine MySQL commands? For example I want to
display the columns and indexes from a table. I can issue the two
commands on one line as
show fields from dbname.tblname; show index from dbname.tblname;
Is there some way to say
show fields and index from
Which command are you running?
Martin
- Original Message -
From: ruchir dhar dwivedi [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 04, 2003 1:22 AM
Subject: control center
Hello
1.I am having problems in connecting my mySql Control center with
Linux can any one
On Friday 04 April 2003 18:20, Jason Joines wrote:
Is there any way to combine MySQL commands? For example I want to
display the columns and indexes from a table. I can issue the two
commands on one line as
show fields from dbname.tblname; show index from dbname.tblname;
Is
On Friday 04 April 2003 11:22, ruchir dhar dwivedi wrote:
Hello
1.I am having problems in connecting my mySql Control center with
Linux can any one suggest me soln for it.
What exactly problem do you have? Be more detailed ..
2. Can anyone suggest me Graphical version of MySql for
On Friday 04 April 2003 11:19, Li Robert wrote:
Does MySQL support Japanese database name and Japanese table name?
How to enable it?
Section 6.1.2 Database, Table, Index, Column, and Alias Names:
http://www.mysql.com/doc/en/Legal_names.html
A name may consist of alphanumeric
On Friday 04 April 2003 15:37, Grégoire Dubois wrote:
In the following table, I declare ID as a PRIMARY KEY. Is it then
necessary to add the parameters NOT NULL AUTO_INCREMENT?
CREATE TABLE company (
ID INT NOT NULL AUTO_INCREMENT,
name VARCHAR(30),
admin_ID INT,
On Friday 04 April 2003 04:02, you wrote:
The logon now works after DELETE FROM user WHERE user=
It's still crashing when a remote logon is attempted. The copy of the
modified my.cnf file is attached.
What exactly OS do you use? What version of MySQL server do you use? Did oyu
install MySQL
On Friday 04 April 2003 12:19, Ian Hartas wrote:
You can't add constraints referencing indices that don't exist.
Create your indecies first.
Constraints don't reference indexes, they reference columns.
These columns exist. When the table type is MyISAM, the syntax
is accepted. When it's
David Garamond wrote:
On Fri, Apr 04, 2003 at 01:22:39PM +0700, David Garamond wrote:
i found this on my server log:
mysqld-max: raid.cc:160: my_off_t my_raid_seek(int, long long
unsigned int, int, int): Assertion `pos != (~(my_off_t) 0)' failed.
and then mysqld shuts down. i start it again
On Fri, Apr 04, 2003 at 09:10:50AM +0200, Jocelyn Fournier wrote:
Hi,
Or simply use perror 28 :)
[EMAIL PROTECTED]:~$ perror 28
Error code 28: No space left on device
Golly, I had no idea that such a utility came with the MySQL
distribution.
Kinda handy.
Learn something new
Victoria Reznichenko wrote:
On Friday 04 April 2003 15:37, Grgoire Dubois wrote:
In the following table, I declare ID as a PRIMARY KEY. Is it then
necessary to add the parameters NOT NULL AUTO_INCREMENT?
CREATE TABLE company (
ID INT NOT NULL AUTO_INCREMENT,
name VARCHAR(30),
In the last episode (Apr 04), Dan Rossi said:
Create a compound index on either (time, source_ip) or (source_ip,
time). Mysql cannot use two indexes on one table.
woah what are you saying here , that it cant have multiple indexes
within a table ?
You can; MySQL will only use one per table
Grgoire Dubois wrote:
Victoria Reznichenko wrote:
On Friday 04 April 2003 15:37, Grgoire Dubois wrote:
In the following table, I declare ID as a PRIMARY KEY. Is it then
necessary to add the parameters NOT NULL AUTO_INCREMENT?
CREATE TABLE company (
ID INT NOT NULL AUTO_INCREMENT,
name
Victoria Reznichenko wrote:
On Friday 04 April 2003 18:20, Jason Joines wrote:
Is there any way to combine MySQL commands? For example I want to
display the columns and indexes from a table. I can issue the two
commands on one line as
show fields from dbname.tblname; show index from
It seems this issue will be fixed in 4.0.13, I filed a bug and it was
closed with this report:
Sinisa Milivojevic:
Yes, this is a known problem.
It is already fixed in 4.0.13, which will come out this month.
This is a patch:
= sql/sql_update.cc 1.79 vs 1.80 =
***
[EMAIL PROTECTED] wrote:
yes i know that. How? was my question.
How...what? How to setup MySQL? How to setup PHP? How to read the
manual? How to work your own computer? You ask vague questions, and
can only expect vague answers back.
and the manual have you seen how long that is?
The -f (force) flag will tell your script to continue even if it encounters
an error.
http://www.mysql.com/doc/en/mysql.html
-ms
-Original Message-
From: Jerry [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 5:46 AM
To: [EMAIL PROTECTED]
Subject: Pre parsing
Hi,
Anyone know of
I do not understand why people have to get hard on other people just because they ask
a question. If you do not a helpful thing to say well do not reply. The reason why
people ask is because there are looking for shortcuts that are known by those who have
been around and it is great because
We have a perl cgi program that refreshes every 45 seconds and connects
to a mysql database to update records, overtime. This could have 300
people using this same process, because we are queuing user in the
database and when they reach queue position 1 and the resources are low,
they are
not sure what the hell your problem is, but if you don't want to help then don't.
complaining that i need help when 99% of the manual refers to remost server usage
isn't really necessary.
all i need to do is make a connection between dwmx and mysql. that's it.
please don't respond to
Hi there,
I have some experience with SQL, but I'm drawing a blank on this one. I have a table
with these fields:
Location
Unit
StartDate
StopDate
I want to construct a SELECT statement to get to a report that looks something like
this:
Location1Location2 Location3 ...
Date1
Thanks for the info, i've searched and searched the mysql site for info but not found
a lot, except people who got the error 1067 code helping each other. i noticed a NOT
FOUND under ODBC so i installed myodbc, but now i get the NOT FOUND along with the
driver info underneath it, so i'm not
This is quite complicated with SQL. However, Microsoft Excel has excellent
tools for creating crosstabs exactly like this.
-ms
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 9:56 AM
To: [EMAIL PROTECTED]
Subject: Query formulation
Hello,
I would like to know if MySQL allows for record locking. Also, what other
security features does MySQL have?
Thank you.
Cynde
Kira,
Let's take it a step at a time.
First, make sure that your MySQL is running. Have you started the server
with \mysql\bin\winmysqldmin.exe? Look for a traffic light in your system
tray, and the green light showing.
Now, try to connect using the \mysql\bin\mysql.exe command line tool. By
ok i'll try it. it didn't work before i installed myodbc but in the help screen
(winmysqladmin.exe) it shows the database panel with right click create database -
that isn't working but maybe it doesn't matter.
thx!
- Original Message -
From: Bryan Koenig
To: [EMAIL PROTECTED]
chown -R mysql /usr/local/mysql
alain POULET wrote:
HELP!
Description:
Try starting daemon
[EMAIL PROTECTED] mysql]# ./bin/safe_mysqld 38;
Starting mysqld daemon with databases from /usr/local/mysql/var
030404 11:32:37 mysqld ended
Trace:
[EMAIL PROTECTED] mysql]# cd var
[EMAIL
They are only sending one. It is proper form when replying to reply to both
the sender and the list. Since you are on the list you are getting the list
copy as well as the copy sent directly to you.
I think their problem was the fact that you admitted you were just asking
(vauge) questions
Here's a link to an article that discusses how to set up cross-tab queries.
http://www.devshed.com/Server_Side/MySQL/MySQLWiz/page1.html
-Original Message-
From: Michael Shulman [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 12:08 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
This is more of a DreamWeaver question than a MySQL and you will
probably have better luck getting an answer from a DreamWeaver list
or forum.
Have you tried searching the DreamWeaver Help or manuals?
A quick search for MySQL provided me with the following topics:
Creating the MySQL database
If the perl program is a daemon, than it can keep the connection open.
If you are running the same perl program many times, it will have to
make the connection each time.
Kory Wheatley wrote:
We have a perl cgi program that refreshes every 45 seconds and
connects to a mysql database to update
From the fine manual:
4.2 General Security Issues and the MySQL Access Privilege System
MySQL has an advanced but non-standard security/privilege system. This
section describes how it works.
http://www.mysql.com/doc/en/Privilege_system.html
Brian McCain
- Original Message -
From:
Read the section of the manual on table types.
Different table drivers offer differnt types of locking.
ISAM and MYISAM don't,
but BDB and INNODB types offer different types of row and or page locking.
[EMAIL PROTECTED] wrote:
Hello,
I would like to know if MySQL allows for record locking.
actually i know how to make connections in dreamweaver and since mysql won't create
databases, i kinda figured i should start there. thanks for your help. ---notice
correct punctuation.
- Original Message -
From: Jeff Shapiro
To: [EMAIL PROTECTED] ; [EMAIL PROTECTED]
Sent: Friday,
actually her problem has nothing to do with me. i wasn't vague. i said right out
what i need to do. a list is a bunch of threads, you're supposed to follow them, not
take things out of context.
and as far as putting time into this, what you think i didn't run any searches or
anything?
What do you mean by mysql won't create databases? -- notice stupid
'?' inside of quotes when I am not quoting a question.
[EMAIL PROTECTED] wrote:
actually i know how to make connections in dreamweaver and since mysql won't create databases, i kinda figured i should start there. thanks for
We have a perl cgi program that refreshes every 45 seconds and connects
to a mysql database to update records, overtime. This could have 300
Cache the page for 45 seconds. Subsequent hits see the output from the 1st
request and do not require a DB connection. Release the cache after 45
you know what? i'm sorry.
i'm so sorry for asking a question. i really thought i'd be dealing with adults.
i suppose Gerald here has never asked a question. he was born knowing everything
about everything. and he has never needed help with anything at all. nothing has
ever confused him or
On April 1, 2003 07:50, Klepetka, Tom wrote:
Hi -
I would like to access a mysql database server from a NUMA-Q Sequent
platform running Dynix/ptx v4.5.2. Does any of mysql's connectivity
products (Connector/ODBC, Connector/C++) run under this platform/OS?
I am afraid that I don't know.
Hi, all...
I've recently configured Courier, postfix and a mysql
database, on Redhat 8.0, and I thought I had it set up
properly (I've followed a few online procedures,
including the one at
http://kirb.insanegenius.net/postfix.html). Postfix
is now delivering mail fine. However, I can't get
For the love of anything holy, take the pissing match off list!
Christopher Mann
Systems Administrator
Stonebridge Bank
610.235.1515
[EMAIL PROTECTED]
gerald_clark [EMAIL PROTECTED] 04/04/03 02:26PM
What do you mean by mysql won't create databases? -- notice stupid
'?' inside of quotes
[EMAIL PROTECTED] wrote:
actually i've put a lot of time into this and found nothing that helps. the mysql site is a huge pile of code, and i can't find anything that has to do with setup on one's own computer using win2k, or anything about winmysqladmin.
You obviously didn't:
At 13:19 04/04/2003 -0500, [EMAIL PROTECTED] wrote:
Hi,
ok i'll try it. it didn't work before i installed myodbc but in the help
screen (winmysqladmin.exe) it shows the database panel with right click
create database -
Sorry about that option which was disable because used an older
API
Can mysql handle multiple threads where three or more people can be
reading and writing to the same database at the same time?
--
Kory Wheatley
Academic Computing Analyst Sr.
Phone 282-3874
#
Everything must point to him.
--
MySQL General Mailing List
I have recently purchased the lease of a dedicated mySQL server running on
linux.
I normally use a GUI tool to modify databases etc. But now I need to create
them aswell. Can anyone recommend a free tool to do this to run on Windows
and connection to a mySQL server running on linux.
Thanks
On April 4, 2003 05:40, [EMAIL PROTECTED] wrote:
YAY! somebody is helping me!!!This is exactly what i needed. Why isn't
it right at square one in a readme or in the manual? maybe i just missed
it but, i swear i looked and looked!
AWESOME !
thanks and cheers!
Hello Kira,
There are
www.sqlyog.com
Absolutely the best tool I've used to work with mysql. And a VERY responsive
development team.
=C=
- Original Message -
From: Neil Tompkins [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 04, 2003 1:49 PM
Subject: mySQL GUI
I have recently purchased the
MySQLCC is pretty popular, and it's probably the easiest to set up.
http://www.mysql.com/products/mysqlcc/index.html
I like MySQLTool though...it's clean and easy to use.
http://www.dajoba.com/projects/mysqltool/index.html?_of=,10,20,14
- Original Message -
From: Neil Tompkins [EMAIL
MySQL CC from www.mysql.com is pretty good.
Tyler
- Original Message -
From: Neil Tompkins [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 04, 2003 1:49 PM
Subject: mySQL GUI
I have recently purchased the lease of a dedicated mySQL server running on
linux.
I normally
I help people every day, and have been helping people here for over 5 years.
Your attitude is not going to help you.
[EMAIL PROTECTED] wrote:
you know what? i'm sorry.
i'm so sorry for asking a question. i really thought i'd be dealing with adults.
i suppose Gerald here has never asked a
I've got 3 databases running DB1, DB2, DB3.
DB1 version 3.23.41
DB2 version 3.23.41
DB3 version 3.12.51
DB1 is the master for DB2 in replication
I'm trying now to set up DB3 to replicate from DB2
So in essence DB1 - DB2 - DB3
I ran through the instructions for setting up replication of DB2 to
Following up to my own question. Some more information.
SLOW: Create unique compound index on a table, do a query.
FAST: Create same index, only non-unique, do a query.
FAST: Do slow method, but ANALYZE TABLE before doing query.
It looks like the key-distribution information that's stored by
Can anyone tell me what I am doing wrong or need to do with the following.
Using MySQL 4.0.11 gamma, win 2000, j2sdk1.4.1_01 and Tomcat 4.1.
Under mysql, the statement: GRANT ALL PRIVILEGES ON *.* TO
[EMAIL PROTECTED] IDENTIFIED BY 'javadude' WITH GRANT OPTION;
Produces this error: ERROR
On Fri, Apr 04, 2003 at 12:46:58PM -0700, Kory Wheatley wrote:
Can mysql handle multiple threads where three or more people can be
reading and writing to the same database at the same time?
Yes.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] |
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
abjett wrote:
| Can anyone tell me what I am doing wrong or need to do with the following.
|
| Using MySQL 4.0.11 gamma, win 2000, j2sdk1.4.1_01 and Tomcat 4.1.
|
| Under mysql, the statement: GRANT ALL PRIVILEGES ON *.* TO
| [EMAIL PROTECTED]
Bruce Feist wrote:
Grgoire Dubois wrote:
Victoria Reznichenko wrote:
On Friday 04 April 2003 15:37, Grgoire Dubois wrote:
In the following table, I declare ID as a PRIMARY KEY. Is it then
necessary to add the parameters NOT NULL AUTO_INCREMENT?
CREATE TABLE company (
ID INT NOT NULL
(snip)
Does creating a primary key
on an int immediatly involve this one to be not null, and to
auto-increment?
NOT NULL - yes, but if you want to have AUTO_INCREMENT column you
should declare it as AUTO_INCREMENT.
Thank you very much for your reply.
But I read that a PRIMARY KEY
HI Thomas,
Thanks for the reply. Well actually I don't need to search the content of
the blob data stored in mysql. I'm just going to create a description w/ a
couple of text box that describes the file uploaded.
Regards,
Delz
- Original Message -
From: Thomas Spahni [EMAIL PROTECTED]
MySQL is AMAZING...
I'm very interest with replication on MySQL, and after I read in the manual_doc I want
to try MySQL-4.x.x. But until now this version not yet available stable release
(maybe).
How stable release [recomended] can I use for replication on version 4.0.0 ??
Why MySQL only
SQLyog at http://www.webyog.com/sqlyog is the best
Windows GUI I have seen. Its FREE, small, compact and
extremely fast when working with remote server.
Best I have seen till data.
Karam
--- Neil Tompkins [EMAIL PROTECTED] wrote:
I have recently purchased the lease of a dedicated
mySQL
OK, I'm closing this thread, as Dan has been the only one who has provided a
link to exactly what I was looking for.
I still cant post through Google Groups, but at least I dont have to
download 40 email messages a day now.
http://www.gmane.org
Thanks Dan!
Dan Nelson [EMAIL PROTECTED] wrote in
Hi all,
I'm currently logging page requests with the following table:
CREATE TABLE counters_hits (
pid tinyint(3) unsigned NOT NULL default '0',
stamp varchar(30) NOT NULL default ''
) TYPE=MyISAM;
In other words, for ever page hit on my site, I'm recording the unix
timestamp page ID.
81 matches
Mail list logo