DSNless DB connection with MySQL/ASP

2001-03-28 Thread Nicolas Villatte
Is it possible to procede to a DSNless connection to a mySQL DB in ASP ? If so could anyone send me a example script ? Thank you. Nicolas Villatte IT Manager Creative Web Rue Kessels straat, 38 1030 Brussels Office Phone: +32 2

RE: New ODBC

2001-03-28 Thread Joris Lambrecht
This means that the host mbtpc20.bau-verm.uni-karlsruhe.de is not allowed to connect to your server. You can set this up rather easily with the standard mysql GUI admin tool. Also have a read on creating/working with users in the on-line searchable documentation of MySQL greetings, Joris

Betr.: Hello

2001-03-28 Thread M. Verheijen
Dear Robert, If I'm correct you've installed a mysql server on your webserver, I hope that you used the documentation which is provided on the mysql-website. I hope that you're sure about the ability to use scripting-languages on your server and that they can interact with mysql. If you

Reserved word/ Ambiguous Column title 'Key'

2001-03-28 Thread Richard Harris
Hi, I am importing an Access 97 Database into MySQL. One of tables tblSuppliers holds all the critical supplier information and has a 4 character Primary key called 'Key' This is heavily used throughout a lot of VB code in the Access GUI and can't really be changed easily. When I import the

Auto Incrementing Numbers

2001-03-28 Thread Sean Preston
Hi I am wanting to use auto incrementing numbers. Now I know that if I add an entry to the db then the number is auto assigned. Now what I want is it where I can get the next auto number and then add my entry using this number. The reason for this is that I need this number for a number of

Re: signal 11, segmentation fault :(

2001-03-28 Thread Kaneda K
I had this segmentationone but that was using java (1.3 form IBM on Red Hat 6.2) and that was an exception that stopped my Web Apps I switch both jdk (I use Sun know) and driver mm...2.0.2 to 2.0.3 and I never have this exception ever since. I hope that helps. At 18:47 27/03/2001 -0800, you

pictures and MS Word graphics in an Access front end

2001-03-28 Thread Per Warter
I'm converting a MS Access database to a mySQL database. All seems to be fine. But I have problems with MS Access fields of the type (german) OLE-Objekt (probably OLE object in the English version). These fields are converted to LONGBLOBs. In Access, I can fill these fields with graphics or

Re: MySQL 3.23.36 SIGSEGV on start

2001-03-28 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: Description: MySQL 3.23.36, built on a lunix-2.4.2 system using identical configuration to the previous MySQL-3.23.35 build, dies immediately upon launch with a SIGSEGV. How-To-Repeat: All that's necessary on this system is to try to start

MySQL and StarOffice database via ODBC

2001-03-28 Thread Andrei B.
Hi, I am trying to link a MySQL database (linux) with a StarOffice client on Windows, with MyODBC installed. I created the database, tables, set up select,update,delete,insert privileges on all tables in it from the host running StarOffice. I can list tables, can insert data into them via

MYSQLGui

2001-03-28 Thread Peter Adamka
Maybe this question is out of topic, but I'm feeling really unhappy. I'm trying to compile MysqlGui, but at the end it always says, that there are no -lrc an -lrcl libraries. And that's the point. I have no idea, what libraries I should download (I'm using RH7.0 on 200MMX).

Re: MYSQLGui

2001-03-28 Thread Sinisa Milivojevic
Peter Adamka writes: Maybe this question is out of topic, but I'm feeling really unhappy. I'm trying to compile MysqlGui, but at the end it always says, that there are no -lrc an -lrcl libraries. And that's the point. I have no idea, what libraries I should download (I'm using RH7.0 on

GROUP BY behaviour.. help needed..

2001-03-28 Thread James Cox
Hello, This is the following SQL statement used in a results page for a search: SELECT icaref, id, date, payee, descript, disb, payment, receipt-payment, receipt, SUM(disb), SUM(receipt-payment) FROM data WHERE receipt-payment 0 AND date BETWEEN 'varStart' AND 'varEnd' ORDER BY date GROUP BY

Can not install on Solaris 2.6

2001-03-28 Thread Greg Wejrowski
I'm newbie when it comes to installing pkg's on Solairs.. I've dl'd the latest version of mysql from sourceforge (2.23.36-sun-solairs2.7-sparc.tar.gz). I can install the pkg ok but when I run mysql_install_db I get the following message.. ld.so.1: /bin/mysql: fatal: libcrypt_1.so.1: open

MySQL 3.23 seems slower than 3.22

2001-03-28 Thread David Hearn
Hi, I hope that someone can help me on this matter. I have a C program which uses MySQL. This program does many many (100,000) SELECT, INSERT, UPDATE, DELETE on single HEAP tables. The machine I developed it on was a P3 800 256MB Linux machine running MySQL 3.22.32 (standard version of

[ANS] Can not install on Solaris 2.6

2001-03-28 Thread davea
Greg, I checked on all my 2.6 systems and the library libcrypt_1.so.1 appears to be a Solaris 2.7 library only. I could not find a current version of mysql for Solaris 2.6. I'm in the process of compiling the latest version on my Solaris 2.6 machine. There is a version for 2.6 but it is

SELECT returning less fields than awaited.

2001-03-28 Thread christophe leroy
The following peace of code returns sometimes a result with only 1 field, whereas i'm waiting for a result with 3 fields. How can such a SELECT return less than the field count required ? Here are the query, *result and mysql just after the mysql_fetch_row() Thanks if you can help me

MySQL and LDAP

2001-03-28 Thread Adonis Andrews
Hello, I am looking for a difinitive answer as to whether data from LDAP and MySQL may be synchronized. What I want to know is if there's any way to automagically synchronize MySQL and LDAP? ie take selected fields from MySQL and have it update an LDAP authentication database. LDAP as a front

Re: perl API

2001-03-28 Thread Gerald Clark
LIBASOV IOANNIS wrote: I'm not quite sure if this question is appropriate for this mail list, so may be somebody can tell me whom to ask better. I was going to run the following code: .. if (system("mysql -u username -ppassword -h hostname -P 3606 path/to/filename 2errlog"))

Re: MySQL 3.23 seems slower than 3.22

2001-03-28 Thread David Hearn
Just thought I would explain my stupidity! One of my tables which I'd forgotten about was 100k entries but I'd dropped the primary key off earlier. Adding the primary key back again made the two machines the same speed immediately. Its amazing what indexes can do! David Hi, I hope that

Re: table output display

2001-03-28 Thread Gerald Clark
Bordeaux Stan wrote: Hi guru type folks, My system crashed over the weekend and I had to reinstall linux. I'm currently running Mandrake 7.2. Now that I'm up and running again I find that the output from a mysql query is not formatted properly. The tables look as though they are

Re: MySQL 3.23.36 is relased

2001-03-28 Thread Vivek Khera
"MW" == Michael Widenius [EMAIL PROTECTED] writes: MW* Added `SET TRANSACTION ISOLATION LEVEL ...' How about documenting this? http://www.mysql.com/doc/S/E/SET_TRANSACTION.html is quite uninformative as to what the different levels mean.

stability documentation up to date?

2001-03-28 Thread Vivek Khera
Is the http://www.mysql.com/doc/S/t/Stability.html document up to date? In particular, I'm interested in the current stability level of BDB tables, since I'm in need of transactions for a particular project. Also, the MyISAM handler is still listed as gamma, not stable. --

problem with the mysql startup

2001-03-28 Thread mohamed imdadullah
Hello, iam new to mysql and have nothing much to do with mysql itself, but i seem to have the following message whenever i start mysql it gives me the following message Starting service MySQLStarting mysqld daemon with databases from /var/lib/mysql failed. well , i checked up the mysql

Re: Unknown Database, Error 1049 problems...

2001-03-28 Thread Gerald Clark
Jason Guritz wrote: mysql show databases; +---+ | Database | +---+ | directory | | mysql | | phpBB | | testdb | | trial | +---+ 5 rows in set (0.00 sec) mysql use testdb; ERROR 1049: Unknown database 'testdb' Keeps happening to me

Re: Unknown Database, Error 1049 problems...

2001-03-28 Thread jason
I know you people are busy but I have seen this question a few times on the lists to no avail. *see below* It has been figured out by my admin. It appears that one or more entries in the ACL tables is corrupt, when this happens so its preventing logins. So you have to replace the ACL with a

Re: Compiling

2001-03-28 Thread Gerald Clark
And no mention of the machine, the operating system version, the mysqlsource file downloaded, the compiler used, which version of make, or even the comand entered. gawie wrote: Hi...please help Cannot get the version of MySQL compiled..When running a configure it stops at :

Re: mysql error 2002e

2001-03-28 Thread Gerald Clark
Forget it. That compiler is broken. Use GCC-2.95.2 root wrote: hi there o wise ones i know i should RTFM, but i am, its right here infront of me. maybe its cause i cant start working with sql till i get home from slavin for the man or whatever, but id really like to get it

MySQLGUI 1.7.4 problems.

2001-03-28 Thread Sean Armstrong
I can't seem to get this version of MySQLGUI 1.7.4-2 to connect to the mysql server I'm running on the computer. I get the following denial of access everytime I try to connect: Access denied for user: ' mailto:'root@localhost' root@localhost mailto:'root@localhost ' (Using password: Yes)

Re: myisamchk problems

2001-03-28 Thread Gerald Clark
Daniel Adams wrote: This is probably a really stupid error, but I'm unable to run myisamchk: [root@cssrvr1 mail2db.bad]# ls category.MYD groupcounter.MYD list.MYD message.MYD threadrequest.MYD category.MYI groupcounter.MYI list.MYI message.MYI threadrequest.MYI category.frm

access denied for deleting database

2001-03-28 Thread mohamed imdadullah
Hello, iam trying to delete tables from a database, the mysql asks for the root user password which i give but it seems to be not accepting it , i have included the sequence below Erasing database tables (you will need to enter the database root password) Path of mysql tool (the default is

Re: Converting Decimal value to Binary

2001-03-28 Thread Gerald Clark
BIN(intag 255) Filip Sergeys wrote: Hi, WHAT DO I WANT TO DO: I want to have the binary value of a part of a decimal value. 1)I have a decimal value in column called intag : 262204 2)From this value I'am only interested in the last two bits of the HEX value of this decimal

Re: [NEWBIE] safe_mysqld

2001-03-28 Thread Gerald Clark
The RPMs on RH CD have problems. Check teh archives for instructions on getting it working, or get new RPMs. Stephane Pinel wrote: When I attempt to launch mysql server with command safe_mysqld, the console return this: "starting mysqld daemon with databases from /var/lib/mysql" "010327

Re: Perl - DBD:DBI Errors

2001-03-28 Thread Gerald Clark
You don't have zlib on your machine. Check your 6.2 CD. Chris Becker wrote: I'm having trouble installing the perl module DBD specifically. I found on my CPAN cd the DBD module Msql-Mysql-modules-1.2208, tried to install it and got errors, I discovered I needed DBI installed first. So I

Re: Complex mysql query

2001-03-28 Thread Yann Larrivée
Thanks for the answer but it is a bit more complexe, i actually creates these sample table for the example. Here is an attachement of the structure dump. Hummm you got me to think more about my database structure withc is really good. The idea you bourght up seems really good. I am a

Contracting opportunities?

2001-03-28 Thread Henry Hank
Hello All, I'm recently back in the job market, and looking for PHP/MySQL contracting opportunities. Can some helpful people out there please email with good job sites and/or real headhunters that specialize in this type of work? I've already exhausted dice.com, guru.com, monster.com,

MYSQL problems

2001-03-28 Thread Jonathan Almarez
I am having problems with a MySQL query. I user the following query: SELECT search_users.ID FROM search_users,users WHERE search_users.Step=4 AND users.ID=search_users.ID AND search_users.Login'' AND search_users.LookForSex="M" AND search_users.Sex="F" AND search_users.Country="US" AND

Re: myisam upgrade problem

2001-03-28 Thread Gerald Clark
error 28 is "No space left on device". Hang wrote: Greetings, I am upgrading my mysql from 3.22.23b to 3.23.35 on RedHat with kernel 2.4.0. I followed the instructions on the manual for the upgrade. Every goes fine except I can't convert one table from ISAM to MYISAM. I got quite a

Re: Reserved word/ Ambiguous Column title 'Key'

2001-03-28 Thread Lindsay Adams
Somebody will correct me if I am wrong, but I think cannot have a column in a table that has the same name as a MySQL reserved word. You are going to have to change it. 'Key' is simply NOT going to work for your column name. On the reasonable chance that I am wrong, the documentation that I am

Binary distribution with BDB and InnoBase?

2001-03-28 Thread Shankar Unni
Sorry to keep harping on this, but back when 3.23.34 was released, there was a line in the release notes that claimed that binary distributions with BDB and InnoBase would be tackled "next week". Has there been any progress on this front? I'm most interested in the Win32 binary distribution,

Re: Can not install on Solaris 2.6

2001-03-28 Thread Gerald Clark
Greg Wejrowski wrote: I'm newbie when it comes to installing pkg's on Solairs.. I've dl'd the latest version of mysql from sourceforge (2.23.36-sun-solairs2.7-sparc.tar.gz). I can install the pkg ok but when I run mysql_install_db I get the following message.. ld.so.1: /bin/mysql: fatal:

PROBLEM!!

2001-03-28 Thread Michael Widenius
Hi! First: To this mailing list we only accept full repeatable bug reports as defined in the MySQL manual. "Ionut" == Ionut Petre [EMAIL PROTECTED] writes: Ionut HI! Ionut I have a problem, and I don't know how to resolve it: Ionut I want to migrate a database from an SQL Server 7.0 into an

test

2001-03-28 Thread jason davidson
just checking if im on the list still - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED]

web-based accounting system

2001-03-28 Thread JOE ECHAVARRIA
Hi there, I am looking for a web-based accouting system written in Mysql/Perl/Apache/Linux. I am willing to pay for the system, and it could be a simple accounting system or a complex one. Could be also just a module, for example payroll, inventory, sales. I hope someone could tell

Synchronization

2001-03-28 Thread Martin Jeremic
I have two mySQL servers, one is in office, and other at home. I need to synchronize then via DialUp TCP/IP connection (not Internet DialUp). Can somebody help me ? -- Martin Jeremic - JSoft http://jsoft.webjump.com/ mailto:[EMAIL PROTECTED]

Re: Synchronization

2001-03-28 Thread Jeremy D . Zawodny
On Wed, Mar 28, 2001 at 05:22:56PM +0200, Martin Jeremic wrote: I have two mySQL servers, one is in office, and other at home. I need to synchronize then via DialUp TCP/IP connection (not Internet DialUp). Can somebody help me ? Does MySQL replication suit your needs? Jeremy -- Jeremy D.

Deadlock found with MERGE tables

2001-03-28 Thread root
Description: Deadlock possible when LOCKing underlying tables in a MERGE table definition How-To-Repeat: mysql CREATE TABLE lock_test1 ( test CHAR(5) DEFAULT '' NOT NULL PRIMARY KEY ); mysql CREATE TABLE lock_test2 ( test CHAR(5) DEFAULT '' NOT NULL PRIMARY KEY );

wierd problem with left joins and count

2001-03-28 Thread Taavi Kald
Hi! I have query from several tables - from news table, picture table and comments table. It diplays headline, news from news table, number of comments for news from comments table and picture alignment (on the web) from pictures table. As it could be many comments and also many pictures for one

(sin asunto)

2001-03-28 Thread Chris Becker
try INSERT INTO tblDomains (field1, field2) VALUES (1, 'trlinux.com.'); ChrisB MCSE MCDBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Cesar Martinez Sent: Wednesday, March 28, 2001 12:40 PM To: [EMAIL PROTECTED] Subject: (sin asunto) that such!!

Complex SQL Query

2001-03-28 Thread Alberni-dot-Net
I have been trying for the last while to come up with a query that will do the following: Say I have table with these records: StartDate StopDate --- 2001-01-23 23:43:12 2001-01-24 04:29:12 2001-01-24 15:24:00 2001-01-26

RE: Betr.: Hello

2001-03-28 Thread jjdirect
Speaking of books on MySQL are there more than one to choose from? If so is MySQL written by Paul DuBois the best one? John Jackson Direct Access Recruiters [EMAIL PROTECTED] -Original Message- From: B. van Ouwerkerk [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 5:03 AM

RE: GROUP BY behaviour.. help needed..

2001-03-28 Thread Rick Emery
What response/results are you getting? Tt would help us to determine the problem -Original Message- From: James Cox [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 7:13 AM To: [EMAIL PROTECTED] Subject: GROUP BY behaviour.. help needed.. Hello, This is the following SQL

RE: running Mysql client

2001-03-28 Thread Rick Emery
Was a password defined when you granted permissions to the user? -Original Message- From: Hammad Nasim [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 2:43 PM To: [EMAIL PROTECTED] Subject: running Mysql client Hi I am having some problems running mysql client. I can connect

Re: web-based accounting system

2001-03-28 Thread B. van Ouwerkerk
I hope someone could tell me where to find one. Off-topic, take a look at www.php.net for php scripts. Otherwise checkout www.cgi-resources.com Bye, B. - Before posting, please check:

Re: GROUP BY behaviour.. help needed..

2001-03-28 Thread James Cox
Hi Rick, I actually fixed that problem - it was due to the fact that the GROUP BY and ORDER By statement were mixed up :( still don't understand groups well, though :( Thanks, James Cox - Original Message - From: "Rick Emery" [EMAIL PROTECTED] To: "'James Cox'" [EMAIL PROTECTED];

Reg. Synchronization between MySQL DBs

2001-03-28 Thread Aigars Grins
Hi, The short version: Does anyone know an automated way of keeping two MySQL db's (located on different machines) in sync? A small window of non-sync could be acceptable. The long version: I'm working on a project which basically is about capturing a lot of data from different places and

Locks !!! Help !!!

2001-03-28 Thread P.V. Sajan
Hello All !!! I've 2 tables in a Shopping Cart Servlet TransactionTable is having a one to many relation with OrderTable create table TransactionTable ( TransId Integer Not Null Auto_Increment Primary Key, OrderDate TimeStamp, Not Null , GrandTotal Double Not Null , FullName VarChar(40) Not

Re: Reg. Synchronization between MySQL DBs

2001-03-28 Thread Mat Murdock
Did you look at doing something with replication? Mat Your mouse has moved. Windows must be restarted for the change to take effect. Reboot now? [ OK ] - Original Message - From: "Aigars Grins" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 28, 2001

Re: Reg. Synchronization between MySQL DBs

2001-03-28 Thread Ralph Graulich
Hi, Does anyone know an automated way of keeping two MySQL db's (located on different machines) in sync? A small window of non-sync could be acceptable. Read about "replication" in the corresponding chapters in the online manual of mySQL (http://www.mysql.com/) - Documentation. Regards ...

Coldfusion/MySQL - Connection Failed

2001-03-28 Thread Tanya Brethour
Hi! Let me try to restate my question and provide more information. Running: Linux 2.2.16-3, Coldfusion 4.5, MySQL 3.23.33 Problem: "The connection to the data source failed. Check the following to resolve this problem: ..." Now, I get this error on one database called xprojects while I can

Is it possible to use an optional field?

2001-03-28 Thread Roy Nasser
Hi, I have two joined tables (three actually, but for an example, 2 is OK)... example: Names / Function Then in names I have NameID, Name, and FunctionID, and in Function table, I havce FunctionID, and FunctionName... therefore, I need to find the Function Name of a Person, through their

error in unzip

2001-03-28 Thread Shahid Iqbal
I have Solaris 2.6 on a SUN E450 I downloaded the mysql-3.23.36.tar.gz from some site and now when i unzip it using gunzip mysql-3.23.36.tar.gz | tar xvf - it gives me tar: directory checksum error please help I have downloaded the file mysql-3.23.36.tar.gz twice and unzipped it twice, i get

Re: Reg. Synchronization between MySQL DBs

2001-03-28 Thread nigel wood
On Wed, 28 Mar 2001, Aigars Grins wrote: Hi, The short version: Does anyone know an automated way of keeping two MySQL db's (located on different machines) in sync? A small window of non-sync could be acceptable. The long version: snip The important question is how much availability

RE: Is it possible to use an optional field?

2001-03-28 Thread Roy Nasser
I took a look at the manual, but I am a bit unsure of how this would be done in a multi-table wuery, such as the one below... if anyone can help, greatly appreciated! :) SELECT DISTINCT Questions.QuestionID, Questions.Question, Experts.ExpertFullName, Category.CategoryName, Questions.Shows,

Re: Is it possible to use an optional field?

2001-03-28 Thread btjones
Assuming that there is a one-to-one relationship between the tables on the FunctionID (meaning there is only one entry in Functions for each FunctionID), then... SELECT Names.NameID, Names.Name, Names.FunctionID, Functions.FunctionName FROM Names LEFT JOIN Functions ON

Re: Reg. Synchronization between MySQL DBs

2001-03-28 Thread Aigars Grins
From: "Ralph Graulich" [EMAIL PROTECTED] Read about "replication" in the corresponding chapters in the online manual of mySQL (http://www.mysql.com/) - Documentation. From: "Mat Murdock" [EMAIL PROTECTED] Did you look at doing something with replication? Thanks for the quick reply. I hadn't

Re: Reg. Synchronization between MySQL DBs

2001-03-28 Thread Aigars Grins
Tnx for the answer. From: "nigel wood" [EMAIL PROTECTED] The important question is how much availability ( the ability to survive network partitions) your looking for: 1) Is simple master -- slave replication good enough for your application ? all inserts updates going onto the Master the

Coldfusion/MySQL

2001-03-28 Thread Tanya Brethour
Nevermind about my previous posts I got it to work! -Tanya - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread,

Re: Is it possible to use an optional field?

2001-03-28 Thread Eric Fitzgerald
Your query converted to using left joins: SELECT DISTINCT Questions.QuestionID, Questions.Question, Experts.ExpertFullName, Category.CategoryName, Questions.Shows, Questions.Views FROM Questions LEFT JOIN Experts ON (Questions.ExpertID = Experts.ExpertID) LEFT JOIN Category ON

RE: error in unzip

2001-03-28 Thread Khan, Moin
try to use gtar from www.mysql.com there is some known problem in solaris tar file... -Original Message- From: Shahid Iqbal [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 3:04 PM To: [EMAIL PROTECTED] Subject: error in unzip I have Solaris 2.6 on a SUN E450 I downloaded

RE: Is it possible to use an optional field?

2001-03-28 Thread Roy Nasser
I think I got it working... thanks! I had a few pretty complex queries, so it took a little while to understand, and then convert all of them! :) -Original Message- From: Eric Fitzgerald [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 8:56 PM To: Roy Nasser; 'nigel wood';

RE: Complex SQL Query

2001-03-28 Thread Alberni-dot-Net
Actually, these are a portion of a table that's contents are generated by Radius records imported into a MySQL table, so both values are generated simultaneously (or, at least as far as MySQL as concerned). -Original Message- From: Oson, Chris M. [mailto:[EMAIL PROTECTED]] Sent:

Counting distinct rows

2001-03-28 Thread emoticon
Hi, I am trying to count all the distinct id numbers in a column but I just can't figure it out... What would be the appropriate select statement for this, thanks, - Before posting, please check:

Re: Counting distinct rows

2001-03-28 Thread Paul DuBois
At 8:32 AM +0800 3/29/01, [EMAIL PROTECTED] wrote: Hi, I am trying to count all the distinct id numbers in a column but I just can't figure it out... What would be the appropriate select statement for this, thanks, SELECT COUNT(DISTINCT id) FROM tbl_name -- Paul DuBois, [EMAIL PROTECTED]

Re: Counting distinct rows

2001-03-28 Thread Gary Huntress
I'd try: Select distinct count(id) from myTable; Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://superid.dyndns.org:8080/freesql/index.php "Currently 100% Slogan Free" -

Re: MySQL books

2001-03-28 Thread Lindsay Adams
The O'Reilly MySQL msql book is not bad, but then I bought Paul DuBois' book, and now I only use the command reference at the back of the O'Reilly book for quick lookups. I like the way it is layed out. Every other question relating to MySQL has been answered by Paul's book. On 3/28/01 1:28 PM,

Re: Counting distinct rows

2001-03-28 Thread Thalis A. Kalfigopoulos
SELECT COUNT(DISTINCT ID) FROM my_table; Note: NULL values will be omitted from the count. regards, thalis p.s. would be a good idea to read an SQL tutorial before your next post On Thu, 29 Mar 2001 [EMAIL PROTECTED] wrote: Hi, I am trying to count all the distinct id numbers in a

Re: running Mysql client

2001-03-28 Thread Lindsay Adams
If the user was defined using a password, then you must use the password. If the user was defined without a password, then you must NOT use a password. Since the userid is unique key in the grant tables, you can't have it both ways. Pick one and go with it (best to use the password) If you

Re: Is this a normal behaviour?

2001-03-28 Thread --==[bMan]==--
Thanks. Just needed a confirmation. :-) Cal Evans wrote: Yes and I believe it's explained in the manual better than I can explain it here. Roughly speaking, if the field contains: foobar then LIKE 'foo%' says match anything starting with foo. Since it's STARTING with foo then the

-t option in mysqladmin

2001-03-28 Thread John Cartwright
Hello All, I see a -t or a --timeout= option listed for mysqladmin, but I can't seem to get mysqladmin to recognize it. Is this an oversight in documentation or a case of my misunderstanding? My objective is to be able to ping each of our mysql servers with a script and report on their health.

RE: Perl - DBD:DBI Errors

2001-03-28 Thread Chris Becker
Is the zlib on CPAN? like module Compress::Zlib ? Many Thanks Gerald! ChrisB MCSE MCDBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Wednesday, March 28, 2001 9:26 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl -

mysql_info() returns an empty string

2001-03-28 Thread Peter Radig
Description: mysql_info() returns an empty string as the return value for a successful insert/load data. Furthermore, mysqlimport does not give the same information: peter@ulisse ~/develop/seler $ mysqlimport --local -u seler seler foo seler.foo:

Re: myisam upgrade problem

2001-03-28 Thread Hang
Thanks! So, is there any way to calculate the approximate disk space required for the transformation from ISAM to MYISAM? Gerald Clark wrote: error 28 is "No space left on device". Hang wrote: Greetings, I am upgrading my mysql from 3.22.23b to 3.23.35 on RedHat with kernel

Re: myisam upgrade problem

2001-03-28 Thread Benjamin Pflugmann
Hi. On Thu, Mar 29, 2001 at 10:47:54AM +0800, [EMAIL PROTECTED] wrote: Thanks! So, is there any way to calculate the approximate disk space required for the transformation from ISAM to MYISAM? I would have assumed 330MB and don't see the reason why it should use more. Obviously I am wrong

Re: myisam upgrade problem

2001-03-28 Thread Lindsay Adams
Alternate solution, mysqldump --add-droptable db_name table_name path/with/a/lot/of/room/table_name.sql Edit your file and change the table create clause to include TYPE = MYISAM after the column defs. Ie: CREATE TABLE table_name (column1 def, column2 def,...) TYPE = MYISAM Then: mysql dbname

RE: MySQL books

2001-03-28 Thread jjdirect
I was at the store tonight. Did not see an O'Reilly book but believe I saw the book by Paul DuBois. There was also a book, one of the Teach Yourself (MySQL) in 21 Days, series. Anybody familiar with that one? John Jackson [EMAIL PROTECTED] -Original Message- From: Lindsay Adams

Re: MySQL books

2001-03-28 Thread Yann Larrivée
I got the PaulDubois book , but i made a mistake i bought the transaltion in french. An advice to all others who are thinking of buying it in french if you can buy it in englis , Yann - Original Message - From: [EMAIL PROTECTED] To: "Lindsay Adams" [EMAIL PROTECTED]; [EMAIL

Freeing Pointer outof range

2001-03-28 Thread Hari Krishna
"Freeing pointer out of range at line 102" this is the message generated in the error file of the Apache Web Server logs directory. The line 102 in the program refers to the connectivity command for my sql through 32-bit ODBC driver. We are working on windows NT and MySql 3.23 . The error file

RE: got EJB error

2001-03-28 Thread Tony Shiu
Hi I have not used EJB app server with MySQL w/ BDB support. Indeed I used Jrun with Sybase for feasibility test. But for setting AutoCommit, I suggest u'd check MySQL JDBC whether it supports to disable auto commit. If it can, try to run your JDBC code to disable instead of running in

Fulltext problem

2001-03-28 Thread Morgan Norell
Hi I'am new to sql and I have a problem with a full text dokument in my database. Is there any way to edit a full text dokument in mysql ? ** Regards Morgan Norell System Administrator Euro Business Link www.ebl.se

Mysql + Staroffice

2001-03-28 Thread M. Verheijen
Dear reader, Maybe this question is slightly off-topic, but what the hell ;) I'm the sysadming for a little firm which use a few Windoze computer and a lot of linux/BSD-servers. The windoze computers are used by the accounting staff and use Staroffice 5.2 as their Office application. There is

RE: MySQL books

2001-03-28 Thread B. van Ouwerkerk
I was at the store tonight. Did not see an O'Reilly book but believe I saw the book by Paul DuBois. There was also a book, one of the Teach Yourself (MySQL) in 21 Days, series. Anybody familiar with that one? I would go for Paul's book (he should pay me for everytime I refer to his book :))