Re: Help somehow turn this into a single query

2001-09-07 Thread Carl Troein
Ken writes: Query question: Can anyone think of a way to accomplish this in a single query?: I have a table with elements that each have a date. For a given record, I want to get, in one query, the record just earlier than this record's date, and the record just later than this

RPM or SourceCode ???

2001-09-07 Thread Nilesh Parmar
Hi all I was just getting thru the documentation of MySQL at the mysql.com site and there it is specified that The recommended way to install MySQL on Linux is by using an RPM file Can anyone tell me in what way it is different installing mysql from the rpm's and from the source code ??

admin password

2001-09-07 Thread unplug
Hi all, How can I retrieve mysql admin password if I forget it?? Rgds, unplug - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Re: mysql deadlock situation - possible bug

2001-09-07 Thread Jeremy Zawodny
On Thu, Sep 06, 2001 at 04:35:57PM -0700, Aaron Brick wrote: good day - i have found cases in which the daemon blocks waiting on a select() and just plain refuses to process certain queries. since i am reading in a 60 meg file, meaning about 3.5 million queries, this consistently happens

Re: stability of replication?

2001-09-07 Thread Jeremy Zawodny
On Thu, Sep 06, 2001 at 12:36:12PM -0700, Duc Chau wrote: I just wanted to know how stable is mysql databse replication is? What we have in mind is a tiered system. $master (california)-(internet ssh tunnel) \$slave (texas) 10 other slave

Re: Expiring Binary Logs

2001-09-07 Thread Jeremy Zawodny
On Wed, Sep 05, 2001 at 01:33:03PM -0700, A. Clausen wrote: I've been running a master/slave MySQL database system for about four months now and I've got nearly 360mb of binary logs. I want to archive anything over about a month old, but I've heard that there is a procedure that you have to

Re: Slow replication question/problem

2001-09-07 Thread Jeremy Zawodny
On Wed, Sep 05, 2001 at 03:43:00PM -0500, Jeff Adams wrote: Greetings, This morning we sucessfully inserted a new record on our master MySQL machine. 4 1/2 hours later, the change showed up on the slaves. I was under the impression that MySQl replication would occur in a more timely

Re: mysqlbug

2001-09-07 Thread Jeremy Zawodny
On Thu, Sep 06, 2001 at 06:08:00PM +0800, Chun-Hung Chen wrote: When configuring mysql, some errors happened.The report of config.log and error messages are listed below.The environment I use is Sun Solaris 8(SunOS 5.8) with gcc 2.95.3. [snip] configure:2376: checking return type of sprintf

CRM system using MySQL?

2001-09-07 Thread Carsten H. Pedersen
I'm looking for a simple CRM (adresses / contacts / orders) system using MySQL as a back-end. If anyone on this list has developed (or have knowledge of) a system with the following requirements, please drop me a message. - MySQL *must* be the backend (for integration w/ other company data)

Corrupted tables -- for 'no apparent' reason

2001-09-07 Thread Mark Papadakis
Hello, We are using mySQL on over 6 servers here, we have been doing so for over 2 years, and we are constaly facing problems with corrupted tables, especially on two of our busiest servers. Tables seem to corrupt out of the blue and we have to shut them down ( the servers ) occassionaly to

Re: List of aggregate functions? (aggregate concat?)

2001-09-07 Thread Jeremy Zawodny
On Thu, Sep 06, 2001 at 12:40:16PM -0700, xris wrote: I was just browsing through the searchable online MySQL manual, trying to find a list of the aggregate functions (as I don't trust the list in the O'Reilly book, considering the number of typos and missing information in other sections),

Re: Corrupted tables -- for 'no apparent' reason

2001-09-07 Thread Jeremy Zawodny
On Fri, Sep 07, 2001 at 10:29:31AM +0300, Mark Papadakis wrote: Hello, We are using mySQL on over 6 servers here, we have been doing so for over 2 years, and we are constaly facing problems with corrupted tables, especially on two of our busiest servers. Tables seem to corrupt out of the

problem with count (*) max (*) min (*)

2001-09-07 Thread Antonio Ortega Sancho
I'm trying to do select count (*) from table. but it doesn't work ERROR 1064: You have an error in your SQL syntax near '(*) from pendientes' at line 1 Same happens with max (column) and min (column). Do I have to install anything else or is something wrong. I'm using redhat 7.0

Re: problem with count (*) max (*) min (*)

2001-09-07 Thread Peter van Dijk
On Fri, Sep 07, 2001 at 09:28:28AM +0200, Antonio Ortega Sancho wrote: I'm trying to do select count (*) from table. but it doesn't work ERROR 1064: You have an error in your SQL syntax near '(*) from pendientes' at line 1 Same happens with max (column) and min (column). Do

Re: problem with count (*) max (*) min (*)

2001-09-07 Thread Carl Troein
Antonio Ortega Sancho writes: I'm trying to do select count (*) from table. but it doesn't work Try count(*) instead. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it

Re: problem with count (*) max (*) min (*)

2001-09-07 Thread Jeremy Zawodny
On Fri, Sep 07, 2001 at 09:28:28AM +0200, Antonio Ortega Sancho wrote: I'm trying to do select count (*) from table. but it doesn't work ERROR 1064: You have an error in your SQL syntax near '(*) from pendientes' at line 1 Same happens with max (column) and min (column). No

Re: index not incrementating

2001-09-07 Thread Jeremy Zawodny
On Thu, Sep 06, 2001 at 10:44:28AM -0700, Duc Chau wrote: Hi, can someone tell me how the index number on the bin logs are incremented? They are incremented by adding one to the extension. 001 - 002 - 003 - 004 and so on. When i update my master machine the changes are still going to

MySQLGUI question

2001-09-07 Thread Edward Beheler
I have a couple questions regarding MySQLGUI: 1. Where is the documentation located? Help only offers 'about', and I am unable to find any docs on the mysql.com website. 2. How does one execute multiple commands at the same time? I know in Microsoft SQL Enterprise manager, you seperate the

A question about load / queries pr second

2001-09-07 Thread Terje Kristensen
I have a HP-UX server with Perl 5.005_03, MySQL 3.23.39 for hp-hpux11.00 (hppa2.0w), Apache/1.3.20. The load are rather high, and Queries per second avg: 94.859 This is an local B2B installation som we are really not getting any traffic between 4PM and 7AM We have peeks where there is more than

Re: A question about load / queries pr second

2001-09-07 Thread Jeremy Zawodny
On Fri, Sep 07, 2001 at 10:11:30AM +0200, Terje Kristensen wrote: We have peeks where there is more than 1000 Queries per second. Does anyone have any experience with a higher number of queries pr second than this ? About a year ago, I used mysql-super-smack and was able to hit 8,000 per

Running_Threads problems

2001-09-07 Thread Ludo Starnet
Hi, I have a big problem, the Running_Threads are very often too high (max_connections is 100) and of course mysql crash with too much connections ! All php3 requests begin with mysql_connect and finish by mysql_close, our ASP said max_conection is enough high and problem is elsewhere. We verify

[ccs@voice.co.za: ]

2001-09-07 Thread Campbell
Hi, a snippet from a session on a linux box running standard mysql client (2.23.33): mysql update members_p set newscode='1' where ID='640103502408'; Query OK, 0 rows affected (0.00 sec) mysql update members_p set newscode='1' where ID='640103502408'; Query OK, 1 row affected (0.01 sec) All I

Re: A question about load / queries pr second

2001-09-07 Thread alec . cawley
About a year ago, I used mysql-super-smack and was able to hit 8,000 per second on our [then new] server. The highest I've recorded on an actual production application was around 5,000. But I don't watch the numbers closely very often... Just out of curiosity, on what hardware? My needs

Re: problem with count (*) max (*) min (*)

2001-09-07 Thread Chris Thorpe
It would appear that you are putting spaces between Count and the bracket which as far as I can tell will not work hence try count(*) etc... Chris Thorpe - Original Message - From: Antonio Ortega Sancho [EMAIL PROTECTED] To: Mysql (E-mail) [EMAIL PROTECTED] Sent: Friday, September 07,

Mysql SQL

2001-09-07 Thread Giovanni Borri
hi all, i have a question. i would like to know if mysql has a sql'x' standard. my problem is that i would like to use UNION or MINUS or... but it seems not to work, another problem is that i would like to make some nested query. by thanks in advance. Giovanni

Re: A question about load / queries pr second

2001-09-07 Thread Jeremy Zawodny
On Fri, Sep 07, 2001 at 09:54:35AM +0100, [EMAIL PROTECTED] wrote: About a year ago, I used mysql-super-smack and was able to hit 8,000 per second on our [then new] server. The highest I've recorded on an actual production application was around 5,000. But I don't watch the numbers

Re: command line open source ARRRGGGGGG!!!!!!

2001-09-07 Thread Robert Cross
Chadrick Mahaffey wrote: what does all this mean? I tried to type this in my command console changin / to \ and I don't understand what is happening. I get all kinds of errors. It looks to me that you're trying to use the Unix install notes - don't! Refer to section 2.1.2 in the excellent

Re: A question about load / queries pr second

2001-09-07 Thread Vinche
Hello Terje, Friday, September 07, 2001, 12:11:30 PM, you wrote: TK I have a HP-UX server with Perl 5.005_03, MySQL 3.23.39 for hp-hpux11.00 TK (hppa2.0w), TK Apache/1.3.20. TK The load are rather high, and Queries per second avg: 94.859 TK This is an local B2B installation som we are really

information about deiferences oracle/mysql

2001-09-07 Thread johannes klapwijk
Hi guys, I'm just a student, working on a project. We have to migrate a oracle database to MySQL. In order to do that we must search for diferences between the two and for other information that can help us. (of course we're not allowed to just download software and convert) Now, I've allreaddy

RE: A question about load / queries pr second

2001-09-07 Thread Jerome Ponsin
Hello, I saw your message on the list, could you tell me which scripting language you are using (php, perl, java ?) and if you have the time could you show me your my.cnf and the result of a show variable request ? I am experiencing problem with 100% CPU load and can't figure what it is ?

Optimization question and possible bug

2001-09-07 Thread Stefan Pinkert
Hi, i'm using MySQL 3.23.37 on a Linux system with an average of about 20 queries/second. First of all i have a little question how i can optimize a query. The query is like that: select * from tbl where key_field1 constant1 and key_field2 constant2 Examine that query with explain

RE: A question about load / queries pr second

2001-09-07 Thread Basil Hussain
Hi, About a year ago, I used mysql-super-smack and was able to hit 8,000 per second on our [then new] server. The highest I've recorded on an actual production application was around 5,000. But I don't watch the numbers closely very often... Just out of curiosity, on what

Re: A question about load / queries pr second

2001-09-07 Thread Jeremy Zawodny
On Fri, Sep 07, 2001 at 12:07:07PM +0100, Basil Hussain wrote: I'm quite surprised that this level of performance is available from such standard (well, not standard as in 'common', but y'know what I mean...) hardware. The last I heard, 1K+ queries/sec was only being done on extremely

Re: Problem with paswords

2001-09-07 Thread mattias
Any ideas? /Mattias Hi! I've just installed (a couple of days ago) mysql. I will use mysql for using with hlstats. That is a stats-program for HalfLife Counter Strike. (game) But I got errors... I guess it's a problem with mysql or me not knowing how to do it. Here is some printouts what

There is no function INDEX used in example

2001-09-07 Thread Hans Ginzel
Description: There is in manual_Problems.html: That means that if you search with col_name LIKE 'a%', you will get all column values that start with A or a. If you want to make this search case-sensitive, use something like INDEX(col_name, A)=0 to check a

mysql-doc.thml, duplication in INSERT syntax

2001-09-07 Thread Hans Ginzel
Description: There is duplication in the syntax of INSERT. Last version is special case of the second. INSERT [LOW_PRIORITY | DELAYED] [IGNORE] [INTO] tbl_name [(col_name,...)] VALUES (expression,...),(...),... or INSERT [LOW_PRIORITY |

mysql installation on NT problem

2001-09-07 Thread Sumit Ranjan
hi all ! i am new to mysql and trying to install it onto my win NT 4.0 workstation. but the winzip is not able to install it ! is anybody else facing the same prob? does anybody know the cure? sumit - Before

RE: mysql installation on NT problem

2001-09-07 Thread Antonie Neethling
Hi, Try to extract the files before running setup.exe. If this does not work you zip archive may be corrupt. Regards, Antonie -- S C I B I T -- Antonie Neethling ([EMAIL PROTECTED]) http://www.scibit.com/mysql - MySQL related products -- S C I B I T --

Re: Mac 10.0.4 3.23.41 Grief

2001-09-07 Thread Sinisa Milivojevic
Jeshua Lacock writes: Hello all, I have searched the archives and found various suggestions and tired them (and variations of them) and I cannot get mysqld running on Mac OS 10.0.4 (Darwin 1.3.7). I had previously built and run 3.23.39 on the same machine, but I cannot get 3.23.41

ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

2001-09-07 Thread Richard Elsberry
Hello, I am running version 3.23.41 on windows '98. When I run winipcfg I show that my hostname is siren.goldengate.net and my ip address is 10.0.0.1. When I type c:\mysql\bin mysql I get an error message: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) I tried several versions

Trying to build MySQL super-smack - failing...

2001-09-07 Thread Basil Hussain
Hi all, I'm trying to build the MySQL super-smack benchmarking tools. I'm getting the following errors on make: make all-recursive make[1]: Entering directory `/root/rpms/super-smack-1.0' Making all in src make[2]: Entering directory `/root/rpms/super-smack-1.0/src' c++ -DHAVE_CONFIG_H -I. -I.

Re: MySQLGUI question

2001-09-07 Thread Sinisa Milivojevic
Edward Beheler writes: I have a couple questions regarding MySQLGUI: 1. Where is the documentation located? Help only offers 'about', and I am unable to find any docs on the mysql.com website. 2. How does one execute multiple commands at the same time? I know in Microsoft SQL

Make new tables on top of old ones

2001-09-07 Thread Deryck Henson
I need to make about 15 tables that use the same template as the first one. Please help. - Deryck H - http://www.comp-u-exchange.com - Before posting, please check: http://www.mysql.com/manual.php (the manual)

RE: A question about load / queries pr second

2001-09-07 Thread Sinisa Milivojevic
Basil Hussain writes: Hi, I'm quite surprised that this level of performance is available from such standard (well, not standard as in 'common', but y'know what I mean...) hardware. The last I heard, 1K+ queries/sec was only being done on extremely high-end Sun enterprise-level machines.

Re: About MYSQL APIs

2001-09-07 Thread Sinisa Milivojevic
Ai2s, Proyecto writes: Hi, I'm making an application on C++Builder5, which will be comunicated with MYSQL server , What do you MYSQL API recomend : MYSQL++ or MYODBC, I know that the MySQL C++ API is the official API, but can I connect to other SQL server whit this API? Thank you,

Re: About MYSQL APIs

2001-09-07 Thread Michal Dvoracek
Hi, on freshmeat.net you can find some libraries which provide same comfort as mysql++, so try check... S pozdravem Michal Dvoracek [EMAIL PROTECTED] Capitol Internet Publisher, Korunovacni 6, 170 00 Prague 7, Czech Republic tel.: ++420 602 210 900, ++420 2 3337 1117,

Re: About MYSQL APIs

2001-09-07 Thread Ed Carp
Sinisa Milivojevic ([EMAIL PROTECTED]) writes: If you wish to make your application transparent, you should use ODBC. ODBC, or MyODBC? -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade

MYSQLGUI

2001-09-07 Thread FLEPRETR
Hello we would like to use MYSQLGUI is it allowed ? Id not not have any user and password to enter for download Best regards Franck Lepretre - Before posting, please check: http://www.mysql.com/manual.php (the

Re: About MYSQL APIs

2001-09-07 Thread Sinisa Milivojevic
Ed Carp writes: Sinisa Milivojevic ([EMAIL PROTECTED]) writes: ODBC, or MyODBC? -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team

Re: MYSQLGUI

2001-09-07 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: Hello we would like to use MYSQLGUI is it allowed ? Id not not have any user and password to enter for download Best regards Franck Lepretre It is completely free to use as much as you wish on as many computers as you wish. Just download binary or

Re: mysql installation on NT problem

2001-09-07 Thread Sumit Ranjan
hi ! thanx for your reply. now i could install mysql on my NT. nut now when i give the command mysql-nt --install it says unable to install. moreover as it is in the installaton doci tried to look for the my-example.cnf file but i cud get only a link of this name in whole of

Re: About MYSQL APIs

2001-09-07 Thread Sinisa Milivojevic
Ed Carp writes: So, is MyODBC just for MySQL, or can one use it for talking to other databases via ODBC also? Sorry, I'm just confused today, I guess ;) -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications

COUNT elements in a LIMIT query

2001-09-07 Thread Torgil Zechel
Hello! Is it possible to get the total number of records when doing a select with LIMIT? For example, if I do: SELECT * FROM tbl LIMIT 0,10 I would like to get the total number of records in tbl along with the 10 first ones.. I need this to display showing 0 - 10 of 354, and my query

RE: Problems retrieving tables

2001-09-07 Thread Jean Paterson
-Original Message- From: Jean Paterson [mailto:[EMAIL PROTECTED]] Sent: 07 September 2001 14:34 To: '[EMAIL PROTECTED]' Subject: Problems retrieving tables Can anyone help- I am new to MySQL. I am using Ultradev. I have installed MyODBC on my PC and set it up connect to my ISP’s

Re: command line open source ARRRGGGGGG!!!!!!

2001-09-07 Thread Paul D. Smith
%% Chadrick Mahaffey [EMAIL PROTECTED] writes: cm How do I start the server and create a database in plain English. I'm not cm familiar with: cm SECTION 4.16 - Documentation shell ./scripts/mysql_install_db shell cd mysql_installation_directory shell ./bin/safe_mysqld

sysdate() query and note to Mysql admin

2001-09-07 Thread ryan
Hi, I my name is ryan and I own a small site which has a mysql database and servlet support. I have a simple query to all you mysql gurus... my table is very simple, i created a table with the following create table datee(int today); now,what statement do I use to put the sysdate into the

Re: Make new tables on top of old ones

2001-09-07 Thread Ed Carp
Deryck Henson ([EMAIL PROTECTED]) writes: I need to make about 15 tables that use the same template as the first one. Please help. gripe Please post more information. Platform, software, etc. This is like saying, I want to get from point A to point B. Please help. /gripe OK, I've got that

ODP: sysdate() query and note to Mysql admin

2001-09-07 Thread Daniel a
Hi First of all try to use datetime column for datetime storage porpouses. create table datee(datetime today); And then: insert into datee(today) values(now()); After all of this, please RTFM :)). It's all written there. Regards Daniel a e-direct Polska sp.

Re: A question about load / queries pr second

2001-09-07 Thread Mike Wexler
Terje Kristensen wrote: I have a HP-UX server with Perl 5.005_03, MySQL 3.23.39 for hp-hpux11.00 (hppa2.0w), Apache/1.3.20. The load are rather high, and Queries per second avg: 94.859 This is an local B2B installation som we are really not getting any traffic between 4PM and 7AM We

Re: A question about load / queries pr second

2001-09-07 Thread Mike Wexler
Jeremy Zawodny wrote: On Fri, Sep 07, 2001 at 12:07:07PM +0100, Basil Hussain wrote: I'm quite surprised that this level of performance is available from such standard (well, not standard as in 'common', but y'know what I mean...) hardware. The last I heard, 1K+ queries/sec was only

Re: sysdate() query and note to Mysql admin

2001-09-07 Thread Ed Carp
[EMAIL PROTECTED] ([EMAIL PROTECTED]) writes: now,what statement do I use to put the sysdate into the column today? this is NOT working insert into datee values(select DAYOFMONTH(sysdate())); Of course not. insert into datee values (Now()) will, though. Just feed it to mysql ... ;) Here's

Floats

2001-09-07 Thread Guddack Thorsten ICM MP SCM SCCM PI
Hi List, I'm a little bit confused. I do the following: Create a table with 1 int and two floats. mysql create table testfloat(z int, ll float, ul float); Query OK, 0 rows affected (0.00 sec) inserting one row into the table mysql insert into testfloat values(1,-0.1,0.1); Query

Re: Select Highest ID query

2001-09-07 Thread Ian Moore
On Thu, Sep 06, at 11:05pm, Chris Bolt ([EMAIL PROTECTED]) wrote: SELECT * FROM yourtable WHERE id = LAST_INSERT_ID(); But that will only work if it was the same thread that inserted the last record in the table. If this is running from say .. a script that just wants the last inserted record

RE: Select Highest ID query

2001-09-07 Thread Johnny Withers
Why not just: SELECT MAX(id) AS max_id FROM yourtable; Then run another select to get the record? Or, if you want the last record: SELECT * FROM yourtable ORDER BY id DESC LIMIT 1; maybe. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original

Re: Corrupted tables -- for 'no apparent' reason

2001-09-07 Thread Adams, Bill TQO
Mark Papadakis wrote: We are using mySQL on over 6 servers here, we have been doing so for over 2 years, and we are constaly facing problems with corrupted tables, especially on two of our busiest servers. Tables seem to corrupt out of the blue and we have to shut them down ( the servers )

Re: COUNT elements in a LIMIT query

2001-09-07 Thread Ian Barwick
On Friday 07 September 2001 15:37, Torgil Zechel wrote: Is it possible to get the total number of records when doing a select with LIMIT? No. As least, not in MySQL, unless I am missing something. For example, if I do: SELECT * FROM tbl LIMIT 0,10 I would like to get the total

Re: command line open source ARRRGGGGGG!!!!!!

2001-09-07 Thread Joshua M . Schmidlkofer
I wanted to put in my 2 cents. Access is not an RDBMS.. It is a single user - small user, and frequent fix type system. I have never worked on a real database system that does not have a command line interface. It seems fearsome at first, but it's actually easy. SQL Server do doubt

Mysql Fulltextsearch

2001-09-07 Thread Lorang Jacques
Hello, Actually I am programming an web directory (like yahoo). But my sql queries need ernormous cpu resources. So it is quiet slow. I can't use indexing because my serach works with LIKE '%$serchstring%'. (apparently then it dosen't help). Now I was wondering if it would get faster by using

Let's approach stored procedures

2001-09-07 Thread Claudio Cicali
I think this is a little OT here, so after reading please indicate me where to talk about this subject. I'm a skilled programmer in C, C++ and others progr. lang. I have also a solid background in SQL and some RDMS (DB2, Oracle, SQLServer, and of course, Mysql). I'm going to attend a long

Re: Optimization question and possible bug

2001-09-07 Thread Adams, Bill TQO
Stefan Pinkert wrote: Examine that query with explain select... show that the indexes are not used. The keyfields are unsigned tiny int where every bit has a different meaning. Any clue how i can rewrite this query in a way where the indexes are used? If MySQL thinks it will be faster to

Re: Mysql SQL

2001-09-07 Thread Joshua M . Schmidlkofer
On Friday 07 September 2001 06:11 am, you wrote: Giovanni Borri writes: hi all, i have a question. i would like to know if mysql has a sql'x' standard. my problem is that i would like to use UNION or MINUS or... but it seems not to work, another problem is that i would like to make

Re: Mysql Fulltextsearch

2001-09-07 Thread Ed Carp
Lorang Jacques ([EMAIL PROTECTED]) writes: Now I was wondering if it would get faster by using FULLTEXTSEARCH on my tables. As it is quiet some work, I first want to ask you guys if this is really going to make my queries faster (much faster ?) Yup. I've got the entire set of laws for the

Re: Let's approach stored procedures

2001-09-07 Thread Adams, Bill TQO
Claudio Cicali wrote: I'm going to attend a long period of holidays (finally) so, I thought: why don't try to implement stored procedures in mysql ? Someone did it with perl. http://software.tangent.org/article.pl?sid=01/08/23/0817244mode=threadthreshold= At a first glance, I think Oracle

Fw: command line open source ARRRGGGGGG!!!!!!

2001-09-07 Thread Colm Brazel
- Original Message - From: Colm Brazel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 07, 2001 4:33 PM Subject: Re: command line open source ARRRGG!! Open source software is written by technical people. They do it because they enjoy it. Most of them don't

Re: Let's approach stored procedures

2001-09-07 Thread Ed Carp
Claudio Cicali ([EMAIL PROTECTED]) writes: At a first glance, I think Oracle PL/SQL is the best (afaik) programming language for sp, but, in the case we implement that language, should we go against some Oracle copytight infringment ? Why would you want to do such a thing? Isn't SQL good

In the table Properties... What is Row_Format???

2001-09-07 Thread Pablo Fraga
What´s the diference between The row storage format (Fixed, Dynamic, or Compressed) . I'am experiencing problems with update statements which goes against a table with the row_format property set to Fixed. Thanks. Pablo Fraga (MIS). e-mail: [EMAIL PROTECTED] - [EMAIL PROTECTED] icq: 113466029

Re: Let's approach stored procedures

2001-09-07 Thread Claudio Cicali
At 10.44 07/09/2001 -0500, Ed Carp wrote: Claudio Cicali ([EMAIL PROTECTED]) writes: At a first glance, I think Oracle PL/SQL is the best (afaik) programming language for sp, but, in the case we implement that language, should we go against some Oracle copytight infringment ? Why would

Re: Mysql Fulltextsearch

2001-09-07 Thread Doug Poland
On Fri, Sep 07, 2001 at 10:41:33AM -0500, Ed Carp wrote: Lorang Jacques ([EMAIL PROTECTED]) writes: Now I was wondering if it would get faster by using FULLTEXTSEARCH on my tables. As it is quiet some work, I first want to ask you guys if this is really going to make my queries faster

Re: Slow replication question/problem

2001-09-07 Thread Jeff Adams
Jeremy Zawodny wrote: snip Are subsequent inserts just as slow to replicate? Can you show us the output of SHOW SLAVE STATUS and maybe the my.cnf files of the master and a slow slave? Jeremy Thanks for the response. Below is the info you requested. If there's anything else that

newbie:

2001-09-07 Thread ricardo bravo
Hi All, where do I specify the remote hosts that are allowed to access port 3306? I have made entries in the user table of the mysql db, but still cannot conect from a remote machine. Thanks, Ric. _ Get your FREE download of MSN

Re: Let's approach stored procedures

2001-09-07 Thread Cal Evans
My $.02, Stick with the ANSI standard. (ANSI99?) Do not try to implement either PL/SQL or T/SQL. Please do not implement PERL (or Python) , Java, PHP or any other procedural or OO language in stored procedures. Speaking form experience, all this does is blur the lines of that the database

Re: RPM or SourceCode ???

2001-09-07 Thread Alok Daipuria
If you read thru more about the reasons for recommendation for installing thru RPM, you'll understand. Since the folks who built RPMs have definitely spent lot of time building the RPMs which is optimized for performance. I do trust them and commend their efforts. The source definitely gives

Re: Floats

2001-09-07 Thread Gerald Clark
This is a standard 1st quarter computer science topic. You can't reliably test floating point numbers for equality. 0.1 has no exact floating point binary representation. Perhaps you should use the DECIMAL type which is stored internally as a string. Guddack Thorsten ICM MP SCM SCCM PI wrote:

In the table Properties... What is Row_Format???

2001-09-07 Thread Pablo Fraga
What´s the diference between The row storage format (Fixed, Dynamic, or Compressed) . I'am experiencing problems with update statements which goes against a table with the row_format property set to Fixed. Thanks. Pablo Fraga (MIS). e-mail: [EMAIL PROTECTED] - [EMAIL PROTECTED] icq: 113466029

RE: Let's approach stored procedures

2001-09-07 Thread Ed Carp
- it's cool Not a valid business reason. - where I work, we have a HUGE database-driven web-application. A lot of our business logic is implemented via stored procedures, that act as black boxes for the web-designers. Think of enterprise java beans. They are not nonsense or

Re: Let's approach stored procedures

2001-09-07 Thread Cal Evans
Ed, Stored procedures allow you to pre-compile and re-use code easily. They also make transactions easier. (At least from one point of view) It's not like the XML argument. SPs are also part of the ANSI spec so to be compliant, MySQL will have to have them. XML is not part of the ANSI-SQL spec.

RE: Mysql Fulltextsearch

2001-09-07 Thread Ed Carp
Do the current limitations of 500 characters per index and limited (?) number of columns per index pose problems? I want to use fulltext on a database with 7 varchar(255) columns and several smaller varchar columns but can't build a fulltext index. Is there documentation on the limitations

Re: Let's approach stored procedures

2001-09-07 Thread Ed Carp
Cal Evans ([EMAIL PROTECTED]) writes: Stick with the ANSI standard. (ANSI99?) Do not try to implement either PL/SQL or T/SQL. Please do not implement PERL (or Python) , Java, PHP or any other procedural or OO language in stored procedures. Speaking form experience, all this does is blur the

Re: In the table Properties... What is Row_Format???

2001-09-07 Thread Ed Carp
Pablo Fraga ([EMAIL PROTECTED]) writes: What´s the diference between The row storage format (Fixed, Dynamic, or Compressed) . RTFM! http://www.mysql.com/doc/C/R/CREATE_TABLE.html http://www.mysql.com/doc/D/y/Dynamic_format.html -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 -

RE: Let's approach stored procedures

2001-09-07 Thread Claudio Cicali
At 11.03 07/09/2001 -0500, Ed Carp wrote: - it's cool Not a valid business reason. - where I work, we have a HUGE database-driven web-application. A lot of our business logic is implemented via stored procedures, that act as black boxes for the web-designers. Think of

Re: About MYSQL APIs

2001-09-07 Thread Peter Harvey
Ed Carp wrote: Sinisa Milivojevic ([EMAIL PROTECTED]) writes: Ed Carp writes: Sinisa Milivojevic ([EMAIL PROTECTED]) writes: ODBC, or MyODBC? ODBC as an API. Then you install ODBC driver for RDBMS of your choice and configure ODBC likewise. But ODBC as a

Re: Query question.

2001-09-07 Thread Michael Garvin
Not quite. We're not looking for a left join or natural left join. I'm not sure MySQL or any database can even do this, it may have to be done (rather unattractively) on the API side. The data in the two tables aren't tied by ID, and shouldn't mix w/ each other at all. To do this, all we've

AW: Optimization question and possible bug

2001-09-07 Thread Stefan Pinkert
No, they do not differ from the rest. The only thing is that they need longer time to process (between 1 and 4 seconds, normally the SAME query is processed in a few miliseconds). The only correlation i found is that all queries in that log query the merge table. How does mysql handle locks on

Re: Let's approach stored procedures

2001-09-07 Thread Cal Evans
Let me clarify. I'm in great favor of stored procedures in MySQL. It is my HO that all interaction with the database should take place within stored procedures. But the ANSI standard is sufficient for most interaction with the database. My call to arms was to resist the urge that Oracle could

Re: COUNT elements in a LIMIT query

2001-09-07 Thread Carl Troein
Torgil Zechel writes: I would like to get the total number of records in tbl along with the 10 first ones.. As far as I recall this is one of the things that will be added in version 4. The question is just when that version will be stable enough to be fully trusted (it might already be for

Re: Mysql Fulltextsearch

2001-09-07 Thread Doug Poland
On Fri, Sep 07, 2001 at 11:10:46AM -0500, Ed Carp wrote: Do the current limitations of 500 characters per index and limited (?) number of columns per index pose problems? I want to use fulltext on a database with 7 varchar(255) columns and several smaller varchar columns but can't build

Re: newbie:

2001-09-07 Thread Carl Troein
ricardo bravo writes: Hi All, where do I specify the remote hosts that are allowed to access port 3306? I have made entries in the user table of the mysql db, but still cannot conect from a remote machine. Thanks, Do the entries match the host you're connecting from? Did you add them

Re: Let's approach stored procedures

2001-09-07 Thread William R. Mussatto
On Fri, 7 Sep 2001, Cal Evans wrote: Date: Fri, 7 Sep 2001 11:05:27 -0500 From: Cal Evans [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED], Ed Carp [EMAIL PROTECTED] Subject: Re: Let's approach stored procedures Ed, Stored procedures allow you to pre-compile and re-use code

Re: Let's approach stored procedures

2001-09-07 Thread Adams, Bill TQO
Cal Evans wrote: Stored procedures allow you to pre-compile and re-use code easily. They also make transactions easier. (At least from one point of view) It's not like the XML argument. SPs are also part of the ANSI spec so to be compliant, MySQL will have to have them. XML is not part of

Re: Let's approach stored procedures

2001-09-07 Thread Cal Evans
SQL. Stored procedures are loosely analogous to shell scripts. No additional language constructs, outside of what is defined in the ANSI-SQL standard are necessary for them. IMHO, C would be a bad thing. My $.02 worth, (which is worth less, each time I post) Cal * * Cal Evans * Senior Internet

  1   2   >