Re: install problems AGAIN

2001-08-27 Thread George Pitcher
- Original Message - From: [EMAIL PROTECTED] To: George Pitcher [EMAIL PROTECTED] Sent: Saturday, August 25, 2001 1:41 PM Subject: Re: install problems AGAIN Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you

Help about joins

2001-08-27 Thread Jarkeborn Joacim
Hi, I have a Oracle SQL string that contains '(+)' but when running it in mySQL I get an error message saying that it's a syntax error. The definition in a Oracle helpfile is: (+),Indicates that the preceding column SELECT ename, dname is the outer join column FROM

Binlogs numbers

2001-08-27 Thread Rafal Jank
Hi, I've noticed, that bin logs names are followed by three digits: 001,002 and so on. What will happen when I reach 999? Will it start to overwrite my first logs? magic words: MySQL, table, sql -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/

Search and compare

2001-08-27 Thread Jarkeborn Joacim
Hi, Oracle has a fuction that compares value and then returns another value. DECODE( expr, search, result [, search, result] ... [, default] ) E.g. DECODE (deptno, 10, 'ACCOUNTING', 20, 'RESEARCH', 30, 'SALES', 40, 'OPERATION',

Re: Help about joins

2001-08-27 Thread Van
Jarkeborn Joacim wrote: Hi, I have a Oracle SQL string that contains '(+)' but when running it in mySQL I get an error message saying that it's a syntax error. The definition in a Oracle helpfile is: (+),Indicates that the preceding column SELECT ename, dname is the outer

Re: MySQL datetime and microseconds

2001-08-27 Thread Michael Widenius
Hi! Sasha == Sasha Pachev [EMAIL PROTECTED] writes: Sasha On Wednesday 22 August 2001 15:37, you wrote: Can mysql support mucroseconds in the datetime field? mydate datetime(14,4) for instance? I havn't had success so far ;-) Sasha No, it cannot, at this time. We might consider adding

Re: shadow tables?

2001-08-27 Thread Michael Widenius
Hi! werner == werner ISO-8859-1 writes: werner Is it an option to drop the table and recreate and repopulate it? werner I would give it a try and think that your problem will be gone. werner You can easily do that with mysqldump. Ask again if you need more werner help. werner Alex

RE: Help about joins

2001-08-27 Thread Järkeborn Joacim
-Original Message- From: Van [mailto:[EMAIL PROTECTED]] Sent: den 27 augusti 2001 11:01 To: Jarkeborn Joacim Cc: [EMAIL PROTECTED] Subject: Re: Help about joins Jarkeborn Joacim wrote: Hi, I have a Oracle SQL string that contains '(+)' but when running it in mySQL I

Re: No Lock

2001-08-27 Thread Tonu Samuel
On 26 Aug 2001 13:55:40 -0700, Jeremy Zawodny wrote: On Sun, Aug 26, 2001 at 11:52:15PM +0200, Boaz Yahav wrote: Does mysql have something like NO LOCK? SELECT * FROM mytable WHERE myfield='xyz' NO LOCK By default, no. But if you use InnoDB tables in MySQL, you'll get non-locking

[Solved] RE: Search and compare

2001-08-27 Thread Järkeborn Joacim
Yes, I have got the tip from 'Carl Troein', thanks anyway CASE value WHEN [compare-value] THEN result [WHEN [compare-value] THEN result ...] [ELSE result] END Best regards Joacim -Original Message- From: Harald Fuchs [mailto:[EMAIL PROTECTED]] Sent: den 27 augusti 2001 11:43 To:

carrying database

2001-08-27 Thread noe
Hi my name is Nejat from Turkey and i am very new in databases .I have got a database in linux which is mysql and i want to carry this database to a windows system how can this be done.Any help needed.Thankyou! _ Do You Yahoo!? Get your

Re: carrying database

2001-08-27 Thread Gerald R. Jensen
This is all nicely detailed in the MySQL Manual. Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) Suggest you use mysqldump, including the option to create the database and table schema. On the Linux machine:

Re: Setting user passwords per database

2001-08-27 Thread Gerald R. Jensen
It would see you could us ethe GRANT command: GRANT ALL PRIVILEGES ON database1.* TO user@% IDENTIFIED BY 'password1'; GRANT ALL PRIVILEGES ON database2.* TO user@% IDENTIFIED BY 'password2'; GRANT ALL PRIVILEGES ON database3.* TO user@% IDENTIFIED BY 'password3'; - Original Message -

Compiling MySQL Database on LinuxPPC

2001-08-27 Thread George Pitcher
Hi all, Frustrated by failing compile: This is the message I get: c++: Internal compiler eror: program cc1plus got fatal signal 15 make[3]: ***[field.o] Error 1 make[3]: Leaving directory '/usr/src/mysql-3.23.37/sql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory

TEXT field and AppendChunk

2001-08-27 Thread Zhenjiang Guo
hello all, I'm now developing with MySQL and VC. And I have a question with the field which type is TEXT. I cann't insert the value with AppendChunk. Here is part of my code. HRESULT hr; _RecordsetPtr pRS; _bstr_t G_CONNECTSTRING = LPersist

the most used DB in Webhosting

2001-08-27 Thread jhsena
Dear members, I know you are MySQLer but be honest, what is the the most used Database in ISP of webhosting, and the reasons. And fornyou, after MySQL what is the DB the you prefer in webhosting. thanks to all - Before

Re: the most used DB in Webhosting

2001-08-27 Thread George Pitcher
This is probably heresy here, but we use Filemaker for our web-database solution. The main reason why we use that in preference to more 'robust' SQL-based DBs is that we have a team using Filemaker clients updating information constantly and Filemaker is the most efficient db we have found to do

carrying database

2001-08-27 Thread noe
Hi my name is Nejat from Turkey and i am very new in databases .I have got a database in linux which is mysql and i want to carry this database to a windows system how can this be done.Any help needed.Thankyou! _ Do You Yahoo!? Get

Re: carrying database

2001-08-27 Thread Tonu Samuel
On 27 Aug 2001 13:27:17 +0300, noe wrote: Hi my name is Nejat from Turkey and i am very new in databases .I have got a database in linux which is mysql and i want to carry this database to a windows system how can this be done.Any help needed.Thankyou! Search in manual for mysqldump -- For

Re: Setting user passwords per database

2001-08-27 Thread Mark Johnson
I tried that, all it did was change my password for mysql completelyhowever, i could have done something wrong... - Original Message - From: Gerald R. Jensen [EMAIL PROTECTED] To: Mark Johnson [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, August 27, 2001 5:35 AM Subject: Re:

Date Formats into the DB

2001-08-27 Thread Betto McRose G,
Hi I want to know if it's possible to put a format to a Date Field into the DB. For example: I have a data only JUN/2001 for a table, but the field FechaINI format is -00-00, so I want to put just -00 but I cannot. thanks Betto McRose G,

Is MySQL network dependent?

2001-08-27 Thread Arvid . Claassen
I've installed MySQL on a Sun Ultra1 with Solaris 8 and it works fine. But as soon as I unplug the network cable none of the MySQL binaries seem to work any more. If I start MySQL is prints nothing and the process seems to hang. If I reconnect the cable and try starting MySQL again,

Re: Binlogs numbers

2001-08-27 Thread Sinisa Milivojevic
Rafal Jank writes: Hi, I've noticed, that bin logs names are followed by three digits: 001,002 and so on. What will happen when I reach 999? Will it start to overwrite my first logs? magic words: MySQL, table, sql -- _/_/ _/_/_/ - Rafa³ Jank [EMAIL PROTECTED] -

repairing MyISAM table kills mysqld with SIG11

2001-08-27 Thread mmokrejs
Description: 010827 16:24:44 Warning: Retrying repair of: './Mloti/blast_data' with keycache mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can

Slow AND query

2001-08-27 Thread Adriano Manocchia
I've got a large table with, amongst other things, two indexed varchar fields. Individual queries, SELECT count(*) FROM orders WHERE email != 'control'; is fast (0.01 sec), and SELECT count(*) FROM orders WHERE distdate LIKE '07/%/2001'; is fast (0.02 sec). But, SELECT count(*) FROM

Re: repairing MyISAM table kills mysqld with SIG11

2001-08-27 Thread Sinisa Milivojevic
Hi! Try to repair the same table with 3.23.41. If it fails, please let us know, so that we can give you upload instructions. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime

Re: Date Formats into the DB

2001-08-27 Thread Thomas Spahni
On Mon, 27 Aug 2001, Betto McRose G, wrote: I want to know if it's possible to put a format to a Date Field into the DB. For example: I have a data only JUN/2001 for a table, but the field FechaINI format is -00-00, so I want to put just -00 but I cannot. Let MySQL store its format.

MySQL on Tru64 UNIX/OSF1

2001-08-27 Thread Corelli, Wayne
All, Has anyone installed / used MySQL on TRU64 UNIX? I just had to hack up the code to install it and I was curious if anyone else had this problem Or perhaps I am missing a switch on the configure line. In particular the choice of gethostbyname function does not seem to have the proper

Re: MySQL on Tru64 UNIX/OSF1

2001-08-27 Thread Sinisa Milivojevic
Corelli, Wayne writes: All, Has anyone installed / used MySQL on TRU64 UNIX? I just had to hack up the code to install it and I was curious if anyone else had this problem Or perhaps I am missing a switch on the configure line. In particular the choice of gethostbyname function does

MySQL error 145

2001-08-27 Thread Chris M
Does anyone know how I can go about troubleshooting what is wrong here? This is mysql on a Linux system I have no idea how to begin troubleshooting why the ACCOUNTING.MYD file can't be opened, I need some hints. Thanks, Chris Fatal Error A serious problem was encountered: Execute failed

Re: repairing MyISAM table kills mysqld with SIG11

2001-08-27 Thread Martin MOKREJ
On Mon, 27 Aug 2001, Sinisa Milivojevic wrote: Hi! Try to repair the same table with 3.23.41. If it fails, please let us know, so that we can give you upload instructions. kulan$ ls -la /home/mysql/Mbovis/cogs_data* -rw-rw1 pedant users54195408 Jul 4 03:52

Why DATE functions return a String in SELECT

2001-08-27 Thread Ghislain . Gadbois
Description: I use the MM JDBC driver version 2.0.4 to access my MySQL database from my Java app. If I do SELECT NOW(), it returns a String object and not a Date object. I tried to call different functions (e.g. SELECT DATE_ADD(NOW(), INTERVAL 0 SECOND)) in order to have a Date in my

Re: Help Needed Please

2001-08-27 Thread Martin Mokrejs
Hi, use "mysqladmin variables" command to see current settings. I guess your mysqld does not read the config file you have edited. ;-) It happened to me me also few days ago. Remember mysqld looks for /etc/my.cnf and $DATADIR/var/my.cnf if I remember well. Maybe put the path to config file just

Re: repairing MyISAM table kills mysqld with SIG11

2001-08-27 Thread Sinisa Milivojevic
=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes: On Mon, 27 Aug 2001, Sinisa Milivojevic wrote: If I should try also your binary distribution, please let me know. -- Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs [EMAIL PROTECTED] Faculty of Science, The Charles

Re: MySQL error 145

2001-08-27 Thread mickalo
Error: 45 145 = Table was marked as crashed and should be repaired On Mon, 27 Aug 2001 08:50:45 -0600, Chris M [EMAIL PROTECTED] wrote: Does anyone know how I can go about troubleshooting what is wrong here? This is mysql on a Linux system I have no idea how to begin troubleshooting why

Error 1045

2001-08-27 Thread Alex Sofronie
Hi all. I am relatively new to mysql and brand new on this list :) Please help me with this: I have to backup a database and the simplest way to accomplish this is SELECT * FROM mytable INTO OUTFILE '/nobody_directory/mytabledump.txt'; The problem is that when I do this, the server response is:

Re: MySQL error 145

2001-08-27 Thread Rafal Jank
Chris M wrote: Does anyone know how I can go about troubleshooting what is wrong here? This is mysql on a Linux system I have no idea how to begin troubleshooting why the ACCOUNTING.MYD file can't be opened, I need some hints. That means that the table has crashed. Repair it with

Inner selects

2001-08-27 Thread Michael Beaucourt
Hi all, I was wondering if it is possible to perform an inner select in MySQL. I have a database called EMP and when i enter the following query, I keep getting error 1064: select ename,deptno from emp where deptno in (select deptno from emp where ename = 'SCOTT') The error message reads as

THANKS for having fixed DISTINCT ... HAVING bug...

2001-08-27 Thread nsabbi
... you are really very kind and helpful! Now I can avoid managing temp tables. Thanks very much, Nico Sabbi - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Inner selects

2001-08-27 Thread Rafal Jank
Michael Beaucourt wrote: Hi all, I was wondering if it is possible to perform an inner select in MySQL. I have a database called EMP and when i enter the following query, I keep getting error 1064: select ename,deptno from emp where deptno in (select deptno from emp where ename =

Re: Inner selects

2001-08-27 Thread Andrew Schmidt
no mysql right now (3.23) does not support inner selects. however, it looks like you could join the 2 tables to get the result you want I'm assuming there are 2 tables inside the emp database ? or is emp the table ? anyway here is an idea: select d1.ename, d1.deptno FROM emp.table1 d1,

selecting what is not in something

2001-08-27 Thread Jeff Shipman - SysProg
I have two tables and that have a couple of identical columns. I would like to find out what of a certain column is in one table and not in another. I've tried the following, but I get errors: select col1 from tab1 where col1 not in (select col1 from tab2); select tab1.col1 from tab1,tab2 where

Re: repairing MyISAM table kills mysqld with SIG11

2001-08-27 Thread Sasha Pachev
cut Can you upload a copy of blast_data to ftp://support.mysql.com/pub/mysql/secret after verify first that what you plan to upload will crash a separate MySQL server on REPAIR? -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___

Re: repairing MyISAM table kills mysqld with SIG11 (fwd)

2001-08-27 Thread Martin MOKREJ
Hi, sorry I did not send the last e-mail to the whole list, so here it is. -- Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs [EMAIL PROTECTED] Faculty of Science, The Charles University -- Forwarded message -- Date: Mon, 27 Aug 2001 17:39:07 +0200 (MET

Re: Compiling MySQL Database on LinuxPPC

2001-08-27 Thread David Dahl
Is there any specific reason you are compiling MySQL? I use MySQL on LinuxPPC, and never have compiled it due to the great rpm's available here: http://www.linuxppc.org/ (right side of the page) Hi all, Frustrated by failing compile: This is the message I get: c++: Internal compiler eror:

RE: selecting what is not in something

2001-08-27 Thread Jay Fesco
Jeff, If the result table from the inner select is not huge, I usually issue the inner query by itself first, then build (in my scripting language of choice) a comma-delimited text field containing the results that I don't want in my final table. I then expand that text field into the 'NOT IN'

Re: Inner selects

2001-08-27 Thread Michael Beaucourt
Michael Beaucourt wrote: Hi all, I was wondering if it is possible to perform an inner select in MySQL. I have a database called EMP and when i enter the following query, I keep getting error 1064: select ename,deptno from emp where deptno in (select deptno from emp where ename =

Re: the most used DB in Webhosting

2001-08-27 Thread David Dahl
I used to be a Lasso/FileMaker programmer. The day I decided to switch to the all-unix MySQL/PHP/Perl platform was very telling. I was attempting to parse log files with Lasso's file tags. Everything was working quite well, but once the log file was bigger than about 500k, it would hang

Re: selecting what is not in something

2001-08-27 Thread Paul DuBois
At 9:38 AM -0600 8/27/01, Jeff Shipman - SysProg wrote: I have two tables and that have a couple of identical columns. I would like to find out what of a certain column is in one table and not in another. I've tried the following, but I get errors: select col1 from tab1 where col1 not in (select

Overwriting records with matching fields with dbf2mysql

2001-08-27 Thread Armando Cerna
What would be the best way to do this because I am working on a mysql replacement to an old foxpro database and I can import the table once but I am worried that if I try to import it again it will make duplicate records. Another issue is that I have added an extra field to the table which is

GUI Error

2001-08-27 Thread Jason A. Vest
Dear Sir, Ihave encountered an error with the windows version of the MySQL GUI. This error happens only when I try to pull data from the this table in the GUI. I can pull information from other sources. The GUI program will initiate a memory error message and quit. Is this a bug? This is

iASP Engine...

2001-08-27 Thread Neil Tompkins
Hello, My ISP suppports iASP. I've moved my site from running on Windows 2000 Server to a linux zeus web server. Everything runs fine from querying the mySQL database and returning records. But after about 5-10 queries of the database returning 20 records at a time the iASP engine slow right

Choosing between databases.

2001-08-27 Thread Sheena Sidhu
Hello, I am very new to mySQL and researching on the various databases options. Since I needed transactions enabled, so after a lot of research, I narrowed down to innodb and Bdb. But realized that Innodb is in alpha but BDB is very stable. Although I like the features that innodb has

RE: Inner selects

2001-08-27 Thread Bruce Stewart
Hi, - In oracle you have outer joins, where you have to use a (+) to find rows with null values and stuff like that. Any suggestions on how to do this in MySQL? You must use the Left Join type syntax in the FROM clause of your query. - The function UNION to connect 2 select queries

Re: Choosing between databases.

2001-08-27 Thread Cal Evans
FWIW, I am using INNODB tables in production without a problem. Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: Sheena Sidhu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 27, 2001 12:24 Subject: Choosing between

Re: Inner selects

2001-08-27 Thread Jeremy Zawodny
On Mon, Aug 27, 2001 at 07:28:24PM +0200, Bruce Stewart wrote: - The function UNION to connect 2 select queries also doesn't seem to work in MySQL. Any workarounds? I believe, not yet supported in MySQL. It's was in the 4.0 tree last I looked, so it won't be long. :-) Jeremy --

Poblem with ODBC / W98 / ADO

2001-08-27 Thread Alain Bebie
Hi, 1. Please excuse my English mistakes – I am a Swiss with Swiss German as mother language. My problem is related to using MySQL under Windows98 – I have installed MySQL 3.23.41 MyODBC 2.50.38-win95 and Microsoft ADO 2.0 is used. I often get an error “-2147217887” when

Selecting * from multiple tables

2001-08-27 Thread Dave Mittner
I'm running into a snag... here's an example of the query I'm making from within Perl: SELECT * FROM table1,table2 I know it's not a nice way to do it, but I'm making an SQL webpage frontend which I'd like to support it just in case. I'm using fetchrow-hashref to pull it out and display it.

Re: repairing MyISAM table kills mysqld with SIG11 (fwd)

2001-08-27 Thread Martin MOKREJ
On Mon, 27 Aug 2001, Martin MOKREJ wrote: ftp://support.mysql.com/pub/mysql/secret Hmm, I can already login as ftp, but can only chdir to /pub/mysql, there's no secret directory. ;( http://pednew.gsf.de/cogs_data.tgz Hmm, try out http://kulan.gsf.de/cogs_data.tgz , but I'm sure the

Re: THANKS for having fixed DISTINCT ... HAVING bug...

2001-08-27 Thread Sinisa Milivojevic
nsabbi writes: ... you are really very kind and helpful! Now I can avoid managing temp tables. Thanks very much, Nico Sabbi You are welcome. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL

Re: Selecting * from multiple tables

2001-08-27 Thread Paul DuBois
At 10:43 AM -0700 8/27/01, Dave Mittner wrote: I'm running into a snag... here's an example of the query I'm making from within Perl: SELECT * FROM table1,table2 I know it's not a nice way to do it, but I'm making an SQL webpage frontend which I'd like to support it just in case. I'm using

Re: Selecting * from multiple tables

2001-08-27 Thread Ian Barwick
On Monday 27 August 2001 19:43, Dave Mittner wrote: I'm running into a snag... here's an example of the query I'm making from within Perl: SELECT * FROM table1,table2 I know it's not a nice way to do it, but I'm making an SQL webpage frontend which I'd like to support it just in case. I'm

Re: repairing MyISAM table kills mysqld with SIG11 (fwd)

2001-08-27 Thread Sasha Pachev
mysql repair table cogs_data; ERROR 2013: Lost connection to MySQL server during query mysql quit 0x807b1b8 handle_segfault__Fi + 380 0x812af8a pthread_sighandler + 154 0x81517df free + 39 0x8114a6c my_no_flags_free + 16 0x8109304 mi_repair + 2236 0x80c4768

Choosing between Databases.

2001-08-27 Thread Sheena Sidhu
Hello, I am looking into choosing between Innodb and BDB. One thing about BDB which I am quoting from the official site : Berkeley DB does not support SQL queries. All access to data is through the Berkeley DB API. Developers must learn a new set of interfaces in order to work with Berkeley DB.

Re: GUI Error

2001-08-27 Thread Sinisa Milivojevic
Jason A. Vest writes: Dear Sir, Ihave encountered an error with the windows version of the MySQL GUI. This error happens only when I try to pull data from the this table in the GUI. I can pull information from other sources. The GUI program will initiate a memory error message and quit.

Error Install MySQL Binary on AIX

2001-08-27 Thread ajgrif
Description: I downloaded the lated AIX binary from mysql.com, and unpacked it to /usr/local/mysql. I then cd'd to /usr/local/mysql and ran scripts/mysql_install_db per the INSTALL-BINARY file. This is the error I recieve: exec(): 0509-036 Cannot load program ./bin/my_print_defaults

Re: repairing MyISAM table kills mysqld with SIG11 (fwd)

2001-08-27 Thread Martin MOKREJ
Sorry about that - we have now fixed the problems with our anonymous FTP upload, and it should be working. lokk in pub/mysql/secret/ for: 15593452(size) cogs_data.tgz But same file should be accessible already via the 2 web links I've sent to you via personal e-mail. Thanks. -- Martin

Solaris 2.8 configure problem...

2001-08-27 Thread Jeremy Zawodny
I have a fairly new Solaris 2.8 (Ultra Sparc) machine on which I'm trying to build the MySQL client libraries. According to the INSTALL-SOURCE file, I need to use a command-line like this: CC=gcc CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti ./configure

Re: Error Install MySQL Binary on AIX

2001-08-27 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: Description: I downloaded the lated AIX binary from mysql.com, and unpacked it to /usr/local/mysql. I then cd'd to /usr/local/mysql and ran scripts/mysql_install_db per the INSTALL-BINARY file. This is the error I recieve: exec(): 0509-036 Cannot load

Re: Solaris 2.8 configure problem...

2001-08-27 Thread Sinisa Milivojevic
Jeremy Zawodny writes: I have a fairly new Solaris 2.8 (Ultra Sparc) machine on which I'm trying to build the MySQL client libraries. According to the INSTALL-SOURCE file, I need to use a command-line like this: CC=gcc CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions

Re: repairing MyISAM table kills mysqld with SIG11 (fwd)

2001-08-27 Thread Sasha Pachev
On Monday 27 August 2001 12:30, Martin MOKREJ? wrote: Sorry about that - we have now fixed the problems with our anonymous FTP upload, and it should be working. lokk in pub/mysql/secret/ for: 15593452(size) cogs_data.tgz But same file should be accessible already via the 2 web

SQLDriverConnect

2001-08-27 Thread Jeff Tanner
If the connection string for SQLDriverConnect is DSN=foo, and DSN foo is defined within the odbc.ini file, then connection succeeds. However, if the connection string for SQLDriverConnect is DRIVER={MySQL};SERVER=foo_host;USER=foo;PWD=bar;DATABASE=foo_db, then error condition is returns with

Urgent

2001-08-27 Thread Sheena Sidhu
Hi, I have mysql version 3.32.40 installed on my system. Please let me know what I need to take care of (besides the db backup) if I need to upgrade to mysql-max? I need this on an urgent basis, so please help! Thanks, Sheena.

MySQL and GPL license: questions and discussion

2001-08-27 Thread Neil Zanella
I would like to discuss the MYSQL licensing policy. Please do not take anything personally. I do think that MySQL is one of best database management systems out there. Pertaining to the FAQ on the mysql.com site: --- begin snip Q:Does MySQL AB

Re: Solaris 2.8 configure problem...

2001-08-27 Thread Jeremy Zawodny
On Mon, Aug 27, 2001 at 09:43:23PM +0300, Sinisa Milivojevic wrote: Jeremy, In our manual, chapter on Solaris, there are instructions on which lines to delete from configure script in the case like above. Right. I've looked at: http://www.mysql.com/doc/S/o/Solaris.html

RE: SQLDriverConnect

2001-08-27 Thread Venu
)-Original Message- )From: Jeff Tanner [mailto:[EMAIL PROTECTED]] )Sent: Monday, August 27, 2001 12:08 PM )To: '[EMAIL PROTECTED]' )Subject: SQLDriverConnect ) ) )If the connection string for SQLDriverConnect is DSN=foo, and DSN foo is )defined within the odbc.ini file, then connection

Re: Solaris 2.8 configure problem...

2001-08-27 Thread Andrew Gideon
In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Sinisa Milivojevic) writes: What can I do to fix/debug this problem? I'd this problem too (and I didn't note lines to be removed in the documentation). It turns out that there is in the configure script an assumption that the inability

Need Help Setting Up MySQL on Win98

2001-08-27 Thread S K Bryan
Hello - I'm very new at this, so please pardon the very beginner questions... I'm attemtping to install MySQL to my local machine running Win98. The install seems to go alright, but when I try mysqld--standalone it gives me an error. Then I tried mysqld -standalone, which seemed to work. Then

Re: Is MySQL network dependent?

2001-08-27 Thread Jeremy Zawodny
On Mon, Aug 27, 2001 at 02:40:51PM +0200, [EMAIL PROTECTED] wrote: I've installed MySQL on a Sun Ultra1 with Solaris 8 and it works fine. But as soon as I unplug the network cable none of the MySQL binaries seem to work any more. If I start MySQL is prints nothing and the process seems to

Re: Need Help Setting Up MySQL on Win98

2001-08-27 Thread John Meyer
At 12:54 PM 8/27/01 -0700, you wrote: Hello - I'm very new at this, so please pardon the very beginner questions... I'm attemtping to install MySQL to my local machine running Win98. The install seems to go alright, but when I try mysqld--standalone it gives me an error. Then I tried mysqld

Re: Choosing between Databases.

2001-08-27 Thread Paul DuBois
At 11:10 AM -0700 8/27/01, Sheena Sidhu wrote: Hello, I am looking into choosing between Innodb and BDB. One thing about BDB which I am quoting from the official site : Berkeley DB does not support SQL queries. All access to data is through the Berkeley DB API. Developers must learn a new set of

RE: Choosing between Databases.

2001-08-27 Thread Sheena Sidhu
Hi Paul, Thanks for responding. I am not sure if I understand you fully here. SO you mean to say that BDB DOES support SQL, meaning that I send statements like 'Select * from user' to a BDB table from my C++ code? If that is possible, then great. If not, then kindly let me know if Innodb has

RE: Choosing between Databases.

2001-08-27 Thread Paul DuBois
At 1:23 PM -0700 8/27/01, Sheena Sidhu wrote: Hi Paul, Thanks for responding. I am not sure if I understand you fully here. SO you mean to say that BDB DOES support SQL, meaning that I send statements like 'Select * from user' to a BDB table from my C++ code? If that is possible, then great.

RE: Choosing between Databases.

2001-08-27 Thread Sheena Sidhu
Hi Paul, Will not contest your claim at all since you must have tried it to make that claim. So if I agree with you, then don't you think that the statement which is posted earlier :Berkeley DB does not support SQL queries. All access to data is through the Berkeley DB API. is misleading

RE: Choosing between Databases.

2001-08-27 Thread Paul DuBois
Hi Paul, Will not contest your claim at all since you must have tried it to make that claim. So if I agree with you, then don't you think that the statement which is posted earlier :Berkeley DB does not support SQL queries. All access to data is through the Berkeley DB API. is misleading

image data type

2001-08-27 Thread Cheng, Min
Hi there, I treat image data type as text, does anyone know how to insert an image into the table? Thanks Qingmin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

msg board with efficient threaded view design?

2001-08-27 Thread PR
I was wondering if anyone could point me to a message board (perl or php) that has a very efficient database design to handle threaded views. I know that this is a difficult task under mysql and have seen the threads on recursive queries, but I'd like to find some real life examples rather than

RE: Help Needed Please

2001-08-27 Thread Don Read
On 26-Aug-2001 [EMAIL PROTECTED] wrote: Hi I need to set the max_allowed_packet to 16M. below is my 01mysql-server.sh file. I use DBI and I know that I have to start this before the DBI program and I did but if I use ./mysqld --help it shows that my max_allowed_packet is still 1M. Any

Re: image data type

2001-08-27 Thread John Meyer
At 09:15 AM 8/28/01 +1200, you wrote: Hi there, I treat image data type as text, does anyone know how to insert an image into the table? the image data type is actually a BLOB, not text. Usually, it's more efficent to have the field be text, and just store the path to the image

Re: MySQL and GPL license: questions and discussion

2001-08-27 Thread Neil Zanella
On 27 Aug 2001, Trond Eivind Glomsrød wrote: Neil Zanella [EMAIL PROTECTED] writes: 4. Are the Linux versions shipped with Red Hat 7 and 7.1 entirely distributed under the GPL? Yes. This appears to be true after noticing the following file under Red Hat 7.1:

MySQL+InnoDB

2001-08-27 Thread alexus
hi i'm trying to setup mysql w/ InnoDB i followed all steps from http://www.mysql.com/doc/I/n/InnoDB_start.html and i'm end up with this in my log every time i run mysql and in addition it ends here is log file from first time i run mysql 010827 17:07:07 mysqld started InnoDB: The first

Re: Need Help Setting Up MySQL on Win98

2001-08-27 Thread Gerald R. Jensen
Try putting a space between mysqld and --standalone (mysqld --standalone) - Original Message - From: S K Bryan [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Monday, August 27, 2001 2:54 PM Subject: Need Help Setting Up MySQL on Win98 Hello - I'm very new at this, so please

Select in groups of 5

2001-08-27 Thread Tyler Longrne
Hello everyone, Is there any way to make selections in groups of 5. I want to get 5 record sets at a time until we get to a point that there's 4 or less records. Thank you everyone, Tyler database,sql,query,table - Before

RE: Select in groups of 5

2001-08-27 Thread Cal Evans
Select * from yourTable limit 0,5 gets you the first 5. After that: Select * from yourTable limit 5,5 gets you the next five...etc. Cal http://www.calevans.com -Original Message- From: Tyler Longrne [mailto:[EMAIL PROTECTED]] Sent: Monday, August 27, 2001 6:33 PM To: MySQL List

Re: MySQL+InnoDB

2001-08-27 Thread ryc
Yes. delete all ib_ files and all data files specified in my.cnf... and then run mysql again. ryan - Original Message - From: alexus [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 27, 2001 5:16 PM Subject: MySQL+InnoDB hi i'm trying to setup mysql w/ InnoDB i

Question on Table types and EJB persistance

2001-08-27 Thread Michael Tam
Hi all, I know this might be slightly off topics. I was trying to make JBoss/MM-MySQL_JDBC/MySQL to work together. However, I found the following problem. With MyISAM type, the container-managed persists ok; but, with INNODB type, JBoss doesn't able to persist the data back to the

sorting this egroup

2001-08-27 Thread Glyndower
Maybe I overlooking the obvious here, but hey it won't be the first time. How does everyone sort this group in their email client? I have yet to find a way to manage these emails because of the lack of a consistent item in each email. i.e MySql in the subject line etc Suggestions?

Re: MySQL+InnoDB

2001-08-27 Thread alexus
i deleted everything and re-run again and it started fine now.. weird.. - Original Message - From: ryc [EMAIL PROTECTED] To: alexus [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, August 27, 2001 7:56 PM Subject: Re: MySQL+InnoDB Yes. delete all ib_ files and all data files

RE: sorting this egroup

2001-08-27 Thread Daniel Von Fange
I just use the [EMAIL PROTECTED] in the To field of the email. Works like a charm. --Daniel Von Fange -Original Message- From: Glyndower [mailto:[EMAIL PROTECTED]] Sent: Monday, August 27, 2001 8:56 PM To: George Pitcher; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: sorting this

Re: sorting this egroup

2001-08-27 Thread Dana Powers
Every mail on this list has the following header: List-ID: mysql.mysql.com I use maildrop with the following filter: if ( /^List-ID\: \mysql\.mysql\.com\/) { to Maildir/.mysql } hope this helps, dpk - Original Message - From: Glyndower [EMAIL PROTECTED] To: George Pitcher [EMAIL

  1   2   >