Compatability with Microsoft Access

2001-02-22 Thread cmcclan
Hello, My objective is to be able to access a "Microsoft Access" database, using ASP scripts on a Linux Apache server. Can I achieve database connectivity with an Access.mdb file localy on a Linux box using mySQL - i.e WITHOUT using some sort of ODBC bridging software. If there is a reliable

help! perl and MySQL Beginner Warning!

2001-02-22 Thread Thomas O'Neill
I have built a small guestbook using perl and MySQL when i try to run my perl script i get the following error. Software error: [Thu Feb 22 14:38:01 2001] DBI.pm: Can't locate DBI.pm in @INC (@INC contains: /usr/lib/perl5/5.00503/i386-linux /usr/lib/perl5/5.00503 /usr/lib/perl5/site_perl/5.005/i3

Copying a ddatabase from one server to another

2001-02-22 Thread Jeff Gannaway
Here's my situation I've been hosting my sites with one company for over a year and am now moving to a dedicated server operated by the same company. My existing database is large, containing around a dozen tables and over 5,000 entries. I want to copy the database structure and data to the

Re: web based admin?

2001-02-22 Thread John Jensen
Do you have a remote server? Do you have a lot of data to enter into your database? Ask yourself: Would you rather preface each and every insert with "INSERT [data] INTO [table.column] ...", than enter data by filling in blanks in a webform. Do you want to correct typos or otherwise ed

RE: help! perl and MySQL Beginner Warning!

2001-02-22 Thread Barry Radloff
Hi Thomas well it may be that the install put it in another directory other than in the ones listed below I too am a bit of a beginner with perl and mysql but I found my DBI stuff in another dir so I used the following in my perl script use lib "dir/path/here/to/libs"; This tells perl to look

Re: + or - in place of = does what???

2001-02-22 Thread Benjamin Pflugmann
Hi. WHERE expects a boolean expression, but user_num+"AL011-33" is no boolean expression. MySQL therefore assumes that the result of the expression should be considered as boolean value. Analogous to C and similar languages, it assumes the expression to be 'false', if it is zero (numbers) or e

RE: case sensitive selects

2001-02-22 Thread Carsten H. Pedersen
A comparison will be case sensitivie, if any sub-part of the expression is case sensitive. There are several ways to solve this: 1) CREATE or ALTER your tables so that the relevant CHAR and VARCHAR fields are of type BINARY; change TEXTs to BLOBs 2) Use a case-sensitive, but neutral function whe

Re: MySQL and JDBC: Communication link failure

2001-02-22 Thread Guenther Pewny
Try a) downgrading an _older_ mm.mysql driver, or, much better: b) upgrading to a newer (and non-alpha) mySQL database version. I've had exactly this problem every time I upgraded to a new mySQL version. Upgrading the driver, too, solved the problem in each case. For example, currently

Re : Question???

2001-02-22 Thread edith
Dear Sir/Madam, I'm a Visual FoxPro programmer. I want to use MySQL database for my programs. However, I cannot update MySQL database with my Visual FoxPro programs through ODBC (but I can view the record of table). My commands are as follow: CREATE CONNECTION conn1 DATASOURCE "MySQL"

RE: XML support under mySQL

2001-02-22 Thread Opec Kemp \( Ozemail \)
*big snip* I agree with Cal, the XML module should really be sperated from the RDMB. XML is really great but, lets face it not everyone is going to use it so why force it down thier troat?. The really great thing about Open Source is that you do have a choice (unlike MS , Oracle). :) You have to

Re: RE: XML support under mySQL

2001-02-22 Thread Ed Carp
Mehalick, Richard RE SSI-GRAX ([EMAIL PROTECTED]) writes: > Some relational databases return results in XML format. And operating systems have been written in Java and Perl. So? Just because you *can* doesn't mean you *should*. Suppose I want to translate the output to something else. Now I

Re: Youch!

2001-02-22 Thread John Jensen
Thank you. Re: On 21 Feb 2001, at 16:29, Atle Veka wrote: > where's your mysqld located? /usr/local/mysql/bin > just change your safe_mysql script to contain the correct location of > your mysqld binary. I thought that was what I was doing with "bin/safe_mysqld &" from /usr/local/mysql/ I wo

Re: Printed MySQL manual

2001-02-22 Thread Thalis A. Kalfigopoulos
> Denis: > > I'm not sure you really want a printed MySQL manual ... the software is > dynamic, and is constantly being upgraded. The online manual is updated > frequently, and is closer to the software you may be using. > > As an alternative, I would suggest one of the fine books on MySQL. Our

Problems on creating table

2001-02-22 Thread Pui Yin LEE [AP]
Dear Sir/ Madam, I'm using mySQL GUI Win32 to create a database. I managed to create a database but not a new table. What I did was that I created a database by using function Commands:Administration:Database:Create, and then I selected the database name from the database button(the one ne

problems relating DATE and LOAD DATA INFILE

2001-02-22 Thread altay ozaygen
hello everybody, I am a newbie to database. I have two quetions, 1- I am using MySQL which I intalled with the Mandrake 7.2. I have lots of data in txt file format with a date field having a configuration like dd/mm/ and I have to use it in that format. but MySQL have a /mm/dd how can I c

Access to Mysql ?

2001-02-22 Thread Christophe Suire
Hi, I would like to transform an Access database to a MySQL database .. I think there is no problem with doing an export of Access in CSV and an import in MySQL... The problem is .. in the Access db there some OLE Object which are images .. how to put them in the MySQL db ? Thanks. -- Christop

Re: Copying a ddatabase from one server to another

2001-02-22 Thread Guenther Pewny
Jeff Gannaway wrote: > mysqldump -uUSERNAME -pPASSWORD database > dbBackup.sql > and it created the dump file. I transferred it to the new server then > tried to load it into my new database using the following command: > > mysqldump -uUSERNAME -pMILLER31 database < dbBackup.sql Don't take

Newbie: ASP/ADO .addnew - last_insert_id() ??

2001-02-22 Thread Henrik Lebtien Mohr
Hi Everybody (hi Doctor Nick)! I use ASP and adodb.recordset to connect to a MySQL-database. I use the following code to insert into the db: [CODE START] set rsGroup = server.CreateObject("adodb.recordset") sql = "tblGroup" rsGruppe.Open sql, connect with rsGroup .AddNew

mysql@lists.mysql.com

2001-02-22 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release:

Linuux with mysql and c++ API

2001-02-22 Thread Jarle Rudihagen
Linux with mysql and c++API I'am trying to connect to an Mysql database trough c++ API (1.7.8) The program compiles just fine but when i try to run it I get the message Segmentation fault core dump When I try to run the program with the strace command I can see that the program connects to

Mysql PID Problem?

2001-02-22 Thread Weber, Jeff
Having problems starting mysql on my linux box. I think I've tried just about everything in the manual within reason. Please help out if anyone has an idea. The other day, mysql died on my system for no apparent reason. When I reboot the machine, based on the script in /etc/rc.d/init.d/mysql, mys

Re: Future suggestion

2001-02-22 Thread Jason Landry
> Also, specifying fields won't break things when people add fields to a > table. Yeah, but you already have the same problem with SELECT *. Let me give another example. You have a table with 15 rows. One of those rows is TEXT. You really do want everything except the text. Doesn't anyone e

Help me

2001-02-22 Thread Esko Lehtme
Hello I'm working out a programm what generates page visiting statistics, to help me to go http://www.seitse.ee and click some links. With best regards Esko - Before posting, please check: http://www.mysql.com/manual.php

Transactions in 3.23.33 ?

2001-02-22 Thread Bruce Percy
Has transaction management present in the 3.23.33 binary distribution of MySQL? When creating BDB tables and trying to use them inside transactions I fail to get them to work. There's no error messages and the transactions seem to be ignored. I've tried this on Linux and NT. -- Bruce Percy Peo

mySQL Lock Problem

2001-02-22 Thread myfriend4ever.com
hi, I like to write a multi-user program in internet by using mysql, do i need to use lock function to lock the table before i write or update anything to the table ? but some manual say we use it for maintenance purpose, is it right ? then how mysql handle the locking under multi-user environmen

Youch!

2001-02-22 Thread John Jensen
I had shut down the mysql daemon using: bin/mysql -u root -p[password] shutdown Now when I attempt to restart it using: bin/safe_mysql & it gives me the message: [1] 2564 The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Ple

maximum number of characters

2001-02-22 Thread Matt Davis
Hi Can anybody tell me what the maximum number of characters I can have in one field. Thanks Matt. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the lis

Problems with splitting data across different disks under Windows...

2001-02-22 Thread Patrick FICHE
Hi, I'm working under Windows 98 with MySQL version 3.23.29. I tried to connect to a database that is on a different disk from the data directory (g:\mysql\data). So I created a file g:\mysql\data\pfi.sym containing the path e:\databases\pfi. I compiled with the USE_SYMDIR option and launched the

Re: maximum number of characters

2001-02-22 Thread Peter Skipworth
Matt, Before posting to a mailing list, you should ensure you RTFM! Have a look at www.mysql.com and you'll find tha answers in the documentation. regards, P On Thu, 22 Feb 2001, Matt Davis wrote: > Hi Can anybody tell me what the maximum number of characters I can have in > one field. > >

Re: ranking album plays by city, help me beat Oracle

2001-02-22 Thread Benjamin Pflugmann
Hello. On Tue, Feb 20, 2001 at 03:27:08PM -0800, [EMAIL PROTECTED] wrote: > > Huh? You got it 7 times faster by only extracting that query from the > > for loop and changing it to a group by? Or did you do anything else? > > Sorry there were some other unnecessary queries that were mistakenly >

Re: Connecting via MyODBC always brings up the "TDX mysql Driver Connect" dialog

2001-02-22 Thread Pat Sherrill
Make sure you also have at least a user (and password as appropriate) filled out in the MyODBC Control Panel. Pat... [EMAIL PROTECTED] - Original Message - From: "Jan R Andersson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 21, 2001 10:22 AM Subject: Connecting

Problem compiling...

2001-02-22 Thread Cyril ZEKSER
Hi all, I've a little problem at the linking stage. I've always have the following error : >> g++ -g -o mainTest mainTest.o worldFactory.o -L/usr/local/OpenInventor26/lib >-limage -lInventor -lInventorXt -L/usr/lib/mysql -lmysqlclient -lsqlplus -lpthread -L/usr/X11R6/lib -lX11 -lGL -lGLU -lGL

nesting tables

2001-02-22 Thread revathi venkatraman
Sir, Is there this concept of nesting tables and varrays in mysql?. Iam creating a chemical compounds database. there are 20 field in this . Amongst them, I have a author field where there are multiple authors, amongst which one is common for all the records. suppose I query giving the common

Removing MySQL

2001-02-22 Thread Evan James Dembskey
Hi, How do you go about removing MySQL from a DEC Alpha box? Regards, Evan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: Printed MySQL manual

2001-02-22 Thread Paul DuBois
On Wed, Feb 21, 2001 at 04:05:06PM -0500, Thalis A. Kalfigopoulos wrote: > > Denis: > > > > I'm not sure you really want a printed MySQL manual ... the software is > > dynamic, and is constantly being upgraded. The online manual is updated > > frequently, and is closer to the software you may be

Re: nesting tables

2001-02-22 Thread Rolf Hopkins
What do you mean by "nesting tables" and "varrays"? What you have described is known as relational databases and a good idea would be to buy a good book on Relational Database Management Systems. - Original Message - From: "revathi venkatraman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]

Re: XML support under mySQL

2001-02-22 Thread Michael Bacarella
> > > XML will become a common and powerful way to express/exchange data > > > on the web. I hope MySQL decides to go along for the ride. > > > > This is all fine and good, but why does MySQL itself have to do this? > > > We don't want Microsoft and Oracle to take over the world, do we? :) The

Re: Compatability with Microsoft Access

2001-02-22 Thread Rolf Hopkins
Check out www.devshed.com. Right now it has a very good article on what you want. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 22, 2001 16:15 Subject: Compatability with Microsoft Access > Hello, > > My objective is to be able to acces

Exporting data from a MySQL database to an oracle database

2001-02-22 Thread Joe . O'Toole
Hi, I have a MySql database with customer information which is to be exported to an oracle database. I was wondering if someone could tell me the easiest way of doing this. Is there any such applications which look after the exporting of the data from the MySql database and importing to the new o

Re: So, what do you do with a "tarball" anyways.

2001-02-22 Thread Steve Ruby
"Matthew P. Marino" wrote: > > So, what do you do with a "tarball" anyways. Since compiling the source is > hopless( "sql_yacc.cc"), I'm looking for a binary. > then download the binary.. Or at least do a better job of describing your problem... ---

Re: Error when writing a sql statement into a field.

2001-02-22 Thread Ken Yiem
Hi , notice your last field in the Values section. 'query += "\"" + this.customerId + "\",";' get rid of the comma at the end. end replace it with a close'n bracket. notice the last field, you have one extra field in the values bracket. 'xxx","ccc

mysqldump output file not valid as input file for mysql client

2001-02-22 Thread loschert
>Description: As of mysql 3.23.33, a dumpfile generated with mysqldump (using the flags: --opt --all-databases) creates a file which will not be uploaded correctly using the mysql client (as in: 'mysql -u root -pXX -q -s < dumpfile.sql'). Specifically, the pro

Re: Transaction

2001-02-22 Thread Rolf Hopkins
- Original Message - From: "WANG_KING£¨Íõ¸Ö£©" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 22, 2001 13:51 Subject: Transaction > Does the newest version of mysql support transaction ? Sure does. > How does you solve your data integrity problem in your appliaca

Re: BDB Problem with MAX() and multipart primary keys

2001-02-22 Thread Sinisa Milivojevic
Guenther Pewny writes: > Hi folks, > > I have a problem with BDB tables. Please look at this short mysql session: > > mysql> create table sample ( > id1 int(8) not null, > id2 int(8) not null, > primary key (id1,id2)) > type=BDB; > Query OK, 0 rows affected (0.67 sec)

Re: problem with blob

2001-02-22 Thread Jay Brushett
Hi again. Just thought that I'd repost my message cause I think nobody was checking their mail when I first posted it. Not rying to spam or anything I just really need to figure this out. Thanks, Jay (see post below) At 07:45 AM 2/21/2001 +00-03, Jay Brushett wrote: >Hi, > >I'm new to MySQL

Re: Linuux with mysql and c++ API

2001-02-22 Thread Sinisa Milivojevic
Jarle Rudihagen writes: > Linux with mysql and c++API > > I'am trying to connect to an Mysql database trough c++ API (1.7.8) > The program compiles just fine but when i try to run it I get the message > Segmentation fault core dump > > When I try to run the program with the strace com

Re: XML support under mySQL

2001-02-22 Thread Ed Carp
Gorjan Todorovski ([EMAIL PROTECTED]) writes: > Since XML is a way to exchange data...and it is protocol/platform indepdnent > there is a very good reason to have XML docuemts going in and out the No, it's not. You store *data* in a database, *not* metadata. Do you understand the difference?

Re: Auto-Inc question

2001-02-22 Thread Ed Carp
[EMAIL PROTECTED] ([EMAIL PROTECTED]) writes: > Hi, > > I have a table which contains a row called ListID which is set to auto > increment, I added a load of test data into the table while I built my > website so I could test various things out, anyway that is all finished now > and I am read

Re: nesting tables

2001-02-22 Thread Ed Carp
revathi venkatraman ([EMAIL PROTECTED]) writes: > Sir, > Is there this concept of nesting tables and > varrays in mysql?. Iam creating a chemical compounds > database. > there are 20 field in this . Amongst them, I have a > author field where there are multiple authors, amongst > which one i

Myisamchk unable to repair index problem

2001-02-22 Thread filip . sergeys
running myisamchk against basic table gives this error : stopword doesn't have a correct index definition. you need to recreate it before you can do a repair. table details: create table stopword(word char(32) DEFAULT '' NOT NULL, lang char(2) DEFAULT '' NOT NULL, PRIMARY KEY (word, lang)); Th

Re: Exporting data from a MySQL database to an oracle database

2001-02-22 Thread Ed Carp
Joe.O'[EMAIL PROTECTED] (Joe.O'[EMAIL PROTECTED]) writes: > I have a MySql database with customer information which is to be exported > to an oracle database. I was wondering if someone could tell me the easiest > way of doing this. Is there any such applications which look after the > exporting

Oddity with date subtraction - bug?

2001-02-22 Thread Basil Hussain
Hi all, I recently did a query to subtract one DATETIME column from another, but I got odd results for one row and correct results for others. These queries expand upon what I was doing: mysql> SELECT impression, click, click - impression AS diff, DATE_SUB(click, INTERVAL click - impression SECO

Re: mysqldump output file not valid as input file for mysql client

2001-02-22 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: > >Description: > > As of mysql 3.23.33, a dumpfile generated with mysqldump (using the flags: > --opt --all-databases) creates a file which will not be uploaded correctly > using the mysql client (as in: 'mysql -u root -pXX -q -s < >dumpf

Re: Specification of the MySQL Server/Client protocol

2001-02-22 Thread Sinisa Milivojevic
Wittens writes: > Hello, > > Perhaps you can call me stupid or just blind, but I can't find a > specification of the MySQL Server/Client protocol anywhere... > I need it to implement a simple, lightweight MySQL client for mIRC (so using > MySQL++/libmysql is out of the question). > > Is

Re: lower_case_table_names=1 does not work with Solaris

2001-02-22 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: > lrwxrwxrwx 1 root root 11 Jan 19 13:28 /usr/lib/libc.so -> ./libc > .so.1 > -rwxr-xr-x 1 root bin 1135056 Jul 20 2000 /usr/lib/libc.so.1 > Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Offici > al MySQL binary'

Re: Compile Problem

2001-02-22 Thread Sinisa Milivojevic
Alec Solway writes: > Hi, > > I am getting the following errore when trying to link the MySQL client > library with a C++ program I have written. > > /usr/local/mysql/lib/libmysqlclient.a(my_open.o): In function `my_open': > my_open.o(.text+0x14): undefined reference to `open64' > /usr/

Re: Mysql++ problems

2001-02-22 Thread Sinisa Milivojevic
sas writes: > HI. When I was trying to include the "custon.hh" header file, I got some > error messages > like this. > > gcc -lsqlplus -I/usr/include -I/usr/include/mysql -L/usr/lib -o test3 > test3.cc > In file included from /usr/include/custom.hh:71, > from test3.cc:5: > /

Re: Problems on creating table

2001-02-22 Thread Sinisa Milivojevic
Pui Yin LEE [AP] writes: > Dear Sir/ Madam, > > I'm using mySQL GUI Win32 to create a database. I managed to create a database but >not a new table. > > What I did was that I created a database by using function >Commands:Administration:Database:Create, and then I selected the databa

RE: XML support under mySQL

2001-02-22 Thread Mehalick, Richard RE SSI-GRAX
Yes, Ed is correct. You store data, but it is the trasport of that data that makes XML look good. To me, using XML to transport the data is like using recordsets in Microsoft/ADO. - / Rick Mehalick Senior Consultant / Shell Services Interna

RE: RE: XML support under mySQL

2001-02-22 Thread Aaron Weiker
For some reason I don't think this was understood of what I said earlier. THE "DATABASE" ISN'T RESPONSIBLE FOR XML But, just because the database isn't responsible doesn't mean that the application is responsible for generating XML. Due to the fact I don't have my computer science degree like E

Re: HELP!!

2001-02-22 Thread Jack Rhinesmith
elaine; Put the escape character in front of it (/') jack :-)= - Original Message - From: "Elaine Silva" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, February 21, 2001 6:17 PM Subject: HELP!! > Please, > > How can i insert the "'" character (like

Re: Linuux with mysql and c++ API

2001-02-22 Thread Jarle Rudihagen
Thank you for the quick answer, Sinisa Milivojevic. I had som trouble getting the mysql++ API working. I tried both binary and source distribution and finally today: It works I got another source distibution and after a clean compilation it worked. Thanks! Hilsen Jarle - Original Messa

Re: mysqldump output file not valid as input file for mysql client

2001-02-22 Thread Matt Loschert
On Thu, 22 Feb 2001, Sinisa Milivojevic wrote: > [EMAIL PROTECTED] writes: > > >Description: > > > >As of mysql 3.23.33, a dumpfile generated with mysqldump (using the flags: > > --opt --all-databases) creates a file which will not be uploaded correctly > > using the mysq

RE: RE: XML support under mySQL

2001-02-22 Thread Cal Evans
Top of the morning to ya Aaron, 1: Ed did not suggest that everyone has to have a CS degree. Not defending Ed because based on his posts this morning, someone pissed in his Cheerios but he simply stated that people should be a little more educated about the subject before posting. 2: The discus

Re: mysqldump output file not valid as input file for mysql client

2001-02-22 Thread Sinisa Milivojevic
Matt Loschert writes: > On Thu, 22 Feb 2001, Sinisa Milivojevic wrote: > > > [EMAIL PROTECTED] writes: > > > >Description: > > > > > > As of mysql 3.23.33, a dumpfile generated with mysqldump (using the >flags: > > > --opt --all-databases) creates a file which will no

Suport of cirilic-???

2001-02-22 Thread Anatolii_s
Dear support group of MySQL, I want thank you for this good (best) SQL server. But when I use MySQL for Windows with languages like Ukrainian, Rassian I can't use case insensitive select, or operator like Upper. Can you help me? Sincerely, Anatolii.

Re: mysqldump output file not valid as input file for mysql client

2001-02-22 Thread Matt Loschert
On Thu, 22 Feb 2001, Sinisa Milivojevic wrote: > Matt Loschert writes: > > On Thu, 22 Feb 2001, Sinisa Milivojevic wrote: > > > > > [EMAIL PROTECTED] writes: > > > > >Description: > > > > > > > > As of mysql 3.23.33, a dumpfile generated with mysqldump (using the >flags: > > > >

RE: Quoting numbers? (was Re:MySQL Tables)

2001-02-22 Thread Julian Strickland
It's all to do with data types, traditionally and across most languages quotes are used to delimit STRINGS and a string is NOT a number although may represent one when displayed. > -Original Message- > From: Pete Harlan [SMTP:[EMAIL PROTECTED]] > Sent: 21 February 2001 20:51 > To: [EMAI

RE: Printed MySQL manual

2001-02-22 Thread Julian Strickland
The distributions come with a text version of the manual so you can download one and print it yourself but beware it is rather large. > -Original Message- > From: Thalis A. Kalfigopoulos [SMTP:[EMAIL PROTECTED]] > Sent: 21 February 2001 21:05 > To: [EMAIL PROTECTED] > Subject: Re:

Re: Cannot connect to local mySQL server through socket error (111)

2001-02-22 Thread Gerald L. Clark
Chuang Keng Chee wrote: > > Hi! > > Socket file specified is : /var/lib/mysql/mysql.sock > which on my system has a filesize of zero. I'm running a Red Hat > 7.0, Kernel 2.2.16-22smp > which I installed with MySQL (ie, MySQL wasn't installed separately from > source files.) > > I've got th

double InnerJoin -how?

2001-02-22 Thread Henrik Lebtien Mohr
I have three tables: one with contacts, one with members, and one that links the members to a group. How do I make a SQL-string, that gets the members from a specifik group, AND the contacts that belongs to this group as well? Won't I have to make a double InnerJoin? Kind regards, /Henrik Mohr

Re: Oddity with date subtraction - bug?

2001-02-22 Thread Gerald L. Clark
Basil Hussain wrote: > > Hi all, > > I recently did a query to subtract one DATETIME column from another, but I > got odd results for one row and correct results for others. These queries > expand upon what I was doing: > > mysql> SELECT impression, click, click - impression AS diff, DATE_SUB(c

mysql@lists.mysql.com

2001-02-22 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release:

Sorry, delay in MySQL/Innobase distribution

2001-02-22 Thread Heikki Tuuri
Hi, readers of the mailing list! Sorry, we were not yet able to roll a distribution of MySQL-3.23.3x/Innobase yesterday. Monty is now traveling in South America for a week, and the distribution will take still some time. Currently, MySQL/Innobase runs on Win NT, Linux Intel, Linux Compaq Alpha 6

ReisserFS

2001-02-22 Thread Simon Windsor
Hi Has anyone user MySql on a ReisserFS file system ? Where any problems encountered ? and do you have any pearls of wisdom that you are willing to share ? Thanks Simon -- Simon Windsor CricInfo http://www.cricinfo.com/ Tel: +44 (0) 1249 700720 Fax: +44 (0) 1249 700725 Email: mailto:[EMAIL

Re: Oddity with date subtraction - bug?

2001-02-22 Thread Basil Hussain
Hi, >> mysql> SELECT impression, click, click - impression AS diff, DATE_SUB(click, >> INTERVAL click - impression SECOND) AS calc FROM eventlog; >> +-+-+--+-+ >> | impression | click | diff | calc

Re: XML support under mySQL

2001-02-22 Thread Jason Hall
Aaron Weiker wrote: > For some reason I don't think this was understood of what I said earlier. > > THE "DATABASE" ISN'T RESPONSIBLE FOR XML > > But, just because the database isn't responsible doesn't mean that the > application is responsible for generating XML. > > > to put this wrapper o

OLE DB Provider?

2001-02-22 Thread Lee Jenkins
Hello everyone, I was wondering if the folks at MySQL were considering developing an OLE DB provider. I ask because, including myself, there seems to be quite a large number of developers who traditionally used MS DB products, moving over MySQL for many applications. Don't get me wrong, using

Re: BDB Problem with MAX() and multipart primary keys

2001-02-22 Thread Guenther Pewny
It's a miracle. Which version of the BDB patch do you use? I'm using 3.2.9a. (Previously, there has been a version 3.2.3g...) Thanks... Günther Pewny Sinisa Milivojevic wrote: > Guenther Pewny writes: > > Hi folks, > > > > I have a problem with BDB tables. Please look at this short mysql s

INSERT DELAYED crashes Mysql 3.23.33

2001-02-22 Thread Artem Koutchine
Hi! I am trying to insert 1 000 000 records into a very simple table: create table test ( a1 tinyint unsigned not null, a2 tinyint unsigned not null, a3 tinyint unsigned not null, a4 tinyint unsigned not null, primary key (a1,a2,a3,a4) ); So, to make it faste

Re: ReisserFS

2001-02-22 Thread Jan-Aage Bruvoll
On Thu, 22 Feb 2001, Simon Windsor wrote: > Has anyone user MySql on a ReisserFS file system ? > > Where any problems encountered ? and do you have any pearls of wisdom > that you are willing to share ? No problems at all. Even power outages and severe crashes did not touch the MySQL stuff on th

Re: Auto-Inc question

2001-02-22 Thread Website4S
In a message dated 22/02/2001 12:22:26 GMT Standard Time, [EMAIL PROTECTED] writes: << 30 seconds work(less time than it took you to type your email) would've revealed the answer: 1. Click on "the manual" link at the bottom of this message. 2. See the search box? Type in "auto increment"

Re: Oddity with date subtraction - bug?

2001-02-22 Thread Gerald L. Clark
Basil Hussain wrote: > > Hi, > > >> mysql> SELECT impression, click, click - impression AS diff, DATE_SUB(click, > >> INTERVAL click - impression SECOND) AS calc FROM eventlog; > >> +-+-+--+-+ > >> | impression | click

Suggestion For List Management

2001-02-22 Thread Jeff Gannaway
Here's an idea for the list memebers and list master Since a lot messages have undescriptive subjects ("Help", "Check This", "What's This?", etc...) I think it would be a good idea to set up the majordomo to add a tag to each subject line like the PHP list does. For instance Subj: Help b

Re: ReisserFS

2001-02-22 Thread Jeremy D. Zawodny
On Thu, Feb 22, 2001 at 03:22:13PM +, Simon Windsor wrote: > Hi > > Has anyone user MySql on a ReisserFS file system ? Yes. > Where any problems encountered ? and do you have any pearls of > wisdom that you are willing to share ? It "just works". :-) -- Jeremy D. Zawodny, <[EMAIL PROTECTE

Re: Transactions in 3.23.33 ?

2001-02-22 Thread Guenther Pewny
AFAIK, the 3.23.33 binaries don't include the BDB table handler - you have to build mysql from source after unpacking the BDB module into your mysql source tree. On the other hand, I've read that the 3.23.34 version (it should be online these days) has BDB _and_ INNOBASE integrated. As posted so

MySQL

2001-02-22 Thread Gupta, Sanjeev
Hi Is there any way when i just copy the service file and other related file to run mysql instead of installing fully on my system. Thanks sanjeev -Original Message- From: Simon Windsor [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 10:22 AM To: [EMAIL PROTECTED] Subject: R

Re: BDB Problem with MAX() and multipart primary keys

2001-02-22 Thread Sinisa Milivojevic
Guenther Pewny writes: > It's a miracle. > > Which version of the BDB patch do you use? > I'm using 3.2.9a. > (Previously, there has been a version 3.2.3g...) > > Thanks... > > Günther Pewny > Hi! I used latest source tarball from our 3.23 page. Regards, Sinisa __

RE: ReisserFS

2001-02-22 Thread Sander Pilon
> -Original Message- > From: Simon Windsor [mailto:[EMAIL PROTECTED]] > Sent: 22 February 2001 16:22 > To: [EMAIL PROTECTED] > Subject: ReisserFS > > > Hi > > Has anyone user MySql on a ReisserFS file system ? > > Where any problems encountered ? and do you have any pearls of > wisdom th

RE: ReisserFS

2001-02-22 Thread Gupta, Sanjeev
Hi, Is any body knows that is there nay way to use mySQL with out installing it fully. I mean to say just install service manager and other required drivers. Or can somebody let me know that what are the minium service require from mysql setup to run the mySQL server to win NT. Sanjeev -Origi

Re: ReisserFS

2001-02-22 Thread Sinisa Milivojevic
Jan-Aage Bruvoll writes: > On Thu, 22 Feb 2001, Simon Windsor wrote: > > No problems at all. Even power outages and severe crashes did not touch > the MySQL stuff on the ReiserFS file system, but that's probably all luck. > > :-) > > Regards, Jan > > No, that is not just luck. Rei

Re: ReisserFS

2001-02-22 Thread Jan-Aage Bruvoll
On Thu, 22 Feb 2001, Sinisa Milivojevic wrote: > No, that is not just luck. > > ReiserFS is a journalling file system. Sure thing. The luck part was referring to the fact that even the consistency in the tables was ok, which is more on the luck side, since all buffers were flushed at the time of

Re: ReisserFS

2001-02-22 Thread Sinisa Milivojevic
Jan-Aage Bruvoll writes: > On Thu, 22 Feb 2001, Sinisa Milivojevic wrote: > > No, that is not just luck. > > > > ReiserFS is a journalling file system. > > Sure thing. The luck part was referring to the fact that even the > consistency in the tables was ok, which is more on the luck side,

Re: Suggestion For List Management

2001-02-22 Thread horape
¡Hola! [That's a recurrent theme in all mailing lists. Look in the archives the long answers] Yet again, no. Just learn to configure your MUA. HoraPe On Thu, Feb 22, 2001 at 11:08:06AM +, Jeff Gannaway wrote: > Here's an idea for the list memebers an

RE: Suggestion For List Management

2001-02-22 Thread Jon Haworth
Well, you could filter anything sent or cc'ed to [EMAIL PROTECTED] into a separate folder -Original Message- From: Jeff Gannaway [mailto:[EMAIL PROTECTED]] Sent: 22 February 2001 11:08 To: [EMAIL PROTECTED] Subject: Suggestion For List Management Here's an idea for the list memebers

Re: Suggestion For List Management

2001-02-22 Thread John Cichy
Jeff, This has been discussed before and I find it easier to just sort by the 'from' header in the message. Check the archives for more disscussion. Have a great day... John On Thursday 22 February 2001 06:08, Jeff Gannaway wrote: > Here's an idea for the list memebers and list master > >

Re: Suggestion For List Management

2001-02-22 Thread Quickling
Hey - >Since a lot messages have undescriptive subjects ("Help", "Check This", >"What's This?", etc...) I think it would be a good idea to set up the >majordomo to add a tag to each subject line like the PHP list does. "[MYSQL] Help" is hardly more descriptive than "Help". My solution is to fi

Re: ReisserFS

2001-02-22 Thread William R. Mussatto
RE ReiserFS What is the hardware (32 bit or 64) and what is the maximum files size MySql will support on it? Thanks. Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Befor

Turn off MySql Warning Messages

2001-02-22 Thread samsom, debra
I would Like to Turn Off the following MySQL Connect Warning message. Any Suggestions??? Warning: MySQL Connection Failed: Can't connect to MySQL server on 'localhost' (10061) in e:\program files\apache group\apache\htdocs\dwg\dwg.php on line 22 Server Currently Unavailable This is the code t

Fields

2001-02-22 Thread Chris
Hi, Are there certain chacters that a VARCHAR field can't store? If I xor encrypt a #, I get non-alphanumeric characters: Ex: 123456789123 may end up 1 YdR Is this a problem to store properly, should I use a different field type other than varchar? Thanks, Chris

  1   2   >