RE: Named Pipes in MySQL

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

Re: mysql sub query

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 th

max() null bug with funny column name

>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; +-+--+--+-+-++ | Fi

Query problem..

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 to

Re: Error updating table structure.

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. > >HOW

Re: groupadd

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

Re: inner join query don't work

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 t

Re: Newbie Index Question

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 Rec

Re: Query problem..

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

Index Corruption

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 perf

MyODBC error - not allowing me to alter data in Access link table (to MySQL dbase)

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 t

RE: max() null bug with funny column name

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: > >

Re: Re[2]: TRUNCATE TABLE

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 beh

Re: inner join query don't work

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 Bu

Re: Re[2]: TRUNCATE TABLE

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 >http://www.mysql.com/documentation/mysql/bychapter/

4.0.2 libmysqlclient.so.10 not found

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

Cannot create column having ENUM("") type

>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 b

Newbie Index Question

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 co

Re: Data Entry for a Newbie

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

Re: 32 key max in InnoDB

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,

Re: Mysqld crash

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 am

RE: Complex SQL assistance

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 SQL

4.0.2 Replication problem w/ AUTO_INCREMENT columns?

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

Re: Facing some problem in installation

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 mysq

security

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/

Re: Mysqld crash

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 i

Re: 4.0.2 libmysqlclient.so.10 not found

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 re

Re: max_connections recovery

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

RE: Do you run multiple servers on WIndows?

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 À : Paul

Îȶ¨Ñ¹µ¹Ò»ÇÐ---ÖÐСÆóÒµÉÏÍøµÄ¾ø¼Ñ·½°¸!

Ç×°®µÄÅóÓÑ£º ÄúºÃ£¡ ÕâÊÇÀ´×ÔÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾µÄÎʺò£¬¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£Èç¹ûÄúÒÑÓС¢»òÕý×¼±¸½¨ÉèÍøÕ¾£¬ ÄÇôÇëÄú²Î¹ÛÒ»ÏÂÎÒÃǵÄÍøÕ¾http://www.onway.net£¬ÏàÐÅÄܶÔÄúÓÐËù°ïÖú¡£ ÎÒÃÇΪÄúÌṩµÄÒÔÏÂÍøÕ¾¿Õ¼ä¶¼¿ÉÖ§³ÖÊý¾Ý¿â£¨CGI¡¢PHP¡¢MYSQL¡¢SQL¡¢ACCESS¡¢ASP¡¢JSP£©£¬È«Ãæ Âú×ãÄúµÄÐèÇó¡£Õ

Re: Mysqld crash

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

problem importing null values in mysql 3.23.49 Win32

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 "0"s. The fields in question are numeric, nulls allowed, default value is NULL. I tried coding them blank, "\N" and "NUL

Re: Mysqld crash

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

Re: Need help with Tables/Attributes

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

Odd Question on automatic start of Mysql upon boot

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? T

Is there an older version of MySQL for DOS (or Win 3.x)?

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) T

Re: Do you run multiple servers on WIndows?

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" <[E

Re: Is type of datetime & timestamp same??

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 "SQLBind

Re: Problem: MySQL Client & Mac OS X 10.2 (Jaguar: Build 6C106)

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

String collating support

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 ch

Re: ALTER TABLE and REFERENCES

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 al

Re: Czech complex character set

> > 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 to

Re: Accessing multiple indexes

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 O> WHERE = O> AND < O> AND > ; O> If col1, col2, and col3 are indexed the query can only use one index, right?