Orr,
Friday, July 26, 2002, 12:13:17 AM, you wrote:
O It's my understanding that MySQL will only use one index per table on a
O given query. For example...
O SELECT * FROM HUGE_TABLE
O WHERE col1 = val1
O AND col2 val2
O AND col3 val3 ;
O If col1, col2, and col3 are indexed the query can
Hi,
I would like to get the Chech complex character set.
Where can I find it?
Thanks,
Daniel
SQL
If you need a Windows ASCII dump, is little lower.
http://pisma.webz.cz/ is link for download some czech fonts -
(I think, that is already needed too for right mapping)
Chris,
Thursday, July 25, 2002, 11:52:44 PM, you wrote:
CD Is there any plane to implement the REFERENCES function for foreign keys
CD on the alter table command.or is it implemented? If it is what
CD version of mysql?
If you mean problem with ALTER TABLE and CREATE INDEX wich removed all
Hi,
I've read in the MySQL manual that
If the sorting rules for your language are too complex to be handled with
the simple sort_order[] table, you need to use the string collating functions
I also read that the best documentations about how to use this feature are
the already implemented
At 13:24 +0100 7/26/02, Ian Fieldhouse wrote:
Hi,
Is anybody else having a problem using the MySQL client with Mac OS X 10.2
(Jaguar: Build 6C106)? When I try to connect to the server on 'localhost' I
get the following:
dyld: ./bin/mysql Undefined symbols:
./bin/mysql undefined reference to _BC
btw folks, not wanting but already hijaking the thread:
I have a table with one timestamp(14) column and several other varchar(5)
columns. How do I select rows from that table using two strings formated as
MMDDhhmmss and using SQLBindParameter? I´m more interested in how
setup the
What about running multiple mysql in console mode instead of service?
Another concern would be how to tell each mysql to read a specified config
file instead of having them all read the same one in the window\winnt
folder.
Regards,
Michael
- Original Message -
From: Bhavin Vyas [EMAIL
Does anyone know of an older version of MySQL that runs on DOS
(or on Windows 3.x)?
...
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
I automated the MYSQL start up process using the setup command. Everything
works fine except that I noticed safe_mysql is the daemon running, shouldnt
this be mysqld or mysql.server? Im completely lost here, and I feel running
Safe_mysql is a major security issue? Anyone's thoughts on this?
Hello!
Nitesh Divecha wrote:
Hello All,
I need help with tables. I have created my table with some attributes in
it.
I need to modify my table attributes, can any one help me with the
modify command or can give me the short cut to the web.
Example:
Mysql create table test(ID int(4), Name
Diana Soares wrote:
Hi, just sending a reply in case that someone else has the same problem.
I solved the problem by decreasing the key-buffer from 320M to 288M.
We tried that among many other things. It turns out that their is some
kind of problem related to temporary tables. MySQL AB is
There appears to be a bug in the Win32 version of Mysql 2.23.49. When
I try to read data in (using the load data infile syntax) that
contains null values they are converted to 0s. The fields in question
are numeric, nulls allowed, default value is NULL. I tried coding
them blank, \N and NULL
Hi, just sending a reply in case that someone else has the same problem.
I solved the problem by decreasing the key-buffer from 320M to 288M.
On Wed, 2002-07-03 at 12:24, Diana Soares wrote:
Hi,
I have 2 machine dual-processor Pentium III, with 1G of memory.
They have the same software,
Ç×°®µÄÅóÓÑ£º
ÄúºÃ£¡
ÕâÊÇÀ´×ÔÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾µÄÎʺò£¬¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£Èç¹ûÄúÒÑÓС¢»òÕý×¼±¸½¨ÉèÍøÕ¾£¬
ÄÇôÇëÄú²Î¹ÛÒ»ÏÂÎÒÃǵÄÍøÕ¾http://www.onway.net£¬ÏàÐÅÄܶÔÄúÓÐËù°ïÖú¡£
ÎÒÃÇΪÄúÌṩµÄÒÔÏÂÍøÕ¾¿Õ¼ä¶¼¿ÉÖ§³ÖÊý¾Ý¿â£¨CGI¡¢PHP¡¢MYSQL¡¢SQL¡¢ACCESS¡¢ASP¡¢JSP£©£¬È«Ãæ
True, MySQL server does not support several instances on the same windows
machine.
For comparison, It is possible to install multiple instances of MS SQL
Server 2000 !!
Xavier
-Message d'origine-
De : Bhavin Vyas [mailto:[EMAIL PROTECTED]]
Envoyé : vendredi 26 juillet 2002 04:09
À :
ok, i turns out I have lots of sleeping connections. This is because I'm
using PHP's mysql_pconnect which opens persistent connections so the next
connect (on the same process) will reuse the connection. this does appear
to improve performance overall, which is good. but it seems to leave lots
In the last episode (Jul 25), Darren Young said:
I am in the process of testing out the 4.0 series of MySQL and am having
some problems when I try to install the php-mysql RPM. The machine is a
RedHat 7.2 i386 box with all current patches.
I pulled down the source RPM for 4.0.2-2 and
On Fri, 2002-07-26 at 18:43, Mike Wexler wrote:
Diana Soares wrote:
Hi, just sending a reply in case that someone else has the same problem.
I solved the problem by decreasing the key-buffer from 320M to 288M.
We tried that among many other things. It turns out that their is some
Why should I close port 3306 used by mysql? What would happen if a hacker use
this port?
Anderson Pereira Ataides
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi,
I am not a root. Our server is at ISP and I am trying to install mysql on
our shared server. They have provided one user id and password with which I
can access it. I also do not know whether mysql previously exists or not as
mysql.sock is existing. (how to find that ?)
I checked the
Hello all,
We're experiencing a bit of difficulty replicating from a 4.0.2 master on
Linux to a 4.0.2 slave on Linux. Most of our tables, including the one
that's giving us headaches are InnoDB. My colleague encountered the
problem, his description follows:
It seems to barf on auto_increment
Check the mySQL REPLACE syntax... that's what you need.
-Message d'origine-
De : Corey Wallis [mailto:[EMAIL PROTECTED]]
Envoyé : vendredi 26 juillet 2002 11:17
À : [EMAIL PROTECTED]
Objet : Fw: Complex SQL assistance
Peoples,
I'm currently trying to work out if this is possible by
Diana Soares wrote:
On Fri, 2002-07-26 at 18:43, Mike Wexler wrote:
Diana Soares wrote:
Hi, just sending a reply in case that someone else has the same problem.
I solved the problem by decreasing the key-buffer from 320M to 288M.
We tried that among many other things. It
In the last episode (Jul 25), [EMAIL PROTECTED] said:
what sthe deal with having max 32 keys in InnoDB tables in MySQL?
the is ABSOLUTELY NO documentation i can find anywhere that states
anything about a 32 key max in InnoDB tables.
Please, Please, Please, Please, Please, Please,
Thank you for all the replies to my MySQL question above. They have been most
helpful.
Bill.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
I have just begun playing around with MySQL and I have a question about
indexing on dates.
Part of our system is a work flow management system and we have a table for
all documents that we receive. Each document record has several dates to
indicate when various processing functions have been
Description:
It is impossible to create column having ENUM() type. Not sure if
it is a bug as it doesn't make too much sense but at least error
message is very wrong.
How-To-Repeat:
mysql create temporary table test ( test enum () );
ERROR 1074: Too big
I am in the process of testing out the 4.0 series of MySQL and am having
some problems when I try to install the php-mysql RPM. The machine is a
RedHat 7.2 i386 box with all current patches.
I pulled down the source RPM for 4.0.2-2 and rebuilt the RPM's with debug
enabled then installed all the
Hi.
On Fri 2002-07-26 at 11:03:26 +0300, [EMAIL PROTECTED] wrote:
Hello Benjamin,
Why after TRUNCATE TABLE data file with indexes not freed ?
BP See http://www.mysql.com/doc/A/d/Adding_and_removing.html (2nd paragraph)
BP and
Hello!
gregor gede wrote:
hi what's wrong with this query? is it because mysql
doesn't support multiple table selection? I use
mysql-3.23.49a.
SELECT Buku.Judul_Buku, Buku.ISBN, Buku.Kolasi,
Buku.Abstraksi, Pengarang.Pengarang,
Penerbit.Penerbit, Jenis_Buku.Jenis, Subjek.Subjek
FROM Buku,
Hi.
First, when you start an independend question, please start a new
thread, but at least change the subject accordingly.
On Fri 2002-07-26 at 11:07:17 +0300, [EMAIL PROTECTED] wrote:
[...]
If table recreated from table.frm why it not recreate indexes file?
Because this is the documented
Have you tried SELECT MAX(`timestamp`) FROM minutely_inbound_handovers;?
-JF
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 26, 2002 6:48 AM
To: [EMAIL PROTECTED]
Subject: max() null bug with funny column name
Description:
You expect a
Hi,
When I open a link table in access (that is opening a table in a mySQL
dbase on our server), it will not allow me to alter the data.
It keeps telling me that someone else is trying to access or alter the
data and that I have to Copy to Clipboard or Drop Changes. I know
100% that I am the
I am just getting started with MySQL and one of the first things I was
trying is converting one of my larger tables to MySQL to see what kind of
performance I would get from some standard queries that I run against it.
I built the table and created some indices that I thought would boost the
Hi,
If you want the last date, isn't it just:
SELECT clientid,max(datedone)
FROM table_name
WHERE done = 'true' and x = ''
GROUP BY clientid;
? Hope it helps,
On Fri, 2002-07-26 at 08:27, Nixarlidis Aris wrote:
Hi,
I face the following situation.I have a number of clients-each with a
Hi.
On Fri 2002-07-26 at 08:34:51 -0400, [EMAIL PROTECTED] wrote:
[...]
set the dates up as DATETIME fields. However, indexing on these forces me to
specify a date and time or a range. i.e.
where ReceivedDate = '2002-07-26 08:15:05'
or
where ReceivedDate = '2002-07-26' and
Hi,
Why do you think this query is wrong ?
Does it give a message error ? Doesn't return what you expected ?
We can't help if you don't tell us what the problem is.
On Fri, 2002-07-26 at 03:23, gregor gede wrote:
hi what's wrong with this query? is it because mysql
doesn't support multiple
You have posted this sevaral times, and several people have responded.
If you are not at the console, and can't use the GUI tools, you will
have to use
terminal mode tools, or edit the user and group files yourself.
This is really not a MySQL problem.
You need to create a new user and group for
mysql doesn't own the table or database.
Jeff Dyer wrote:
I am developing a new application using MySQL instead of MS SQL Server 2000,
I have just shelled out for the Microolap Delphi SQL DIrect Access
Components, having successfully converted an existing SQL Server database to
MySQL.
HOWEVER,
Hi,
I face the following situation.I have a number of clients-each with a
unique clientid.I have a table with some records -one after
the other in time order(datedone field) with actions checked as 'done' or
not 'done',
in the 'done' field which is either true or false.What I want to to, is
Description:
You expect a little goophiness when you set up a column named timestamp.
This odd behaviour I consider a bug.
How-To-Repeat:
show fields from minutely_inbound_handovers;
+-+--+--+-+-++
|
Hi.
On Fri 2002-07-26 at 09:46:39 -0500, [EMAIL PROTECTED] wrote:
[...]
Problem is that the sql version I am running does not support sub-queries.
MySQL does not support sub-queries in any version yet.
Is there another way of getting around the following situation to wirte a
query so that
At 9:16 -0500 7/26/02, Mike Grover wrote:
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 26, 2002 9:01 AM
To: Mike Grover
Subject: Re: Named Pipes in MySQL
Your message cannot be posted because it appears to be either spam or
simply off topic to
43 matches
Mail list logo