Clean way of execution of query....

2001-07-03 Thread Asha Ramaiah
Hey! guys! I wanted a little help on the following : .. Scenario: I have 2 tables : one task and the other tasksequence desc task : (primary key taskId, varchar taskdesc) desc tasksequence (primary key (taskId,milestoneId)) Now the query I want to form should give me a list of all taskIds in

RE: Data Binding

2001-07-03 Thread Don Read
On 04-Jul-01 Ken Sommers wrote: > Dynamic HTML (DHTML) promises to change radically the way developers build > Web applications. It empowers the client end of the Web server/browser > relationship. The DHTML feature most oriented to the needs of database > developers is data binding. Data binding

Multidatabase systems - Sybase ASE/CIS

2001-07-03 Thread Tom Brettin
I manage several MySql Databases, each with some overlapping features. I would like to set up a multidatabase management system (federated database). Sybase has a product that at one time was called Omni Connect, and now is part of ASE 12.x called CIS. Also, Direct Connect somehow fits in this

RE: MySQL with perl error

2001-07-03 Thread Dawn H
The error log says, Can't call method "do: on an undefined value. . . But the EXACT SAME code works on another script I'm running. I don't see any reason for it to suddenly have a problem. What does this error message MEAN? Code Snippet-- # Form was okay; get image type and cont

case insensitive

2001-07-03 Thread Michael Ott
hallo! in my table i have a column with the caracter char and binary. how can i search case insenitive? -- Gruß & bye Michael Ott - - Siemens AG - I&S IT PS 51 ERL - - Werner-von-Siemens-Strasse 60 - - 91050 Erlangen- - Tel. +49 91 31 7 42

Re: help meeeeeeeee

2001-07-03 Thread ryc
> Hi, > > I am working on a banking project. > > we are planning to take our tour into vb/mysql combination. > > Please help me sending your comments. Where would you like help sending my comments to? heh. It sounds like you are asking for comments reguarding your choice of vb/mysql... If that i

Re: What's the best os?

2001-07-03 Thread Jeremy Zawodny
On Sat, Jun 02, 2001 at 01:49:59PM +0400, Ilya Martynov wrote: > >> AFAIK you can compile mysql on FreeBSD with LinuxThreads (they have > >> been ported on FreeBSD). In this case threads will spread across the > >> CPUs as on Linux. > > JZ> Funny you mention that... It comes up once in a while, b

Official binaries core dump (Solaris 8 x86)

2001-07-03 Thread Phil Dibowitz
Hey all, the following bug report follows the mysqlbug spec, but if I can provide any other information, please let me know. Thanks. >Description: I've installed the offical binaries from the mysql site and upon attempt ing to start the server, it core dumps. >How-To-Repeat: Any

How delete the first register in a table?

2001-07-03 Thread Lucio Braga
How can i do to delete the first row, tuple, register of a table? - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 02, 2001 1:18 PM Subject: mysql Digest 2 Jul 2001 16:18:37 - Issue 1365 -

Re[2]: Trouble with mysql

2001-07-03 Thread Michael Widenius
Hi! > "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes: Peter> Hello Michael, Peter> Thursday, June 28, 2001, 11:41:57 PM, you wrote: Peter> I'm getting this again and again with two tables which are used in Peter> quite the same fation - some selects, often updates, rare inserts, no P

Re: Ms-Access vs MySQL

2001-07-03 Thread jay downs
Even on a small scale. The measure I use is, if there are going to be more than 3 concurrent users on the database at anyone time and the database does more than keep recipes, its time to move to SQL. I've had nasty times with MS Access when 4 or 5 people hit a database at the same time. It ten

Data Binding

2001-07-03 Thread Ken Sommers
Dynamic HTML (DHTML) promises to change radically the way developers build Web applications. It empowers the client end of the Web server/browser relationship. The DHTML feature most oriented to the needs of database developers is data binding. Data binding can deliver data asynchronously from a s

help meeeeeeeee

2001-07-03 Thread Veerappan Rajendrakumar
Hi, I am working on a banking project. we are planning to take our tour into vb/mysql combination. Please help me sending your comments. Thank you, V.Rajendrakumar. Buy Feng Shui Package for Rs. 151/- only, at http://shopping.rediff.c

Re: Insert queries add TWO records to database

2001-07-03 Thread David Robley
On Wed, 4 Jul 2001 01:24, John (*\\*) wrote: > Operating system: WinNT4 > PHP version: 4.0.6 > PHP Bug Type: MySQL related > Bug description: Insert queries add TWO records to database > > All my insert queries seem to add two records to the database instead > of one. > > I was using MS

Re: Can't connect

2001-07-03 Thread Rolf Hopkins
Possibly because you haven't started the server. The manual contains information on this error in more detail. - Original Message - From: "MikeBlezien" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 04, 2001 6:27 Subject: Can't connect > What is the recommended proce

Re: SELECT query

2001-07-03 Thread Rolf Hopkins
- Original Message - From: "Craig Meyers" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 04, 2001 3:20 Subject: SELECT query > List, > > Our site is running mysql server version 3.22.32 > I'm a power user - not the DBA, so forgive my ignorance. > > Is it possible to c

Re: Ms-Access vs MySQL

2001-07-03 Thread Rolf Hopkins
MySQL doesn't support certain features such as foreign keys and sub-selects but may do so in the future. This is documented in the mysql manual. MS Access is not very suitable for networks especially on a large scale. - Original Message - From: "Wavyx" <[EMAIL PROTECTED]> To: <[EMAIL PR

Re: INSERT problem

2001-07-03 Thread David Robley
On Tue, 3 Jul 2001 23:01, Glyndower wrote: > Hi all, > > I'm new to the whole PHP and MySql stuff and I hopeful that I can get a > push in the right direction for what I'm sure is a very sinple problem. > > I have succesfully created a databse using telnet and added data to it > also using telnet

Question about DELETE and Index.

2001-07-03 Thread Fournier Jocelyn [Presence-PC]
Hi, Does DELETE take advantage of index to locate more quickly row to be deleted ? Thank you :) Jocelyn Fournier Presence-PC

Re: users in MySQL

2001-07-03 Thread Sherzod Ruzmetov
Sent on Jul 3 by Daniel Aderhold to [EMAIL PROTECTED] aderho> Can anyone give the adress of another manual of MySQL (not from mysql.com). Why is that ??? The manually you're not willing to use is indeed the *official* manual, which also means the more comprehensive one you can think of. If yo

users in MySQL

2001-07-03 Thread Daniel Aderhold
Hi. Thanks all for your help. I'm new to MySQL. I'm using win98. Can anyone give the adress of another manual of MySQL (not from mysql.com). Specially I don't know how to manage users in MySQL. Can anyone give me a short explanation? Regards, Daniel Aderhold

Can't connect

2001-07-03 Thread MikeBlezien
What is the recommended procedure to correct this error: "...Can't connect to local MySQL server through socket '/tmp/mysql.sock'.." We seem to encounter this error quiet often. THX, Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Inter

core dump on new installation

2001-07-03 Thread sdb
>Description: ./scripts/mysql_install_db fails on a new installation with: Creating db table Creating host table Creating user table Creating func table Creating tables_priv table Creating columns_priv table longjmp botch. Il

transaction logs using nt4

2001-07-03 Thread Pete Kuczynski
Hi, I'm still trying to get an answer to this. When restoring a database [in the event of a disk crash for example], I would run my restore from tape and rebuild the database, then I would take the transaction logs and upload those into the database to bring it up to date. >From what I cen tell,

Re: bad date comparaison for dates like '00??-??-??'

2001-07-03 Thread Dibo Chen
Remi Catherinot wrote: > > >Description: >I have a table that stores only dates, no other fields. Whenever the date value >is set to '0001-06-01', even if the row appears in my SELECT queries, no UPDATE, >DELETE or REPLACE can alter that row. >I've tested it with other date as well, lik

MySQL Users in Hawaii?

2001-07-03 Thread Kaj S. Arnö
Hello, My name is Kaj Arnö and I joined MySQL AB as VP Training on 1 June 2001 (see http://www.mysql.com/news/article-69.html). I'm a long time friend of Monty, since we went to school and university together, and I have followed his coding since 1978. After the upcoming O'Reilly Open Software Co

bad date comparaison for dates like '00??-??-??'

2001-07-03 Thread Remi Catherinot
>Description: I have a table that stores only dates, no other fields. Whenever the date value is set to '0001-06-01', even if the row appears in my SELECT queries, no UPDATE, DELETE or REPLACE can alter that row. I've tested it with other date as well, like '0001-04-12', the same problem a

SELECT query

2001-07-03 Thread Craig Meyers
List, Our site is running mysql server version 3.22.32 I'm a power user - not the DBA, so forgive my ignorance. Is it possible to corrupt data with a SELECT query? The connection is made via a shell script: mysql -h servername -u userid -ppassword database < --

Re: MySQL HELP -- Unable to start Win2k service

2001-07-03 Thread Pete Kuczynski
Only time I had this error on a NT4 server was when I attempted to get logging to work and I made a mistake editing the mycnf and myini files. When I cycled the mysql service, it would no come back up. Removing the offending edit allowed it to start. Pete Michael Tam wrote: > > Hi all, > >

Re: MySQL on FreeBSD 4.1 OS

2001-07-03 Thread Ken Menzel
Hi Mike, We started with Fbsd 4.1 which seemed to run OK with MySQL, do NOT use 4.2 as it has threads bugs, but I would really recommend 4.3 has it has the bugs worked out, a great port of mysql (in /usr/ports/databases) and is faster. Ken - Original Message - From: "MikeBlezien" <[E

Re: Problem with count() - URGENT

2001-07-03 Thread Kenneth Kopelson
Just to point out, you did not describe t2 in this email, but you have redescribed t1 again, and not table t2. Also, from looking at your query, I can see the following things: If you did not have the where condition checking for the timestamp, then you would get the entry for "four" since th

Re: Possible bug in InnoDB

2001-07-03 Thread Heikki Tuuri
Hi! One more question: does the query work if you remove the ORDER BY? What does EXPLAIN say then? Regards, Heikki -Original Message- From: Heikki Tuuri <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Tuesday, July 03, 2001 9:44 PM Subject: Re: Possible bug in InnoDB

Re: Problem with count() - URGENT

2001-07-03 Thread Kenneth Kopelson
Just to point out, you did not describe t2 in this email, but you have redescribed t1 again, and not table t2. Also, from looking at your query, I can see the following things: If you did not have the where condition checking for the timestamp, then you would get the entry for "four" since th

Re: MySQL HELP -- Unable to start Win2k service

2001-07-03 Thread Michael Tam
Hi all, Thank you for giving me direction to where I should look into the problem. I finally fix the problem which is coming from a mistake that I made in my.ini. Regards, Michael

Re: Reporting Tool : Linux?

2001-07-03 Thread Pete Kuczynski
The ez way, use Mysqlfrom to access you database, run a query to extract the data you wisk, save it as html, looks very nice. http://www.anse.de/mysqlfront/download.php Regards, Pete Mazur wrote: > > :-) Ya, I was thinking I would try to stay away from formatting in HTML, > and let the tool d

Compiling mysql

2001-07-03 Thread David Hudgins
I am having trouble compiling mysql on and HP 9000 running HP-UX 10.20. I installed gcc 2.95.3 binaries and followed the instructions in the documentation page concerning the problem with MIT-pthreads (CFLAGS="-DHPUX -I/opt/dce/include" CXXFLAGS="-DHPUX -I/opt/dce/include -felide-constructors -fn

Re: Error Codes

2001-07-03 Thread Fletcher Sandbeck
On 7/3/01 at 12:48 PM, Gerald Clark wrote: > Check the source for mysqld_error.h Thanks. I have seen these, but I was hoping for a list with more explicit descriptions. My current plan is to go through this list and take descriptions from the manual/books for each error that I can locate, but

links

2001-07-03 Thread Simon K. Chan
Hey Everybody, I have an online database where I use a CGI script that uses the DBI to return values from Mysql. How do I return a LINK? For example, if I have a database for hockey players, and I return the name "Wayne Gretzky." Is there a way to make that a link that will go to say, NHL.com

Re: FINALLY, got a core!

2001-07-03 Thread Sasha Pachev
On Tuesday 03 July 2001 06:35, Tuc wrote: > Hi, > > Well, 45 days later after doing everything I could to get it to > dump a core (3.22.32), it did! > > So, the results are : > > Program terminated with signal 11, Segmentation fault. > #0 0x808bfef in get_best_combination (join=0xc

RE: SELECT form element with PHP/MySQL

2001-07-03 Thread Nelson Goforth
Thanks to Gerald, Werner, Gerlinde and Josh for help with the SELECT form element. Gerald's was the simplest, most pragmatic solution, but I ended up figuring out something that was a bit more like Gerlinde and Josh suggested, but saving on a real 'if-then-else' loop and doing it all in one l

fake ubsubs

2001-07-03 Thread Gerald Clark
I'v been getting them too. [EMAIL PROTECTED] wrote: > Why do I keep getting Unsubscribe notices? Am I that anoying LOL. > > > Cheers > > M ;-) > > Got MySQL > > > - > Before posting, please check: >http://www.mysql.co

Re: MySQL HELP -- Unable to start Win2k service

2001-07-03 Thread Michael Tam
Hi guys, I have done the isamchk and nothing came up from there and the error log didn't reflect much to indicate any problem with the grant table. Where should I look into next ?? Thanks. Regrads, Michael - Original Message - From: "Werner Stuerenburg" <[EMAIL PROTECTED]> To: "

MySQL on FreeBSD 4.1 OS

2001-07-03 Thread MikeBlezien
Hello all, We are looking at setting up on dedicated server with the FreeBSD 4.1 OS and was wonder how well MySQL has worked on this O/S. We would like to compile it with Innobase if possible. Appreciate any feedback, recommendations, pro/cons... etc.. THX Mike(mickalo)Blezien ===

Re: Error Codes

2001-07-03 Thread Gerald Clark
Check the source for mysqld_error.h Fletcher Sandbeck wrote: > I am looking for a concise listing of all the error codes that MySQL might > return after issuing a SQL statement. The manual and other books I've checked > have descriptions of the errors, but don't seem to collect them all into o

Installation Problems on Solaris 8 box

2001-07-03 Thread Larry Caragay
I have been trying to install Mysql on a Solaris 8 box. Would anyone know what I need to install prier to installing Mysql??? The Solaris box is a fresh install. Thanks in advance, [EMAIL PROTECTED] - Before posting, please ch

Re: Funny :-)

2001-07-03 Thread Sherzod Ruzmetov
LOL, No you are not (i guess). It's just this mailing list software that stupid :) So ignore it. Afterall, even though you are Annoying, that's this mailing list software making you annoying , isn't it :) -- sherzod_ruzmetov (sherzodR) email: <[EMAIL PROTECTED]> So what if I have a fertile brai

RE: java connection

2001-07-03 Thread Daniel Aderhold
Must I install additionally anything to use this driver "org.gjt.mm.mysql.Driver" ? I already have installed the JDK and MySQL. My system is Win98, and I'm making my first apps in Java and MySQL in my home PC. If the database name is "lalibertad": Then the url is: "jdbc:mysql://localhost/laliber

Ms-Access vs MySQL

2001-07-03 Thread Wavyx
Hi, I'm currently looking for a comparison between Access and MySQL. I mean a table with the advantages and inconvenients of both. I found the bench on mysql.com but I need a comparison not only a bench. Thanks for help Wavyx

Re: Question (fwd)

2001-07-03 Thread William M. Quarles
-- Forwarded Message -- Date: Tuesday, July 03, 2001 1:03 PM -0400 From: "William M. Quarles" <[EMAIL PROTECTED]> To: Rafael Marcus <[EMAIL PROTECTED]> Subject: Re: Question Yes, absolutely, those are fundamental commands. You probably have not set up your access privileges pro

Error Codes

2001-07-03 Thread Fletcher Sandbeck
I am looking for a concise listing of all the error codes that MySQL might return after issuing a SQL statement. The manual and other books I've checked have descriptions of the errors, but don't seem to collect them all into one reference. Thanks, [fletcher] -- Fletcher Sandbeck

Re: INSERT problem

2001-07-03 Thread Werner Stuerenburg
> I have succesfully created a databse using telnet and added data to it also > using telnet. Why not do it with myPhpAdmin? Google shows you the address. Very convienient. It pays at least in the long run - you won't bother with telnet to maintain your db. > I have also succesfully got the dat

Funny :-)

2001-07-03 Thread massey
Why do I keep getting Unsubscribe notices? Am I that anoying LOL. Cheers M ;-) Got MySQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list arch

Question

2001-07-03 Thread Rafael Marcus
Hello, The product is very helpful and works fine in general. I tried to use "create table" and "edit tables" in the "Commands", "Tables" menu but there is no response. Are these supposed to work in this version? If yes how I should set it up. Thanks, Rafael.

Re: Update table using regular expressions MySQL

2001-07-03 Thread Hannes Niedner
Thanks Karel, This worked almost out of the box, just needed to find out that 'len+1' has to be replaced with the actual number and is not automatically set (like len = length('CONSTANT%'). But the manual also explains this very well, I just didn't think of substring. Hannes On 7/3/01 9:13 AM,

RE: Urgent:MySql problem

2001-07-03 Thread massey
Was this an install from the RedHat CD? If so then remove and reload with the current stable version from MySQL's site. This has happend to alot of folk here Cheers -Original Message- FROM: Antonio Carlos Venancio Junior TO: sachin CC: [EMAIL PROTECTED] DATE: Tue 7/3/01 10:26 SUBJECT:

RE: Urgent:MySql problem

2001-07-03 Thread Antonio Carlos Venancio Junior
Sachin, MySQL is not running. Check the logfiles to see whats wrong ... ;) On 01-Jun-2006 sachin wrote: > Hello, > I am working on RH Linux 7.0 > MySql is not working at all. > My MySql files are under /usr/bin. > > It gives the following error on running any mysql command > >

Re: Looking for list of ckocking charecters

2001-07-03 Thread Werner Stuerenburg
> I'm trying to insert varchars into a field with a Insert and update > query. Does anyone have a complete list of the charecters that need to be > escaped/dealt with in order to get problem free queries on the INsert and > Updates. > ex. ' needs to be replaced with '' I work with php. They have

Re: MySQL HELP -- Unable to start Win2k service

2001-07-03 Thread Werner Stuerenburg
>I have tried to remove the service, uninstalled the mysql and reinstalled it. I >got the same result. Looks like the problem may be with a dirty shutdown and problems in tables. Try to run isamchk. Maybe this helps. -- Herzlich Werner Stuerenburg ___

Insert queries add TWO records to database

2001-07-03 Thread John (*\\*)
Operating system: WinNT4 PHP version: 4.0.6 PHP Bug Type: MySQL related Bug description: Insert queries add TWO records to database All my insert queries seem to add two records to the database instead of one. I was using MS Access 2000 and did not have the problem. I am now using MySQ

Re: ERROR :Can't find file: './mysql/host.frm' (errno: 13)

2001-07-03 Thread Gerald Clark
No, that is permission denied. chown -R mysql /var/mysql ( or whatever data path is ) Werner Stuerenburg wrote: > The error indicated means that the table host is missing. > > I would reinstall the package. If it doesn't work, I would > download the latest package from mysql.com and install t

Update table using regular expressions MySQL

2001-07-03 Thread Hannes Niedner
I want to update 160 records in a table. The field contains a variable value and a constant prefex like 'constant: unique value for this record' Is there such an UPDATE statement that would update this field into 'unique value for this record' They way I would do it otherwise is using Perls re

db connection.

2001-07-03 Thread Rohan Manohar
Hi, What exactly are the steps to connect a machine to db in another machine(mysql configurations, perl-cgi as well as C APIs)? Are there any prerequisites? Is it possible to connect from a machine which does not have mysql installed in it? Kindly answer. Thanks, Rohan M ___

Problem with count() - URGENT

2001-07-03 Thread Ireneusz Piasecki
I have 2 tables: 1) t1 mysql> describe t1; ++-+--+-+-++ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-++ | id | int(3) | | PRI | NULL| auto_increme

Possible bug in InnoDB

2001-07-03 Thread tianlin
I have the same problem with Mysql-3.23.39 compiled by myself running in Linux box. However the problem goes away if I alter table type from InnoDB to MyISAM. Therefore this problem is related with InnoDB. Here is the query which generates ERROR 1028: Sort aborted. SELECT service.sowid,servdate,re

please help: empty field on table merge

2001-07-03 Thread Patrick Sibenaler
I am currently experiencing a strange problem that I have not seen prior today. It appeared on an existing database without any changes in the DB version or the system (win2000). The problems describes as 'loss of the content of a column when selecting from two tables'. eg: I have two tables

RE: Re[2]: Reporting Tool : Linux?

2001-07-03 Thread Huntress Gary B NPRI
It's not just the calculation of the reports, but also the presentation. PHP is certainly capable of producing nice reports. But tools like Crystal Reports have their place. If you can find me another tool that can easily produce publication quality reports (headers, footers, proper page bre

FW: java connection

2001-07-03 Thread M. Obide
The driver name is: //be careful, case sensitive org.gjt.mm.mysql.Driver the url is jdbc:mysql://localhost/mydb of course replace mydb with your database name. There are 2 supported JDBC drivers for MySQL (the mm driver and the Reisin JDBC driver). You can find a copy of the mm driver at ht

Re[2]: Reporting Tool : Linux?

2001-07-03 Thread Werner Stuerenburg
> I just figured I can't be the first guy on the block that wants to design > reports out of MySQL without using Windows. I mean, I recall MySQL boasting > that NASA uses MySQL...what the heck do they use for reporting? Of course, > I suppose if you have MySQL on an NT machine, you can add Crys

Looking for list of ckocking charecters

2001-07-03 Thread Daniel McCutcheon
I'm trying to insert varchars into a field with a Insert and update query. Does anyone have a complete list of the charecters that need to be escaped/dealt with in order to get problem free queries on the INsert and Updates. ex. ' needs to be replaced with '' thanks in advance dan Daniel D. McCu

Re: ERROR :Can't find file: './mysql/host.frm' (errno: 13)

2001-07-03 Thread Werner Stuerenburg
The error indicated means that the table host is missing. I would reinstall the package. If it doesn't work, I would download the latest package from mysql.com and install that (it is the recommended path, anyway) - it works fine. -- Herzlich Werner Stuerenburg ___

Re: Create Login?

2001-07-03 Thread Werner Stuerenburg
> I need to create a new login for a already created > database. I have tryed to from the command prompt of > my windows 2000 adv server box. c:\mysql\bin>>Create User mark > c:\mysql\bin this is the directory > Create User mark There is no executable named Create. You have to start mysql

INSERT problem

2001-07-03 Thread Glyndower
Hi all, I'm new to the whole PHP and MySql stuff and I hopeful that I can get a push in the right direction for what I'm sure is a very sinple problem. I have succesfully created a databse using telnet and added data to it also using telnet. I have also succesfully got the data to display on a

count() problem - URGENT !!

2001-07-03 Thread Ireneusz Piasecki
I have 2 tables: 1) t1 mysql> describe t1; ++-+--+-+-++ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-++ | id | int(3) | | PRI | NULL| auto_increme

Re: restoring a database on nt4

2001-07-03 Thread Gerald Clark
Whith Unix it is: mysql database < logfile. Pete Kuczynski wrote: > I can't seem to find any documentation on how to set this up an a > windowz box. > > Can anyone help? > > Pete > > Gerald Clark wrote: > >> Run your transaction log against the restored database. >> >> Pete Kuczynski wrote:

Re: problems with float calculations?

2001-07-03 Thread Gerald Clark
Thomas J Keller wrote: > OK. Radius contains the radius, in miles, from the center of the Zipcode area. > In the following query, the latitudes and longitudes have been calculated to > yield a 20 X 20 mile square centered on the base Zipcode (in this case, 68504). > > +---+-+

Re: Problems installing Msql-Mysql-modules

2001-07-03 Thread Gerald Clark
You are missing libz. Vien Huynhle wrote: > href="file://C:\Program Files\Common Files\Microsoft Shared\Stationery\"> > This is what I have done > > > > [root@MySQL Msql-Mysql-modules-1.2216]# perl Makefile.PL > Which drivers do you want to install? > > > > 1) MySQL only > 2) m

Re: Initial setup in Linux RH7.1

2001-07-03 Thread Trond Eivind Glomsrød
Yi-chen Lan <[EMAIL PROTECTED]> writes: > When I try to run mysql, the system give an erroe message "Can't connect to > local MySQL server through socket '/var/lib/mysql/mysql.sock'. > I checked the above directory and found out there is no such file > 'mysql.sock'. > Please help me to solve th

FINALLY, got a core!

2001-07-03 Thread Tuc
Hi, Well, 45 days later after doing everything I could to get it to dump a core (3.22.32), it did! So, the results are : Program terminated with signal 11, Segmentation fault. #0 0x808bfef in get_best_combination (join=0xc244808) at sql_select.cc:1638 1638*j= *join->bes

Initial setup in Linux RH7.1

2001-07-03 Thread Yi-chen Lan
Hi, When I try to run mysql, the system give an erroe message "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'. I checked the above directory and found out there is no such file 'mysql.sock'. Please help me to solve this problem. P.S. MySQL has already installed a

Re: error in selecting database.

2001-07-03 Thread Dvořáček Michal
Hi, it's possible that db 'test' doesn't exists mysql should run, 'coz mysql_connect was successfull. check if you are connecting to right host and permissions from mysql (if usr1 has access to db test and have logon from another host other than localhost) but if mysql_error return this error -

error in selecting database.

2001-07-03 Thread Praveen
Hi, I try to connect to a database with the following code. #define host "192.168.105.105" #include "mysql.h" MYSQL mysql; int exiterr(int i) { fprintf(stderr,"%s\n",mysql_error(&mysql) ); exit(i); } int main(void) { /* . */ if (!(mysql_connect(&mysql,

Re: MySQL HELP -- Unable to start Win2k service

2001-07-03 Thread Miguel Angel Solórzano
At 03:45 03/07/2001 -0700, Michael Tam wrote: Hi, Take a look on \mysql\data\mysql.err file and see if exists a message error like that server doesn't find a grant tables. Otherwise, try to run the server standalone to see in the screen the error message: yourservername --standalone Fix the pos

Re: How to make symbolic link under windows

2001-07-03 Thread Miguel Angel Solórzano
At 17:16 03/07/2001 +0800, tpchan wrote: Hi, You can simulate the symbolic link on Windows using the today Win32 MySQL 3.23.39 distribution. You have in this distribution the following Max MySQL servers: 1- mysqld.exe the debug version. 2- mysqld-max.exe the optimized version for Win9x and NT/Wi

MySQL HELP -- Unable to start Win2k service

2001-07-03 Thread Michael Tam
Hi all, I have beening running mysql on my win2k for awhile. This afternoon, I have restarted my pc and the next thing I notice mysql service was unable to start. The following is the message I got: Could not start the Mysql service on Local Computer. Error 1067: The process terminated u

Re: Mac OS X MySQL GUI

2001-07-03 Thread Sinisa Milivojevic
Hannes Niedner writes: > Has anybody successfully compiled MySQL GUI on the Mac OS X platform (or > rather Darwin)? > > Hannes > I wish I had one, as I would have tried it. FLTK libs work on Mac, so it is quite doable. If you want to do it and please go ahead. If you encounter problems, let

Re: FW: ERROR 1028: Sort aborted

2001-07-03 Thread Sinisa Milivojevic
Cal Evans writes: > MySQL Error: > > ERROR 1028: Sort aborted > > Anybody know what this means? Ok, I can figure out what it MEANS, I'm > getting it on a rather complicated select statement with an order by clause. > Does it mean something specific like 'you need a better index' or is it just >

ERROR :Can't find file: './mysql/host.frm' (errno: 13)

2001-07-03 Thread [EMAIL PROTECTED]
I have installed mysql with rpm method (from cd ditribuition). But when i start the demon with the 'safe_mysql &' command, the demon stop immediatelly and i found the message in Subject in the /var/log/mysql.log file. The demon starts normally with the command

RE: selecting with LIMIT and including the total?

2001-07-03 Thread Bruce Stewart
How about something like this: SELECT title FROM news WHERE cond1 LIMIT 1, 10 union SELECT count(title) from NEWS WHERE cond1 LIMIT 1, 10 -Original Message- From: nsabbi [mailto:[EMAIL PROTECTED]] Sent: Tue, 03 July 2001 09:48 To: [EMAIL PROTECTED] Subject: selecting with LIMIT and inclu

Re: How to make symbolic link under windows

2001-07-03 Thread Sebastiaan J.A. Kamp
Unfortunately, "symbolic links" are a Unix / Linux feature, not Windows. Regards, Sebastiaan J.A. Kamp > Dear all, > > Did anyone now how to make symbolic link for mysql data directory under > Windows NT 4.0. Mysql data directory sits on C:\mysql\data\ecom and I would > like to transfer it to

How to make symbolic link under windows

2001-07-03 Thread tpchan
Dear all, Did anyone now how to make symbolic link for mysql data directory under Windows NT 4.0. Mysql data directory sits on C:\mysql\data\ecom and I would like to transfer it to D:\ecom. My Mysql version is 3.23.32, installed using the '.exe' file. I would like to know if this is possible? If

bin log question

2001-07-03 Thread Robin Keech
using the old update logs I could look inside them and use the contents to help debug dynamic SQL statements. How do I do the same with the binary log? I have tried mysqlbinlog hostname.001 but get ERROR: Could not read entry at offset 5 : Error in log format or read error The

selecting with LIMIT and including the total?

2001-07-03 Thread nsabbi
Hi, how to query a list of records limiting the score, but including the TOTAL of records satisfying the condition, all in one statement? i.e. SELECT title FROM news WHERE cond1 LIMIT 1, 10 plus SELECT count(*) from NEWS WHERE cond1 all in one. Thanks in advance Nico

Re: converting database as text

2001-07-03 Thread Sherzod Ruzmetov
Hi Alexandrino. Have you tried % mysqldump db_name [table_name] ? Try it -- Sherzod Ruzmetov [EMAIL PROTECTED] http://www.ultracgis.com/sherzodR Sent on Jul 3 by Alexandrino B. Arvesu to [EMAIL PROTECTED] alex> Hi, alex> alex> Is there a way of converting mySQL database to a readable