Antwort: Re: Problem with UTF8 and upper case german umlaute

2004-05-19 Thread Rainer . Rohmfeld
[EMAIL PROTECTED] 19.05.2004 15:46 An: [EMAIL PROTECTED] Kopie: [EMAIL PROTECTED] Thema: Re: Problem with UTF8 and upper case german umlaute >At a guess, the problem wthe the upper case U-umlaut is that it contains >the backslash character, which is a str

Re: Antwort: Re: Bug im Connector

2003-02-28 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: You have written the following: It seems that the new MySql Connector/J has a "bug". If one calls close() twice on the same statement a NullpointerException is thrown. Best regards Horst Scheruga Hmmm, the following testcase p

Antwort: Re: Bug im Connector

2003-02-28 Thread horst . scheruga
You have written the following: It seems that the new MySql Connector/J has a "bug". If one calls close() twice on the same statement a NullpointerException is thrown. Best regards Horst Scheruga - Before posting, please ch

Antwort: Problem with MySQL server - 3.21.33b

2002-05-15 Thread Samier . Kesou
Hi, check the niced processes (on BSD #ps aux). These are processes which have been assigned a higher priority and there for kill your server. Also the man page from top (the CPU STATE comes from top ?) writes that the nice % should also be seen in user and system % which is not the case in your

Antwort: RE: Re: Problem with MySQL, ODBC, MS Access

2002-03-13 Thread Penkert, Christine
Hi, I´ve already tried using MyODBC 3.51.02 by enabling Dynamic Cursor, it didn´t help. Now I´ve sent a mail to the access newsgroup. I hope it will help. Many thanks for your help. Regards, Christine Hi !! I did looked into you issue and could able to see the behaviour whatver you descr

Antwort: RE: Re: Problem with MySQL, ODBC, MS Access

2002-03-05 Thread Penkert, Christine
Hi, Sorry, it didn´t help. create table tPruefBesch (fTimestamp timestamp(14), fPruefbeschNr int auto_increment not null, fPlanNr int, primary key (fPruefbeschNr)); mysql> explain tPruefBesch; +--+--+---+---++--+ |

Re: Antwort: Re: howto insert an image as blob?

2001-07-30 Thread Maurice Aubrey
On Mon, Jul 30, 2001 at 12:30:34PM +0200, [EMAIL PROTECTED] wrote: > plz tell me if the following statement is correct (just for the fact i cant > find a solution for the problem in jsp at once) > > insert into pictures (picturename,picturedata) values ("testpicture", "c: > \temp\testpicture.gif"

Antwort: Re: howto insert an image as blob?

2001-07-30 Thread bastian . wagner
first i would like to do it as you said. store the pictures outside the database. i develop jsp sites and my problem is that i dont know how to upload a file per jsp. i thought storing the pictures in mysql is the easier way to solve my problem. but if its not good to store binary data in the dat

Re: Antwort: Storing pictures in mySQL

2001-04-04 Thread alexander . skwar
On 04.04.2001 11:21:46 Peter Skipworth wrote: > Ouch! I don't know if many people would recommend this method - that's a > fair bit of unnecesary overhead to place ony our server...depending, of > course, on how often these images are created/modified/read. Do you mean the base64 part, or what?

Re: Antwort: Storing pictures in mySQL

2001-04-04 Thread Johan Andersson
om: "Peter Skipworth" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Nicolas Villatte" <[EMAIL PROTECTED]>; "Mysql (E-mail)" <[EMAIL PROTECTED]> Sent: Wednesday, April 04, 2001 11:21 AM Subject: Re: Antwort: Storing pictures in mySQL > Ouch!

Re: Antwort: Storing pictures in mySQL

2001-04-04 Thread Peter Skipworth
Ouch! I don't know if many people would recommend this method - that's a fair bit of unnecesary overhead to place ony our server...depending, of course, on how often these images are created/modified/read. P > > Here's how I do b) in PHP: > > 1) Get the MIME type of the image. > 2) Read the b

Antwort: Storing pictures in mySQL

2001-04-04 Thread alexander . skwar
On 04.04.2001 08:55:04 Nicolas Villatte wrote: > is it possible? If yes, how ? Could someone *PLEASE* add this to the FAQ? There are two answers you'll get: a) Don't store the binary data in the database. Instead store nothing but the metadata. b) Also store the binary data in the database.

Antwort: Re: Antwort: Re: Warning: Got signal 14 from thread X

2001-03-21 Thread alexander . skwar
On 21.03.2001 12:33:35 Sinisa Milivojevic wrote: > Unfortunately, that is not true !! > > PHP has yet to fix that. That is not a serious error, though, just a > small waste of OS resources. Oh, so you're saying that PHP is buggy wrt this? Thanks for the information!

Antwort: RE: Is storing a whack of text in a binary format ok?

2001-03-21 Thread alexander . skwar
On 21.03.2001 10:14:34 Don Read wrote: > >So I looked in the manual and found that: > >"mysql_query() cannot be used for queries that contain binary data; you > > should use mysql_real_query() instead. " What manual? MySQL manual? If so, disregard that information - it's incorrec

Antwort: jpegs in a database

2001-03-21 Thread alexander . skwar
On 21.03.2001 00:01:16 Mike Baerwolf wrote: > Hello, > > Still trying to get jpegs into my database. I have a blob column setup, How do > I get the jpeg into the blob column? Read the file into a variable and insert it. Make sure to either escape NULLs or to make the data "safe" in other ways

Re: Antwort: Re: Warning: Got signal 14 from thread X

2001-03-21 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: > > On 20.03.2001 14:48:58 Sinisa Milivojevic wrote: > > > Also, do you have clients that do not call mysql_close at the end , > > like PHP programs ? > > Huh? According to the PHP manual, I always thought that it is unnecessary to > explicitly call mysql_clos

Antwort: Re: Warning: Got signal 14 from thread X

2001-03-20 Thread alexander . skwar
On 20.03.2001 14:48:58 Sinisa Milivojevic wrote: > Also, do you have clients that do not call mysql_close at the end , > like PHP programs ? Huh? According to the PHP manual, I always thought that it is unnecessary to explicitly call mysql_close() in PHP. In the PHP manual it says, that the c

Re: Antwort: Webmin

2001-03-15 Thread Alexander Skwar
So sprach Tõnu Samuel am Thu, Mar 15, 2001 at 09:01:58PM +0200: > Sunrise wrote: > > Mysql has the type as the MSSQL BIT??? > > Yes and this is documented in manual. Hi Tõnu (geez, "strange" name you have - can't even paste it :]) Well, since you understood that question of sunrise - could you

Re: Antwort: Webmin

2001-03-15 Thread Tõnu Samuel
Sunrise wrote: > > Hi, alexander.skwar, > > Mysql has the type as the MSSQL BIT??? > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) Yes and this is documented in manual. -- MySQL Development Team

Antwort: Error msg saying what?

2001-03-15 Thread alexander . skwar
On 15.03.2001 11:10:24 Eric Holmbom wrote: > Thu, 15 Mar 2001 11:09:14 +0100 SQL SQLDriverConnect > Thu, 15 Mar 2001 11:09:14 +0100 ERR [TCX][MyODBC]Access denied for > user: 'root@ipaddress' (Using password: YES) Wrong password, I'd say. ---

Antwort: Re: Antwort: Webmin

2001-03-15 Thread alexander . skwar
On 15.03.2001 10:23:19 Sunrise wrote: > Hi, alexander.skwar, > > Mysql has the type as the MSSQL BIT??? Pardon me? What do you mean? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http:

Re: Antwort: Webmin

2001-03-15 Thread Sunrise
Hi, alexander.skwar, Mysql has the type as the MSSQL BIT??? Regards, Sunrise [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list ar

Antwort: Webmin

2001-03-15 Thread alexander . skwar
On 14.03.2001 22:33:13 Charles L Hagen wrote: > Has anyone found a GUI for MySQL on a Linux box? I found Webmin, but it > seems limited. > > Is there an HTML GUI for MySQL? phpMyAdmin - see freshmeat - Before posting, pleas

Antwort: Re: Configure problems

2001-03-14 Thread alexander . skwar
On 13.03.2001 23:37:20 Kevin Price-Ward wrote: > > You can NOT use gcc-2.96. Why not? Compiling works fine, without a problem - anything else that I'm missing? - Before posting, please check: http://www.mysql.com/manual.

Antwort: decimal(8,2) rounding bug or still "to be expected" behaviour?

2001-03-09 Thread alexander . skwar
On 09.03.2001 10:29:28 Christian Hammers wrote: > Is this a bug or is the decimal type just evil or how should *I* behave > when having such a table? If I'm not mistaken, then decimal is handled internally like a float. And as such, problems like yours are really expected, because there simply

Antwort: php libraries

2001-03-08 Thread alexander . skwar
On 08.03.2001 13:39:34 James Makunike wrote: > Where do I get the php libraries as one file? What do you mean? http://www.php.net has the sources and binaries - Before posting, please check: http://www.mysql.com/manual.p

Re: Antwort: Datatype for comment field

2001-03-07 Thread Gilles Dumangin
rom: [EMAIL PROTECTED] >To: "Nguyen, David M" <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Antwort: Datatype for comment field >Date: Wed, 7 Mar 2001 11:25:02 +0100 > > >On 06.03.2001 18:43:32 Nguyen, David M wrote: > > > I try to create a new table a

Antwort: Bug in 3.23.33? Or design decision?

2001-03-07 Thread alexander . skwar
On 06.03.2001 19:05:34 iso-8859-1 wrote: >Is this expected behavior? Or is this an actual bug? I suppose this may be expected behavior, as FullText now is a reserved word in MySQL - Before posting, please check: http

Antwort: Datatype for comment field

2001-03-07 Thread alexander . skwar
On 06.03.2001 18:43:32 Nguyen, David M wrote: > I try to create a new table and setup a datatype for comment column that has > about 7000 characters long. How do I define it in Oracle? That's the MySQL mailing list, you know No idea how to do stuff in Oracle. > > **Here's my SQL and the

Re: Antwort: ReisserFS

2001-03-02 Thread Tõnu Samuel
Tim Bunce wrote: > > Only problem we know is that in our tests on ReiserFS is MySQL was 30% > > faster on writes :/ > > How does it compare to FreeBSD with "soft updates" enabled? Sorry, I use only linux and very rarely touch anything else. So this 30% was meant under linux. Sorry for confusion

Re: Antwort: boolean type

2001-03-02 Thread Robert Vetter
"Thalis A. Kalfigopoulos" wrote: > > > > Is there a boolean field type (Yes/No; True/False, 1/0) in MySQL or what is > > > closest to the boolean type > > > > ShortInt: 0 == FALSE, <> 0 == TRUE > > That's how I do it anyway. > > > > Or maybe combine multiple bool fields to one and use binary l

Re: Antwort: Re: boolean type

2001-03-02 Thread Alexander Skwar
So sprach Robert Vetter am Thu, Mar 01, 2001 at 04:55:34PM +0100: > 1 or 2 bytes, depending on the number of enumeration values (65535 > values maximum). I've read this in the _MANUAL_ ! Heh, okay, thanks *G* Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (

Re: Antwort: Re: Why Heap Tables doesn´t support auto increment ?colums

2001-03-02 Thread Alexander Skwar
So sprach Gerhard Schmidt am Thu, Mar 01, 2001 at 04:02:54PM +0100: > Besides the fakt tha this ID not unique. There ist the Problem that > the ID you proposed ist an String ID and strings als Index are the Well, but he could make a two column primary key, where the first is the timestamp, and

Re: Antwort: Re: Why Heap Tables doesn´t support auto in =?iso-8859-1?Q?crement_ colums?=

2001-03-02 Thread Alexander Skwar
So sprach Entryon Corp., Chief Technical Officer - P. Hasenfratz am Thu, Mar 01, 2001 at 02:37:30PM +0100: > What's if you combine a timestamp with the client's IP address? IP addresses can be easily forged, especially if you're writing some kind of web application, so this is also not a good ch

RE: Antwort: PHP and MySQL - Default Socket Setting

2001-03-02 Thread Jim Beigel
2001 9:33 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: Antwort: PHP and MySQL - Default Socket Setting > > > [EMAIL PROTECTED] wrote: > > > > On 01.03.2001 11:55:40 Ben Kennish wrote: > > > > > "Warning: MySQL Connection Failed: C

Re: Antwort: PHP and MySQL - Specifying location for mysql.sock

2001-03-01 Thread Gerald L. Clark
> From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, March 01, 2001 6:19 AM > > To: Ben Kennish > > Cc: [EMAIL PROTECTED] > > Subject: Antwort: PHP and MySQL > > > > On 01.03.2001 11:55:40 Ben Kennish wrote: > > > > >

Re: Antwort: boolean type

2001-03-01 Thread Thalis A. Kalfigopoulos
> > Is there a boolean field type (Yes/No; True/False, 1/0) in MySQL or what is > > closest to the boolean type > > ShortInt: 0 == FALSE, <> 0 == TRUE > That's how I do it anyway. > > Or maybe combine multiple bool fields to one and use binary logic. Or quoting from http://www.bitbybit.dk/mys

Re: Antwort: Re: any ASP/ADO/MySQL programmers out there? (LONG answer)

2001-03-01 Thread Bob Hall
>On 28.02.2001 13:13:05 Bob Hall wrote: > > > >Og nu da jeg så nærmere på din email adresse, er du selvfølgelig velkommen > > >til at spørge på dansk... ;-) > > > > Det er alltid hyggelig å se på andre språg på internettet, men hvis > > du skriver på dansk, så skal de aller fleste taper sjans

Re: Antwort: PHP and MySQL - Specifying location for mysql.sock

2001-03-01 Thread Ben Kennish
Ensure that /var, /var/lib, and /var/lib/mysql have > permissions set to: drwxr-xr-x > > This cured the problem for me. > > rick > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 01, 2001 6:19 AM > To: Ben Kenn

Re: Antwort: Re: boolean type

2001-03-01 Thread Robert Vetter
[EMAIL PROTECTED] wrote: > > On 01.03.2001 13:51:58 Robert Vetter wrote: > > > ENUM("no","yes") > > I always wondered: How much space does this take? 1 or 2 bytes, depending on the number of enumeration values (65535 values maximum). I've read this in the _MANUAL_ ! Robert

Re: Antwort: Re: Why Heap Tables doesn´t support auto increment ?colums

2001-03-01 Thread Gerhard Schmidt
On Thu, Mar 01, 2001 at 02:37:30PM +0100, Entryon Corp., Chief Technical Officer - P. Hasenfratz wrote: > > > Why not use a timestamp column to guarentee the order in which rows get > > > inserted into the table? You can then order on the timestamp column. > > > > Hmm, timestamp, ie. seconds as f

Re: Antwort: Re: Antwort: AW: version 3.23.29a-1

2001-03-01 Thread Rolf Hopkins
- From: <[EMAIL PROTECTED]> To: "Rolf Hopkins" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, March 01, 2001 16:42 Subject: Antwort: Re: Antwort: AW: version 3.23.29a-1 > > On 01.03.2001 02:37:17 Rolf Hopkins wrote: > > > Or use the n

Antwort: Error 1052:Query problem

2001-03-01 Thread alexander . skwar
On 01.03.2001 13:16:47 soon chee keong wrote: > Table_A: ID APPL > > B BI > A BII > * * > * * > C BII > * * > D BI > > Table_B: Cnty ID > >

AW: Antwort: Select from dual?

2001-03-01 Thread Stephan Skusa
di > Cc: [EMAIL PROTECTED] > Betreff: Antwort: Select from dual? > > > > On 01.03.2001 10:46:33 M. A. Ould-Beddi wrote: > > > I know that in Oracle it is possible to select a number > > from DUAL and put it i

RE: Antwort: PHP and MySQL

2001-03-01 Thread Rick Emery
PROTECTED] Subject: Antwort: PHP and MySQL On 01.03.2001 11:55:40 Ben Kennish wrote: > "Warning: MySQL Connection Failed: Can't connect to local MySQL server > through socket '/var/lib/mysql/mysql.sock' (111) in > /var/www/html/index.php on line 5" Are you sure th

Re: Antwort: PHP and MySQL - Default Socket Setting

2001-03-01 Thread Ben Kennish
[EMAIL PROTECTED] wrote: > > On 01.03.2001 11:55:40 Ben Kennish wrote: > > > "Warning: MySQL Connection Failed: Can't connect to local MySQL server > > through socket '/var/lib/mysql/mysql.sock' (111) in > > /var/www/html/index.php on line 5" > > Are you sure that your MySQL installation create

Re: Antwort: Re: Why Heap Tables doesn´t support auto increment colums

2001-03-01 Thread Entryon Corp., Chief Technical Officer - P. Hasenfratz
> > Why not use a timestamp column to guarentee the order in which rows get > > inserted into the table? You can then order on the timestamp column. > > Hmm, timestamp, ie. seconds as finest resolution, might be to broad depending on > the hits his site will get - imagine that 2+ users access the

Antwort: Transactions...

2001-03-01 Thread alexander . skwar
On 01.03.2001 12:35:55 Gorjan Todorovski wrote: > So does mySQL support transactions or not? There are transaction safe tables > but they are not actually implemented? They are implemented, if you chose the right table type. ---

Antwort: PHP and MySQL

2001-03-01 Thread alexander . skwar
On 01.03.2001 11:55:40 Ben Kennish wrote: > "Warning: MySQL Connection Failed: Can't connect to local MySQL server > through socket '/var/lib/mysql/mysql.sock' (111) in > /var/www/html/index.php on line 5" Are you sure that your MySQL installation creates the socket right there? If I'm not mis

Antwort: Re: Why Heap Tables doesn´t support auto increment colums

2001-03-01 Thread alexander . skwar
On 01.03.2001 11:56:59 Richard Ellerbrock wrote: > Why not use a timestamp column to guarentee the order in which rows get > inserted into the table? You can then order on the timestamp column. Hmm, timestamp, ie. seconds as finest resolution, might be to broad depending on the hits his site wi

Antwort: New mechanism in retrieving data from tables

2001-03-01 Thread alexander . skwar
On 28.02.2001 22:40:39 UzeV wrote: > Hi, > > The webhosting company where I host my my site had upgraded their mysql to > 3.23.32 > and now my program has an error, saying : > > Supplied argument is not a valid MySQL result resource in > > the error is in the line containing : > while (

Antwort: boolean type

2001-03-01 Thread alexander . skwar
On 01.03.2001 09:50:36 Blaz Grapar wrote: > Is there a boolean field type (Yes/No; True/False, 1/0) in MySQL or what is > closest to the boolean type ShortInt: 0 == FALSE, <> 0 == TRUE That's how I do it anyway. Or maybe combine multiple bool fields to one and use binary logic. ---

Antwort: Select from dual?

2001-03-01 Thread alexander . skwar
On 01.03.2001 10:46:33 M. A. Ould-Beddi wrote: > I know that in Oracle it is possible to select a number > from DUAL and put it in a variable. Is it possible ??? What's DUAL? - Before posting, please check: http://www.mys

Antwort: A query?

2001-03-01 Thread alexander . skwar
On 01.03.2001 09:59:58 Patrik Nylund wrote: > Hi everybody, I qould like to this query: select userid,count(userid) as cnt from points where acq=6 AND cnt > 1 group by userid limit 100 - Before posting, please check: htt

Antwort: auto_increments

2001-03-01 Thread alexander . skwar
On 01.03.2001 01:54:14 John Nielsen wrote: > Hey everyone, > > This may have already come up a couple of times in the mailling list, but I > I was wondering with mysql-3.22.32 if you can have two auto_increment's > in one table, e.g.: What would this be good for? Yes, I've seen that one of yo

Antwort: Re: Antwort: AW: version 3.23.29a-1

2001-03-01 Thread alexander . skwar
On 01.03.2001 02:37:17 Rolf Hopkins wrote: > Or use the no dependency flag or upgrade. That's as good as suggesting to not use rpm at all. The dependencies are in there with a reason, you know. Never upgrade/install with --force/--nodeps.

Antwort: Re: [auto_increment]

2001-03-01 Thread alexander . skwar
On 28.02.2001 22:51:12 Jason Landry wrote: > Well, except that the value of an auto-increment field CAN be set to a > specific value (perhaps negative) an INSERT or UPDATE statement. As long as the value is != 0 for INSERT statements. -

Antwort: Re: Antwort: Re: Antwort: RE: how to backup mySQL database?

2001-03-01 Thread alexander . skwar
On 28.02.2001 19:51:13 Gerald L. Clark wrote: > In the dump, the autoincrement columns will have their actual values, > not 0. Yes, correct - and if the actual value is 0, it will contain just this. And inserting a row with the col set to 0, will change the column value. TRY IT! -

Antwort: RE: Antwort: RE: how to backup mySQL database?

2001-03-01 Thread alexander . skwar
On 28.02.2001 05:58:33 ?US-ASCII?Q?Fabio_Ottolini?= wrote: > mysqldump "spits" not only table structures but data also. When you use > mysql to import data it will first attempt to create the table and then load > its values. If your table's got AUTO_INCREMENT set it will work fine after > recre

Re: Antwort: RE: Antwort: Re: any ASP/ADO/MySQL programmers out there? (LONG answer)

2001-02-28 Thread Rolf Hopkins
- Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 01, 2001 4:08 Subject: Antwort: RE: Antwort: Re: any ASP/ADO/MySQL programmers out there? (LONG answer) > Ja, das is ganz richtig. Ich glaube wenn Mann hier postet, shreibt h

Re: Antwort: AW: version 3.23.29a-1

2001-02-28 Thread Rolf Hopkins
Or use the no dependency flag or upgrade. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 28, 2001 23:36 Subject: Antwort: AW: version 3.23.29a-1 > > On 28.02.2001 14:28:14 Tobias Wolff wrote: > > > The binar

Antwort: RE: Antwort: Re: any ASP/ADO/MySQL programmers out there? (LONG answer)

2001-02-28 Thread Me
: [EMAIL PROTECTED]; Bob Hall Cc: [EMAIL PROTECTED] Subject: Re: Antwort: Re: any ASP/ADO/MySQL programmers out there? (LONG answer) Hi Since the language of business here at MySQL is English it would be nice if all messages to the list are written in English. This way you would have more chance of

Re: Re: Re: Re: Re: Antwort: Re: Antwort: Re: any ASP/ADO/MySQL programmers out there? (LONG answer)

2001-02-28 Thread Entryon Corp., Chief Technical Officer - P. Hasenfratz
PROTECTED]> Cc: "Bob Hall" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, February 28, 2001 7:40 PM Subject: Re: Antwort: Re: Antwort: Re: any ASP/ADO/MySQL programmers out there? (LONG answer) > > > Hi > > > Since the language of business he

Re: Antwort: Re: Antwort: RE: how to backup mySQL database?

2001-02-28 Thread Gerald L. Clark
[EMAIL PROTECTED] wrote: > > On 28.02.2001 16:03:57 Gerald L. Clark wrote: > > > But the dump who't have it set to zero, so it will reload with its > > proper value. > > No, in the dump the column will be set to zero, but since "INSERT INTO Tbl > (AutoCol) VALUES (0)" means that AutoCol should

Re: Antwort: Re: Antwort: Re: any ASP/ADO/MySQL programmers out there? (LONG answer)

2001-02-28 Thread Jason Landry
> On 28.02.2001 15:33:27 John Dean wrote: > > > Hi > > Since the language of business here at MySQL is English it would be nice if > > all messages to the list are written in English. This way you would have more > > chance of receiving reply > > Yeah, that's just what I was saying :] > But I'm s

Antwort: Re: Antwort: Re: any ASP/ADO/MySQL programmers out there? (LONG answer)

2001-02-28 Thread alexander . skwar
On 28.02.2001 15:33:27 John Dean wrote: > Hi > Since the language of business here at MySQL is English it would be nice if > all messages to the list are written in English. This way you would have more > chance of receiving reply Yeah, that's just what I was saying :] --

Antwort: Re: Antwort: RE: how to backup mySQL database?

2001-02-28 Thread alexander . skwar
On 28.02.2001 16:03:57 Gerald L. Clark wrote: > But the dump who't have it set to zero, so it will reload with its > proper value. No, in the dump the column will be set to zero, but since "INSERT INTO Tbl (AutoCol) VALUES (0)" means that AutoCol should be set to the next available value (if Au

RE: Antwort: RE: how to backup mySQL database?

2001-02-28 Thread Fabio Ottolini
Fabio Ottolini -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald L. Clark Sent: Wednesday, February 28, 2001 12:04 PM To: [EMAIL PROTECTED] Cc: Fabio Ottolini; [EMAIL PROTECTED] Subject: Re: Antwort: RE: how to backup mySQL database? [EMAIL P

Antwort: AW: version 3.23.29a-1

2001-02-28 Thread alexander . skwar
On 28.02.2001 14:28:14 Tobias Wolff wrote: > The binary may have a different name. If there is only a /usr/bin/perl you > may have to create and symbolic link. Which won't work, because RPM doesn't care at all about what the filesystem really looks like. All it cares about is what it THINKS sh

Re: Antwort: RE: how to backup mySQL database?

2001-02-28 Thread Gerald L. Clark
[EMAIL PROTECTED] wrote: > > On 28.02.2001 21:26:17 ?iso-8859-1?Q?F=E1bio_Ottolini?= wrote: > > > Try using mysqldump. > > This won't work always! For instance, I have a table that has a auto_increment > INT column in it. Storing a row with this column set to 0 (zero), will add this > row jus

Re: Antwort: Re: any ASP/ADO/MySQL programmers out there? (LONG answer)

2001-02-28 Thread John Dean
Hi Since the language of business here at MySQL is English it would be nice if all messages to the list are written in English. This way you would have more chance of receiving reply On Wednesday 28 February 2001 12:54, [EMAIL PROTECTED] wrote: > On 28.02.2001 13:13:05 Bob Hall wrote: > > >Og

Antwort: Re: any ASP/ADO/MySQL programmers out there? (LONG answer)

2001-02-28 Thread alexander . skwar
On 28.02.2001 13:13:05 Bob Hall wrote: > >Og nu da jeg så nærmere på din email adresse, er du selvfølgelig velkommen > >til at spørge på dansk... ;-) > > Det er alltid hyggelig å se på andre språg på internettet, men hvis > du skriver på dansk, så skal de aller fleste taper sjansen å lære om > A

Re: Antwort: Re: storage and retrieval of images

2001-02-28 Thread Rolf Hopkins
- Original Message - From: <[EMAIL PROTECTED]> To: "Rolf Hopkins" <[EMAIL PROTECTED]> Cc: "Geetha Narayanan" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, February 28, 2001 17:01 Subject: Antwort: Re: storage and retrieval of images

Antwort: Re: how to backup mySQL database?

2001-02-28 Thread alexander . skwar
On 28.04.2003 10:55:50 Keneth wrote: > "When I try to dump sql database it gives me some errors 1.Error 1045 > mysqldump --opt database > backup-accp.sql mysqldump: Got error: 1045: > Access denied for user: 'accp@localhost' (Using pass word: NO) " You did not specify the username and password

Antwort: RE: how to backup mySQL database?

2001-02-28 Thread alexander . skwar
On 28.02.2001 21:26:17 ?iso-8859-1?Q?F=E1bio_Ottolini?= wrote: > Try using mysqldump. This won't work always! For instance, I have a table that has a auto_increment INT column in it. Storing a row with this column set to 0 (zero), will add this row just fine. But now the row will not have th

Antwort: Re: storage and retrieval of images

2001-02-28 Thread alexander . skwar
On 28.02.2001 05:17:09 Rolf Hopkins wrote: > But the way you are doing it now is perfectly ok. You may even find it a Not always! There are setups where it is better to store the image in the database instead of on the filesystem. ---

Antwort: ?

2001-02-27 Thread alexander . skwar
On 27.02.2001 14:11:51 Toth Dalibor wrote: > I managed to make, a match throughout multiple fields but single table: > SELECT rid,nazivRecepta,MATCH nazivRecepta,uvod,nacinPripreme AGAINST > ('vegetine') as relevance FROM recepti order by relevance desc > > I also need to include nazivSastojka f

Antwort: Security Question

2001-02-27 Thread alexander . skwar
On 27.02.2001 12:00:38 wrote: > then i try the following and i get the error message. WHAT error message? > > load data local inifile "c:\text.txt" into table dbname.tblname fields > terminated by ',' ; Hmm, as you don't tell us the error message that you're getting, it's hard to help you. I

Antwort: ?

2001-02-27 Thread alexander . skwar
On 27.02.2001 09:51:02 Toth Dalibor wrote: > What is wrong here??!! Missing a , at the line above - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the lis

Re: Antwort: tab-completition not working with libreadline4

2001-02-26 Thread Christian Hammers
On Mon, Feb 26, 2001 at 03:02:41PM +0100, [EMAIL PROTECTED] wrote: > > Since a few weeks tablename completition using tab is not working any longer. > Are you sure that the table information is actually read at start of mysql? Do > a 'rehash' and see if it works then. Cool that helped, thank you.

Antwort: MySQL question to ask

2001-02-26 Thread alexander . skwar
On 26.02.2001 14:45:50 Dart wrote: > Dear all, > Sorry to ask question again, or maybe i am just a beginner. > > I wanna ask: > If there are 2 records > Name Income Out > Data1 1000 700 > Data2970500 > > If i want to have the output: >

Antwort: Error in "select .... from.... where..." with BDB

2001-02-26 Thread alexander . skwar
On 26.02.2001 14:19:40 TisSoft s.c. wrote: > PRIMARY KEY (SYMBOL), > UNIQUE SYMBOL (SYMBOL) What's the sense of this? PRIMARY is already UNIQUE, so you don't need to UNIQUE symbol again. - Before posting, please check:

Antwort: tab-completition not working with libreadline4

2001-02-26 Thread alexander . skwar
On 26.02.2001 13:36:20 Christian Hammers wrote: > Hello > > Since a few weeks tablename completition using tab is not working any longer. Are you sure that the table information is actually read at start of mysql? Do a 'rehash' and see if it works then. -

Antwort: LOOKING FOR A FRONTEND FOR MYSQL

2001-02-26 Thread alexander . skwar
On 26.02.2001 12:54:02 MANGERA, Faizal wrote: > Hi everyone, > > Is there a front-end available for Mysql. I am currently using Mascon as an > administrative front-end, which is very good. However I need a front-end > with less administrative features, something where-by users can > create/edi

Re: Antwort: Saving pictures in MySql

2001-02-24 Thread Irmund Thum
Danie Weideman schrieb: > > I played around with fread PHP function but with no-luck how about fopen(), or $fp=fsockopen( "$host", 80,); $anfrage="GET $seite HTTP/1.0\r\n"); etc. IrmundThum - Before posting, please check:

Re: Antwort: Saving pictures in MySql

2001-02-24 Thread Danie Weideman
Hi All Thanks for the info but I need to be able to read a selected file from client host and write this to te db. I use this to get the file from client Picture: this gets the path and file name. When doing a insert the best I can do is to save path+file name into db field. I played around

Re: Antwort: ReisserFS

2001-02-23 Thread Tim Bunce
On Fri, Feb 23, 2001 at 11:29:21AM +0200, Tõnu Samuel wrote: > [EMAIL PROTECTED] wrote: > > > > On 22.02.2001 16:22:13 Simon Windsor wrote: > > > > > Has anyone user MySql on a ReisserFS file system ? > > > > HERE! > > > > No problems whatsoever - why should there be problems anyway? > > Only

Antwort: Changing field types?

2001-02-23 Thread alexander . skwar
On 23.02.2001 13:35:33 ?iso-8859-1?Q?Daniel_Als=E9n?= wrote: > tried changing the type to TEXT and 2000 as fieldlength. But i only get a > syntax error. What did you type and what was the error? Maybe the VARCHAR field was indexed without bounds? That's not possible for BLOB types; you have t

Antwort: Saving pictures in MySql

2001-02-23 Thread alexander . skwar
On 23.02.2001 13:01:44 Danie Weideman wrote: > What field type must be defined for pictures. MEDIUMTEXT for the data VARCHAR/ENUM/INTEGER/whatever for the image type > How to load and retreive pictures from a database using PHP The same you do with "normal" data. Ie.: Store:INSERT INTO T

Re: Antwort: Re: Antwort: ReisserFS

2001-02-23 Thread Tõnu Samuel
[EMAIL PROTECTED] wrote: > > On 23.02.2001 10:29:21 ?iso-8859-1?Q?T=F5nu?= Samuel wrote: > > > Only ¨problem¨ we know is that in our tests on ReiserFS is MySQL was 30% > > faster on writes :/ > > Hmm, so, I understand you right: You're saying that it's not a good idea to use > MySQL on ReiserFS

Antwort: help booting mysql

2001-02-23 Thread alexander . skwar
On 23.02.2001 11:52:27 Software by ScuoLavoro wrote: > Warning: MySQL Connection Failed: Can't connect to MySQL server on 'localhost' > (10061) in lib.inc.php3 on line 255 > Erreur > coul someone help me? With such a "descriptive" error message? Please also post the line 255 to the list. But

RE: Antwort: date datatype

2001-02-23 Thread Julian Strickland
; Cc: [EMAIL PROTECTED] > Subject: Antwort: date datatype > > > On 23.02.2001 11:44:55 mvandaele wrote: > > > I tried a lot of statements similar to this one from visual basic on an > access > > > database: > > "select * from Times where&

Antwort: date datatype

2001-02-23 Thread alexander . skwar
On 23.02.2001 11:44:55 mvandaele wrote: > I tried a lot of statements similar to this one from visual basic on an access > database: > "select * from Times where" & strField & " between '" & CDate(FilterA) & "' and > '" & CDate(FilterB) & "'" > > =select * from Times where StartTime between '20

Antwort: Re: Antwort: ReisserFS

2001-02-23 Thread alexander . skwar
On 23.02.2001 10:29:21 ?iso-8859-1?Q?T=F5nu?= Samuel wrote: > Only ¨problem¨ we know is that in our tests on ReiserFS is MySQL was 30% > faster on writes :/ Hmm, so, I understand you right: You're saying that it's not a good idea to use MySQL on ReiserFS, as you may get a speed rush? *G* ---

Re: Antwort: ReisserFS

2001-02-23 Thread Tõnu Samuel
[EMAIL PROTECTED] wrote: > > On 22.02.2001 16:22:13 Simon Windsor wrote: > > > Has anyone user MySql on a ReisserFS file system ? > > HERE! > > No problems whatsoever - why should there be problems anyway? Only ¨problem¨ we know is that in our tests on ReiserFS is MySQL was 30% faster on writ

Antwort: Re: Suggestion For List Management

2001-02-23 Thread alexander . skwar
On 22.02.2001 18:06:12 Quickling wrote: > 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 har

Antwort: RE: Suggestion For List Management

2001-02-23 Thread alexander . skwar
On 22.02.2001 17:55:36 Jon Haworth wrote: > Well, you could filter anything sent or cc'ed to [EMAIL PROTECTED] into > a separate folder But only, if your client allows that - and changing is not always an option! - Befor

Antwort: Suggestion For List Management

2001-02-23 Thread alexander . skwar
On 22.02.2001 12:08:06 Jeff Gannaway wrote: > I've only been on the list for a day and a half. However I'm a memeber of > 3 high-volume lists and I can tell that adopting this technique would make > my life easier, and presumably other list memebers too. It definitely > makes it easier to sort

Antwort: ReisserFS

2001-02-23 Thread alexander . skwar
On 22.02.2001 16:22:13 Simon Windsor wrote: > Has anyone user MySql on a ReisserFS file system ? HERE! No problems whatsoever - why should there be problems anyway? - Before posting, please check: http://www.mysql.com/ma

Antwort: web based admin?

2001-02-20 Thread alexander . skwar
On 20.02.2001 10:08:18 ited wrote: > why do [would] you want to *admin* MySQL over the web (say, with phpMyAdmin)? Because especially phpMyAdmin allows me to nicely see what's in the database and administer it? Hmm, I know, questions should not be answered by questions, but why would you *NOT

  1   2   >