Bug at LEFTJOIN NULL ?!

2002-09-12 Thread Thomas Wittich
Hi! I've a very dirty bug costing me hours uptill now; maybe it is related with the AND/OR-behavior described in the releasenote of 3.23.52/53; A query once runs with release 3.23.53 (my own PC); same query don't work with release 3.23.51 (my Host-Provider). Here is the Query: SELECT *

MySQL 4.0.3 crashing on FreeBSD 4.6-STABLE

2002-09-12 Thread Noor Dawod
Hi all, I've been trying to install version 4.0.3 of the new MySQL branch 4.0 but got a problem that I cannot seem to solve. Installing MySQL 4.0.3, both in binary and source compilation, yields always the following error when I try to visit a website written in PHP: 020912 09:46:19 mysqld

Setting tmp_table_size

2002-09-12 Thread hooker
Hi, We're running MySQL 3.23.49 under Debian Linux with a 2.4.19 kernel. I've got a 2-part question about tmp_table_size. 1) I've tried setting 'tmp_table_size' from the MySQL command interpreter, and I keep getting told that I have an SQL syntax error. The command is : set

show processlist

2002-09-12 Thread lorenzo.kh
Hi, I am developing a web-based application using java + tomcat + mysql in Win 2000. When the application is running,I try to view the processlist in MS-DOS using the commad show processlist. mysql show processlist; +--+--+-++-+

MySQL GRANTS

2002-09-12 Thread Gordon
1. IN 4.0.3 I CREATE 3 USERS using 3 different clients and get slightly different results when I then run SHOW GRANTS FOR XXX; The user created by MySQL Front has a slightly different set of privileges even though the GRANT displayed by

Indexing Column for a result set of a SELECT

2002-09-12 Thread Fam. Tarniceru
Dear Sirs, How can I handle with this situation? I need a special column in a SELECT statement - with LIMIT clause -, that can index my rows from 1 upward in the result set, and I don't know how to make it in MySQL. It is known that Oracle have a special function (RowNum) for this problem. Best

Re: Indexing Column for a result set of a SELECT

2002-09-12 Thread Toni Strandell
You can use the auto increment column. However, you have to add it to the table. http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#example-AUTO_INCREMENT On Thu, 12 Sep 2002, Fam. Tarniceru wrote: Dear Sirs, How can I handle with this situation? I need a special

R: Indexing Column for a result set of a SELECT

2002-09-12 Thread Danilo Maurizio
You can try this: set @index = 0; select @index:=@index+1 'index', myfield from mytable limit 100 Danilo Happy MySQL user -Messaggio originale- Da: Fam. Tarniceru [mailto:[EMAIL PROTECTED]] Inviato: giovedì 12 settembre 2002 11.59 A: MySQL Mailing List Oggetto: Indexing Column for a

ANN: Mascon for Linux 0.03 released

2002-09-12 Thread SciBit MySQL Team
Hi All, SciBit would like to announce the latest release of Mascon for Linux 0.03. For those interested please check: http://www.scibit.com/Products/Software/Mascon4Linux Kind Regards SciBit MySQL Team http://www.scibit.com

re: mysql on OS X PROBLEM!

2002-09-12 Thread Egor Egorov
Peter, Thursday, September 12, 2002, 3:35:26 AM, you wrote: PG So far as I can tell the mysql files included in the CD set are: PG mysql-3.23.49-3.i386.rpm PG mysqlclient9-3.23.22-6.i386.rpm PG mysql-devil-3.23.49-3.i386.rpm PG mysql-server-3.23.49-3.i386.rpm PG Do these files include Innodb

re: Re: Setting up a web server wit Redhat 7.3

2002-09-12 Thread Egor Egorov
Peter, Thursday, September 12, 2002, 3:35:26 AM, you wrote: PG So far as I can tell the mysql files included in the CD set are: PG mysql-3.23.49-3.i386.rpm PG mysqlclient9-3.23.22-6.i386.rpm PG mysql-devil-3.23.49-3.i386.rpm PG mysql-server-3.23.49-3.i386.rpm PG Do these files include Innodb

re: Bug at LEFTJOIN NULL ?!

2002-09-12 Thread Egor Egorov
Thomas, Thursday, September 12, 2002, 9:58:00 AM, you wrote: TW I've a very dirty bug costing me hours uptill now; maybe it is related TW with the AND/OR-behavior described in the releasenote of 3.23.52/53; TW A query once runs with release 3.23.53 (my own PC); same query don't TW work with

synopsis of the problem (one line)

2002-09-12 Thread rathamahata
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator: Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release:

AES_DECRYPT(garabage, key) problem (4.0.4 bk snapshot)

2002-09-12 Thread Sergey S. Kostyliov
Description: Server hang when trying to test field=AES_DECRYPT(filed, key) in case when filed contain garbage. How-To-Repeat: CREATE TABLE atest( id int(11) NOT NULL auto_increment, tmp text NOT NULL, KEY id (id)

Starting/stopping server on WinXP Home standalone -- what's appropriate way?

2002-09-12 Thread Uriel Wittenberg
Using WinXP Home's Computer Management utility (which you get via: Start / Settings / Control Panel / Administrative Tools / Computer Management), I can see, under Services and Applications / Services, that MySQL's startup type is Automatic. I didn't set this so apparently this is what

HP-UX problem

2002-09-12 Thread González Fernández, Richard
Hi to all, I just downloaded MySQL 3.23.52 for HP-UX, but I´m having some problems. Once installed, when I try to start the daemon, I get the following error on the data directory (*.err): 020912 13:14:51 mysqld started /usr/lib/dld.sl: Can't open shared library:

Re: Starting/stopping server on WinXP Home standalone -- what's appropriate way?

2002-09-12 Thread Gerald R. Jensen
If you set it to 'Manual', then you should be able to start/stop the service with the appropriate NET START/STOP MYSQL command. - Original Message - From: Uriel Wittenberg [EMAIL PROTECTED] To: Gerald R. Jensen [EMAIL PROTECTED]; [EMAIL PROTECTED]; Ed Carp [EMAIL PROTECTED]; Paul DuBois

float digit

2002-09-12 Thread nick gatsis
How can i change the floating point '.' to ',' as a decimal separator in MySQL 3.23... in Linux RH 7.2? Nikos - sql, query Do You Yahoo!? @yahoo.grhttp://www.otenet.gr

mysql on OS X PROBLEM!

2002-09-12 Thread philipp ringli
hi all, i am running OS X 10.2 and this version of mysql: mysql status -- ./bin/mysql Ver 11.18 Distrib 3.23.51, for apple-darwin6.0 (powerpc) Connection id: 117 Current database: mysql Current user: root@localhost Current pager: stdout Using

SELECT * INTO OUTFILE results with Errcode 28

2002-09-12 Thread Andreas Metzner
Hi All, After a query SELECT * INTO OUTFILE test.csv FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' FROM testtable the following error occurs: Error writing file 'test.csv' (Errcode: 28) The file was written partially indeed, but not including all records matching the query. Help would be

feature proposal: auto increment prefix

2002-09-12 Thread dvorakv
Hello list! I would like to propose a feature for MySQL that would solve the multiple master replication problem. Unless I miss some important information, there is currently a limitation to the use of master-master replication which concerns AUTO_INCREMENT columns (which are usually used as

SELECT * INTO OUTFILE results with Errcode 28

2002-09-12 Thread Andreas Metzner
Hi All, After a query SELECT * INTO OUTFILE test.csv FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' FROM testtable the following error occurs: Error writing file 'test.csv' (Errcode: 28) The file was written partially indeed, but not including all records matching the query. Help would be

Help request for connection problem with Java app

2002-09-12 Thread tony . aw . prichard
Hi I have MySQL (version 3.23.38) installed on Win 98 running locally as mysqld-opt which I am calling from a Java app using the mm.mysql-2.0.4 JDBC driver. I've also tried the new Connector/J but the same problem exists. When I try to have more than 30 or so open connections at a time from

3.23.52 daemon issue

2002-09-12 Thread Luc Foisy
I just finished installing RedHat 7.3 on two computers. One a server install, the other a laptop install. I proceeded at that point to install MySQL 3.23.52( the RPMs from www.mysql.com) on both. MySQL had been started on both after the install (which is pretty normal). I rebooted both, MySQL

Re: mysql on OS X PROBLEM!

2002-09-12 Thread Phil Dobbin
On 12/9/02 13:03, philipp ringli [EMAIL PROTECTED] wrote: hi all, i am running OS X 10.2 and this version of mysql: mysql status -- ./bin/mysql Ver 11.18 Distrib 3.23.51, for apple-darwin6.0 (powerpc) [...] my problem is the following: let's say i want to add the

Re: SELECT * INTO OUTFILE results with Errcode 28

2002-09-12 Thread Gerald Clark
perror 28 Error code 28: No space left on device Andreas Metzner wrote: Hi All, After a query SELECT * INTO OUTFILE test.csv FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' FROM testtable the following error occurs: Error writing file 'test.csv' (Errcode: 28) The file was written

re: SELECT * INTO OUTFILE results with Errcode 28

2002-09-12 Thread Victoria Reznichenko
Andreas, Thursday, September 12, 2002, 3:56:58 PM, you wrote: AM After a query AM SELECT * INTO OUTFILE test.csv FIELDS TERMINATED BY ',' OPTIONALLY AM ENCLOSED BY '' FROM testtable AM the following error occurs: AM Error writing file 'test.csv' (Errcode: 28) AM The file was written partially

re: mysql on OS X PROBLEM!

2002-09-12 Thread Egor Egorov
philipp, Wednesday, September 11, 2002, 8:10:04 PM, you wrote: pr i am running OS X 10.2 and pr this version of mysql: pr mysql status pr -- pr ./bin/mysql Ver 11.18 Distrib 3.23.51, for apple-darwin6.0 (powerpc) pr my problem is the following: pr let's say i want to add the

RE: Starting/stopping server on WinXP Home standalone -- what's appropriate way?

2002-09-12 Thread Ed Carp
I want to have manual startup/shutdown but still am not sure of the appropriate way to do this. Change the startup type from Automatic to Manual. The Computer Management utility allows me to stop the service and/or change the service startup type to manual or disabled. Is disabled the same

Vaibhav Difference between amount null and amount is not null

2002-09-12 Thread compo guy
What is the difference between the following sql queries written to extract tuples with the field amount having non null value: select loan_number from loan where amount null (It returns an empty set) select loan_number from loan where amount is not null(It returns the expected

Moving Mysql

2002-09-12 Thread Soheil Shaghaghi
Hello everyone, I have my MySQL database n the var partition of a FreeBSD server. The problem is that the partition is almost full, and now I can't start the SQL server! I am thinking of moving the MySQL data directory to another partition, but I don't know how I should do this. Can anyone

mysqld got signal 11 bug under FreeBSD 4.6 (using 4.0.3 binary)

2002-09-12 Thread noor
Description: After downloading and installing MySQL 4.0.3, I've downloaded and installed Apache, mod_ssl and PHP, all latest versions. I particularly made sure that PHP is linked against MySQL's new libraries in order to use the new structures. Then I set up php.ini file and httpd.conf. I also

Re: Vaibhav Difference between amount null and amount is not null

2002-09-12 Thread Vlatko Surlan
http://www.mysql.com/documentation/mysql/full/manual_toc.html#Working_with_NULL On 12 Sep 2002, compo guy wrote: What is the difference between the following sql queries written to extract tuples with the field amount having non null value: select loan_number from loan where

Re: Moving Mysql

2002-09-12 Thread Ken Menzel
Hello, First shutdown mysql. The move or copy databses to new directory. Restart server using --datadir=/my/path/for/data or place info in my.cnf file. (See examples provided with MySQL code). Ken - Original Message - From: Soheil Shaghaghi [EMAIL PROTECTED] To: [EMAIL PROTECTED]

load data local infile

2002-09-12 Thread nellA hciR
i have read several archives/docs on this but still can not get this to work from the mysql command line, load data local infile DOES work, am trying to get this to work from Perl $sth = $dbh-prepare(load data local infile '/users/hcir/desktop/t2/0001' into table s0001); $sth-execute() or

MySQL and ADO Help

2002-09-12 Thread Lukoni, Bryan AG:EX
mysql All: Here is a snippet I am using in a Select Statement using VB with ADO ... Entry_Date, CONCAT_WS( ' - ',Employee_Number,CONCAT_WS(',',last_name,first_name)) AS Employee,Cat_Description,Stat_hours,If(EXCLUDE_FTEX = 'FALSE', 'YES','') .. It works fine when run from the

newbie query question

2002-09-12 Thread Kip Krueger
I need to query a mysql db in the following fashion ... find me all records whose column 'n' have the letters 'XY' as the first two characters. where column 'n' is just a short string to clarify ... if column 'n' has the value YR12345 don't get that record. if column 'n' has the value

Re: load data local infile

2002-09-12 Thread BobJ
Try leaving out the word local. This corrected the same problem on XP Prof. BobJ - Original Message - From: nellA hciR [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 2:32 PM Subject: load data local infile i have read several archives/docs on

Re: newbie query question

2002-09-12 Thread Jesse Sheidlower
On Thu, Sep 12, 2002 at 11:46:40AM -0700, Kip Krueger wrote: I need to query a mysql db in the following fashion ... find me all records whose column 'n' have the letters 'XY' as the first two characters. where column 'n' is just a short string to clarify ... if column 'n' has the

Re: Vaibhav Difference between amount null and amount is not null

2002-09-12 Thread Dan Nelson
In the last episode (Sep 12), compo guy said: What is the difference between the following sql queries written to extract tuples with the field amount having non null value: select loan_number from loan where amount null (It returns an empty set) select loan_number from loan

RE: load data local infile

2002-09-12 Thread Lukoni, Bryan AG:EX
I have had luck by removing the word LOCAL from the statement. -=Bryan=- -Original Message- From: nellA hciR [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 11:33 AM To: MySQL List Subject: load data local infile i have read several archives/docs on this but

Re: load data local infile

2002-09-12 Thread nellA hciR
THANKS!! that works! - hcir I have had luck by removing the word LOCAL from the statement. -=Bryan=- from the mysql command line, load data local infile DOES work, am trying to get this to work from Perl $sth = $dbh-prepare(load data local infile '/users/hcir/desktop/t2/0001' into

mysql4 - order by, desc queries and indexes

2002-09-12 Thread PR
I noticed in the changelog for mysql 4.0.2 that it now Use index for ORDER BY in queries of type: SELECT * FROM t WHERE key_part1=1 ORDER BY key_part1 DESC,key_part2 DESC Very cool, I need this. Question though, when creating indexes, do we need to somehow specify desc in the index or does

Re: mysql4 - order by, desc queries and indexes

2002-09-12 Thread Paul DuBois
At 12:15 -0700 9/12/02, PR wrote: I noticed in the changelog for mysql 4.0.2 that it now Use index for ORDER BY in queries of type: SELECT * FROM t WHERE key_part1=1 ORDER BY key_part1 DESC,key_part2 DESC Very cool, I need this. Question though, when creating indexes, do we need to somehow

coding problem with inline function get_hash_symbol() referenced in sql_lex.cc

2002-09-12 Thread Lord Cane
Have tried compiling 3.23.51 with gcc 2.95.2 on both solaris x86 2.7 and solaris sparc 2.7. on both systems configure is fine (using both my own configuration and that recommended in your README for solaris 2.7) but when compiling sql_lex.cc compilation fails when

Re: HP-UX problem

2002-09-12 Thread Heikki Tuuri
Richard, - Original Message - From: González Fernández, Richard [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, September 12, 2002 2:33 PM Subject: HP-UX problem Hi to all, I just downloaded MySQL 3.23.52 for HP-UX, but I´m having some problems. Once installed,

simple query question

2002-09-12 Thread Chris Burger
I have I hope a simple query question. I have two tables 1 One has customer id and a store id and transaction information 2 Second has a store id and store information There is multiple transactions in the first table, however there is only one record for each store id in the second

Cron and mysqlimport on OS X 10.2

2002-09-12 Thread Warren, Keith
I've created a mysql database solutions that works perfectly in Mac OS X 10.1.4. However, I've purchased a new G4 running 10.1.2 (Jaguar) and I'm having one problem. I need to update the database every 5 minutes with sports scores that are exported from another system. I'm using the

RE: simple query question

2002-09-12 Thread Weaver, Walt
I'd use the InnoDB table type and establish a primary key/foreign key relationship (parent-child) between the two. That way referential integrity will be done for you by the database. --Walt Weaver Bozeman, Montana -Original Message- From: Chris Burger [mailto:[EMAIL PROTECTED]] Sent:

ot-Laptops

2002-09-12 Thread Edward Peloke
Forgive me for getting off topic but I am thinking of buying a new laptop. Which brands do you all trust? I don't have much to spend at all. I am leaning towards a compaq since they are offering an upgrade to xp pro for free (which I will need) and a free wireless card. I am looking for a

Problems with a Quote in Select

2002-09-12 Thread René Fournier
Hello everyone, I'm trying to Select on a field that contains a doublequote, and can't figure out how to pass it throught the Select statement (couldn't find anything in the docs either...) -=-=-=-=- This doesn't work... $whichpart = AND key1='$selcat'; $result = mysql_query(SELECT * FROM

laptops

2002-09-12 Thread Edward Peloke
Forgive me for getting off topic but I am thinking of buying a new laptop. Which brands do you all trust? I don't have much to spend at all. I am leaning towards a compaq since they are offering an upgrade to xp pro for free (which I will need) and a free wireless card. I am looking for a

Re: Problems with a Quote in Select

2002-09-12 Thread Gerald Clark
in perl you would do my $qselcat=$dbh-quote($selcat); $whichpart = AND key1=$qselcat; René Fournier wrote: Hello everyone, I'm trying to Select on a field that contains a doublequote, and can't figure out how to pass it throught the Select statement (couldn't find anything in the docs

Re: laptops

2002-09-12 Thread Christian J Hedemark
Apple. I spent the extra $$ for a Titanium PowerBook G4 800MHz but you don't need to spend that much for stellar performance. For about a grand you can get the iBook which runs OS X (a BSD-flavored UNIX), it comes with PHP and Apache already installed, and there is an easily installed binary

Re: Moving Mysql

2002-09-12 Thread walt
Soheil Shaghaghi wrote: Hello everyone, I have my MySQL database n the var partition of a FreeBSD server. The problem is that the partition is almost full, and now I can't start the SQL server! I am thinking of moving the MySQL data directory to another partition, but I don't know how I

Re: laptops

2002-09-12 Thread René Fournier
I guess I'm a switcher. I've had my iBook for almost a year (running OSX, now 10.2), and just absolutely love it. For the web development I do (MySQL, PHP, Apache), it's just great. ...Rene On Thursday, September 12, 2002, at 02:44 PM, Christian J Hedemark wrote: Apple. I spent the

Problem with installation of mysql 3.23.52 on solaris 9

2002-09-12 Thread Bhanu Prasad Rekapalli
Hi, The error is as follows sql_lex.cc: In function `void lex_init()': sql_lex.cc:84: `symbols' undeclared (first use this function) sql_lex.cc:84: (Each undeclared identifier is reported only once for each function it appears in.) sql_lex.cc:86: `sql_functions' undeclared (first use this

Re: Problems with a Quote in Select

2002-09-12 Thread walt
Gerald Clark wrote: in perl you would do my $qselcat=$dbh-quote($selcat); $whichpart = AND key1=$qselcat; René Fournier wrote: Hello everyone, I'm trying to Select on a field that contains a doublequote, and can't figure out how to pass it throught the Select statement (couldn't

sql date function

2002-09-12 Thread Abhi
Could you pls send me answer of my question 1.How to convert this 10-Sep-2003 in a -MM-DD sql format effeciently.Like it should be 2003-09-10. Thanks, Abhi - Before posting, please check:

Re: laptops

2002-09-12 Thread Christian J Hedemark
On Thursday, September 12, 2002, at 05:03 PM, Brent Baisley wrote: While OSX is slower than I would like it to be on a 333Mhz G3, it's very workable. What version of OS X are you running? Jaguar (10.2.0) is noticeably faster. You can do an upgrade, but a fresh install is better. The

Re: Cron and mysqlimport on OS X 10.2

2002-09-12 Thread walt
Warren, Keith wrote: I've created a mysql database solutions that works perfectly in Mac OS X 10.1.4. However, I've purchased a new G4 running 10.1.2 (Jaguar) and I'm having one problem. I need to update the database every 5 minutes with sports scores that are exported from another system.

RE: Cron and mysqlimport on OS X 10.2

2002-09-12 Thread Warren, Keith
Viewing the /var/log/system.log file, it only shows that the command executed; CRON[699]: (root) CMD (/agate/import_agate) Is there a way to get a more detailed log of what cron is doing? -- From: walt Reply To: [EMAIL PROTECTED] Sent: Thursday, September 12,

Re: Setting up a web server wit Redhat 7.3

2002-09-12 Thread Trond Eivind Glomsrød
Peter Goggin [EMAIL PROTECTED] writes: So far as I can tell the mysql files included in the CD set are: mysql-3.23.49-3.i386.rpm mysqlclient9-3.23.22-6.i386.rpm mysql-devil-3.23.49-3.i386.rpm mysql-server-3.23.49-3.i386.rpm Do these files include Innodb support? Yes. Are they

FW: questions about IF(expr1,expr2,expr3)

2002-09-12 Thread Norris, Joseph
-Original Message- From: Norris, Joseph Sent: Thursday, September 12, 2002 12:39 PM To: Mysql_List (E-mail) Subject: questions about IF(expr1,expr2,expr3) Hello, Can any one give me some examples of how they have used this function in a practical way? I would like to get a better

RE: questions about IF(expr1,expr2,expr3)

2002-09-12 Thread Lukoni, Bryan AG:EX
..If(qualify = true,'Qualified','Not Qualified') as Whatever ... -=Bryan=- -Original Message- From: Norris, Joseph [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 2:37 PM To: Mysql_List (E-mail) Subject: FW: questions about IF(expr1,expr2,expr3)

Re: FW: questions about IF(expr1,expr2,expr3)

2002-09-12 Thread Paul DuBois
At 14:37 -0700 9/12/02, Norris, Joseph wrote: -Original Message- From: Norris, Joseph Sent: Thursday, September 12, 2002 12:39 PM To: Mysql_List (E-mail) Subject: questions about IF(expr1,expr2,expr3) Hello, Can any one give me some examples of how they have used this function in a

and or in query

2002-09-12 Thread Petre Agenbag
Hi I would like to issue a logical query as follow: select * from table where field1 = x and ((field2 = y or field2 = z) or (field3 = a or field3 = b or field3 = c)); But this syntax is not returning what I expect. Plz help me with syntax

Re: and or in query

2002-09-12 Thread Keith C. Ivey
On 12 Sep 2002, at 23:48, Petre Agenbag wrote: select * from table where field1 = x and ((field2 = y or field2 = z) or (field3 = a or field3 = b or field3 = c)); But this syntax is not returning what I expect. The syntax looks fine (though the inner sets of parentheses aren't necessary).

Constant table CORRUPTION problem!!!!!

2002-09-12 Thread Inandjo Taurel
sqlsqlsqlsqlsqlsqlsqlsqlsql hi , I've been having a constant nightmare for the past 2 weeks: a particular table gets corrupted every at least twice. Am using the 3.23.49 windows version and Myisam table types on Win2k, and the operation crashing the database seems to be an update. I get an

RE: and or in query

2002-09-12 Thread Norris, Joseph
I would write this in this way: select * from table where (field = x and ($field = y or field = z)) or (field = x and (field = a or field = b or field = c)); assuming that you want a record with x in field having either y or z in field or a or b o c in field HATH -Original Message-

Re: laptops

2002-09-12 Thread Paul DuBois
At 16:21 -0400 9/12/02, Edward Peloke wrote: Forgive me for getting off topic but I am thinking of buying a new laptop. Which brands do you all trust? I don't have much to spend at all. I am leaning towards a compaq since they are offering an upgrade to xp pro for free (which I will need) and a

Re: feature proposal: auto increment prefix

2002-09-12 Thread dvorakv
2) Make a CHAR (or VARCHAR) AUTO_INCREMENT column with mandatory PREFIX. MySQL would then assign values that start with the prefix, followed by a sequential number. This works already for MyISAM and BDB tables. From the manual: CREATE TABLE animals ( grp

Lost connection to server during query error just started

2002-09-12 Thread Richard S. Huntrods
I have been running MySQL on a W2K platform for over a year now. The system is normally accessed through servlets, using the mm jdbc driver. I have a number of standalone java programs that also access the database using the mm driver. These have always worked quite well, until today. One

Re: Problems with a Quote in Select

2002-09-12 Thread Paul DuBois
FYI - Be careful using dbh-quote with inserts and updates. If you feed dbh-quote a variable that has no value, it will return '' (tick tick). If the column is a date the value will be set to -00-00 and if the column is numeric it will be set to 0 instead of NULL . You can either check the

Re: feature proposal: auto increment prefix

2002-09-12 Thread Paul DuBois
At 0:47 -0500 9/13/02, [EMAIL PROTECTED] wrote: 2) Make a CHAR (or VARCHAR) AUTO_INCREMENT column with mandatory PREFIX. MySQL would then assign values that start with the prefix, followed by a sequential number. This works already for MyISAM and BDB tables. From the manual:

Cannot find mysqladmin

2002-09-12 Thread Richard Pfeil
Hi, I am new to MySQL and am in the process of installing 3.23.52 on Red Hat Linux 7.3. The installation appears to have been successful but the post installation section of the documentation refers to mysqladmin which appears to be absent. Is mysqladmin supposed to be present in a Linux

Hans Needs Help :D

2002-09-12 Thread Dicky Wahyu Purnomo
Awal dari pesan yang diforwardkan : Tanggal: Thu, 12 Sep 2002 15:44:13 +0200 Dari: hans schneidhofer [EMAIL PROTECTED] Untuk: [EMAIL PROTECTED] hi list, have got an error in trying to install MySQL-bench-3.23.52-1 rpm says, that the file MySQL-DBI-perl-bin is reqired, but

Re: Constant table CORRUPTION problem!!!!!

2002-09-12 Thread Dicky Wahyu Purnomo
Pada Thu, 12 Sep 2002 22:22:24 + Inandjo Taurel [EMAIL PROTECTED] menulis : sqlsqlsqlsqlsqlsqlsqlsqlsql hi , I've been having a constant nightmare for the past 2 weeks: a particular table gets corrupted every at least twice. Am using the 3.23.49 windows version and Myisam table

Lost connection to server during query error just started

2002-09-12 Thread Richard S. Huntrods
I have been running MySQL on a W2K platform for over a year now. The system is normally accessed through servlets, using the mm jdbc driver. I have a number of standalone java programs that also access the database using the mm driver. These have always worked quite well, until today. One of

Re: Cannot find mysqladmin

2002-09-12 Thread Paul DuBois
At 10:54 +1000 9/13/02, Richard Pfeil wrote: Hi, I am new to MySQL and am in the process of installing 3.23.52 on Red Hat Linux 7.3. The installation appears to have been successful but the post installation section of the documentation refers to mysqladmin which appears to be absent. The

Re: Indexing Column for a result set of a SELECT

2002-09-12 Thread Paul DuBois
At 12:59 +0300 9/12/02, Fam. Tarniceru wrote: Dear Sirs, How can I handle with this situation? I need a special column in a SELECT statement - with LIMIT clause -, that can index my rows from 1 upward in the result set, and I don't know how to make it in MySQL. It is known that Oracle have a

Problems with 'make install'

2002-09-12 Thread Alex Waltrip
SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: alex To: [EMAIL PROTECTED] Subject: Getting 'are the same file' both sql-bench and mysql-test targets. Description: Hello, I

creating a text file from a tarred backup...

2002-09-12 Thread Campbell McLeay
Hi, I was wondering whether if anyone knew the method by which data can be extracted from a backup of a mysql data directory done with tar. The files I currently have are a copy of the whole mysql directory tree (done with tar). What I want to do is somehow extract the information from these

Re: creating a text file from a tarred backup...

2002-09-12 Thread Paul DuBois
At 12:16 +1000 9/13/02, Campbell McLeay wrote: Hi, I was wondering whether if anyone knew the method by which data can be extracted from a backup of a mysql data directory done with tar. The files I currently have are a copy of the whole mysql directory tree (done with tar). What I want to do is

Re: [MySQL] Problems with 'make install'

2002-09-12 Thread Ashley M. Kirchner
Alex Waltrip wrote: make[1]: Entering directory `/home/alex/work/apps/pocket-web-apps/install-platform/mysql-3.23.52/mysql-test' ...snip... mkdir -p /home/alex/work/apps/pocket-web-apps/install-platform/mysql-3.23.52 - cd

RE: Problem with installation of mysql 3.23.52 on solaris 9

2002-09-12 Thread Chugh Shalini
Which C compiler version are you using? -Original Message- From: Bhanu Prasad Rekapalli [SMTP:[EMAIL PROTECTED]] Sent: Friday, September 13, 2002 2:23 AM To: [EMAIL PROTECTED] Subject: Problem with installation of mysql 3.23.52 on solaris 9 Hi, The error is as follows

Re: Lost connection to server during query error just started

2002-09-12 Thread Mark Matthews
Richard S. Huntrods wrote: I have been running MySQL on a W2K platform for over a year now. The system is normally accessed through servlets, using the mm jdbc driver. I have a number of standalone java programs that also access the database using the mm driver. These have always worked

Re: Problems with alias names in WHERE clause

2002-09-12 Thread Zak Greant
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On September 10, 2002 23:25, Zak Greant wrote: On September 10, 2002 22:32, Paul DuBois wrote: ... You can't refer to aliases in WHERE clauses. Aliases refer to columns that have been selected, WHERE clauses determine which columns should

Re: mysql on OS X PROBLEM!

2002-09-12 Thread Clayburn W. Juniel, III
On Thursday, September 12, 2002, at 05:03 AM, philipp ringli wrote: hi all, i am running OS X 10.2 and this version of mysql: mysql status -- ./bin/mysql Ver 11.18 Distrib 3.23.51, for apple-darwin6.0 (powerpc) Connection id: 117 Current database: mysql

Re: Lost connection to server during query error just started

2002-09-12 Thread Richard S. Huntrods
Mark, Mark Matthews wrote: Richard S. Huntrods wrote: I have been running MySQL on a W2K platform for over a year now. The system is normally accessed through servlets, using the mm jdbc driver. I have a number of standalone java programs that also access the database using the mm

Re: mysql on OS X PROBLEM!

2002-09-12 Thread Clayburn W. Juniel, III
On Thursday, September 12, 2002, at 09:58 PM, Clayburn W. Juniel, III wrote: On Thursday, September 12, 2002, at 05:03 AM, philipp ringli wrote: hi all, i am running OS X 10.2 and this version of mysql: mysql status -- ./bin/mysql Ver 11.18 Distrib 3.23.51, for

Re: [MySQL] Problems with 'make install'

2002-09-12 Thread Alex Waltrip
Point taken..., maybe because, err..., uh, nobody told me not to? Yeah, that's it, that's the ticket. Well, now I know. Much kudos to you and yours. Anyway, here's what I did in case others need explicit guidance. Installation (Souce tarball only): - cd to the directory that you want to