SpamAssassin tags messages from the list as spam (was: [fwd] *****SPAM***** Re: Problems with Time field (from: dump_pj@rediffmail.com))

to rename this page? Maybe to rem.php, or something like this. It would be enough, if this would be a symlink on the server to unsubscribe.php. Thanks, Alexander Skwar - Forwarded message from p j j [EMAIL PROTECTED] - From: p j j [EMAIL PROTECTED] Date: 6 May 2002 06:09:01 - Subject

Re: Date and Mysql...

and still got a good copy of date around. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.iso-top.de | Jabber: [EMAIL PROTECTED] iso-top.de - Die günstige Art an Linux Distributionen zu kommen

Re: [SECURITY] How do these blank passwords get into mysql.user?

! BTW: You don't have to insert the user manually. If you try to GRANT access to a non existing user, the user will be silently created. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.iso-top.de | Jabber: [EMAIL

Re: Stored Procedure

So sprach »Cafetechno« am 2001-12-26 um 10:34:59 +0700 : If mysql will include the stored procedure feature, what kind of langguage to be used for the stored procedure ? If you use myperl, it will be perl. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to

Re: Stored Procedure

So sprach »Fredrick Bartlett« am 2001-12-26 um 07:30:44 -0800 : Explain how to configure the handlers for myperl under the win32 platform... I don't know. filter: sql Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http

Re: help bad

So sprach »Webmaster« am 2001-12-25 um 10:30:47 -0500 : i meant 3.23.. just so you all know Fine... And the problem is...? Filter: sql Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.iso-top.de | Jabber

Re: letter 'O' with umlaut not equivalent to regular 'O'?

is, that comparisons with a BINARY VARCHAR are case sensitive, whereas VARCHARs are case insensitive. sql Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.iso-top.de | Jabber: [EMAIL PROTECTED] iso-top.de - Die

Re: Please redo this horrible web page

So sprach »Keith C. Ivey« am 2001-11-28 um 16:27:46 -0500 : Does that work for you? The MySQL button on the side links to a Yep, it does. Mozilla 0.9.6, Opera 5.05tp1 and Konqueror 2.2.1 checked; all on Linux. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote

Re: att.beready.com tech support has noticed something wrong with one of the downloads.

just fine. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 1 day 10 hours 17 minutes

Re: Oops... I think I deleted mysql.sock - WHAT CAN I DO?

the mysql process runs under. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 2 hours

Re: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

So sprach »Felipe Baytelman« am 2001-09-19 um 11:37:36 -0400 : I'm getting ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Does the file actually exist? I know that you deleted it, but Alexander Skwar -- How to quote: http://learn.to

Re: Stored Procedures and Triggers of MySQL

So sprach »Kimman Lui« am 2001-09-03 um 16:26:33 +0800 : How many types of triggers MySQL have? And what about stored procedures? none and (close to) none. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http

Re: MAILER-DAEMON@123box.co.uk: 123box.co.uk mail delivery system

So sprach »s . keeling« am 2001-08-31 um 11:51:00 -0600 : Is anyone else getting these goofy bounces from 123box.co.uk besides me? Should I report them to Spamcop? :-) i'm getting these as well. database, sql, ... Alexander Skwar -- How to quote: http://learn.to/quote (german) http

[fwd] Re: Re: any sequence generator function? (from: mysql@lists.mysql.com)

database,sql,query,table So sprach =BBJaime Teng=AB am 2001-08-31 um 03:53:47 +0800 : Is there a number sequence generator/function in you can set the INT types to auto_increment, which will do just that when you insert rows. Alexander Skwar -- How to quote: http://learn.to/quote (german

Re: Telnet

So sprach »James McLaughlin« am 2001-07-28 um 13:24:21 -0600 : PHPmyAdmin is a great program to use for working with a mySQL DB. http://www.phpwizard.net/projects/phpMyAdmin/ Or, for a more recent version of phpMyAdmin: http://phpMyAdmin.sourceforge.net PS: sql Alexander Skwar -- How

Re: Telnet

a telnet session. PS: sql Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 5 hours 8

Re: Best Operating System

? Honestly, I really think this is a *BAD* advice... Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen

Re: mysql and credit cards

then. Which is fine in certain use cases. PS: filter sql Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen

[fwd] Re: Re: mysql and credit cards (from: mysql@lists.mysql.com)

database,sql,query,table So sprach =BBPeter van Dijk=AB am 2001-07-25 um 23:59:48 +0200 : That is only true for a parallel cipher. A non-parallel cipher (like Yep, that's why I said symetrical encryption. Asymetrical enc.'s work like you explained. Alexander Skwar -- How to quote: http

[fwd] Re: mysql and credit cards (from: ASkwar@DigitalProjects.com)

unhappy so he may go. PS: PLEASE *NO* FULLQUOTES! No topquotes either. PPS: sql and such Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art

Re: mysql and credit cards

So sprach »Alexander 'Digital Projects' Skwar« am 2001-07-26 um 18:48:15 +0200 : MySQL's builtin ENCRYPT() function is good enough. No need to worry Uhm, is ENCRYPT decryptable? Anyhow, I was rather thinking about ENCODE()/DECODE(). PS: filter sql Alexander Skwar -- How to quote: http

[fwd] Returned mail: Host unknown (Name server: mailserv: host not found) (from: MAILER-DAEMON@host2.webprovider.net)

] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] List-Subscribe: mailto:[EMAIL PROTECTED] Delivered-To: mailing list [EMAIL PROTECTED] Received: (qmail 21241 invoked from network); 26 Jul 2001 16:48:40 - Date: Thu, 26 Jul 2001 18:51:30 +0200 From: Alexander Skwar

Re: FW: encrypt

So sprach »Christian Grimm« am 2001-07-25 um 22:16:04 +0200 : sa must be a 2-char long Salt-String... Which is completely optional :) sql,database,filter Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http

Re: mysql and credit cards

to decrypt the cc# which is not stored on the same computer as the MySQL database. But then you need to worry about how to securly transfer the data from the MySQL database to the computer running the decryption program. So, overall, I'd say: Don't hassle with encryption: It's not worth it. Alexander

Re: Text how many characters

be true, if you disregard the fact that you cannot store 8 MB in a TEXT field. benefit of TINYTEXT over a VARCHAR field? This, I always wondered myself... Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com

mysqldump loses auto_increment

value i set. So, if I'd replay the dump, the first time I insert a row it would get 1 for the auto_increment, and not 4711. How to circumvent this? Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com

Re: modifying table with sort/unique

: SELECT * FROM this_table ORDER BY name, time GROUP BY CONCAT(field1, field2); Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux

Re: mysqldump loses auto_increment

it itself. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 14 hours 30 minutes

Re: Any workaround for no union operation?

So sprach »Sinisa Milivojevic« am 2001-07-16 um 14:20:07 +0300 : MySQL 4.0 will be this autumn. Very fine! Thanks a lot! Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de

Using IF to select table (from part of SELECT)?

. Would this work? SELECT Cities.Name FROM Profiles, IF(Profiles.CityID 7, Cities1, Cities2) AS Cities WHERE Profiles.ID = Cities.ID AND Profiles.ID = 4711; Thanks, Alexander Skwar filter: sql -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage

Re: what' about my current database if I reinstall mysql and my linux

So sprach »Prabu Subroto« am 2001-07-15 um 01:00:17 -0700 : Dear my beloved e-pals, Hello beloved Prabu! :) engine...? Under which directory is my database On RedHat/Mandrake it's in /var/lib/mysql. But actually you might not need it. Have a look at mysqldump. Alexander Skwar -- How

Re: Any workaround for no union operation?

o sprach Sinisa Milivojevic am 2001-07-14 um 15:24:32 +0300: Unions will soon come in 4.0. Yes, I know, bad question, but anyhow: How soon is 4.0 going to come? Tomorrow :), end of the month, end of the year? PS: database,sql,query,table Alexander Skwar -- How to quote: http://learn.to

Heap Tables

Hello When I store some data in a table of type Heap, this data will be lost when the server is shutdown (and later restarted), won't it? Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http

Re: Heap Tables

So sprach »Fournier Jocelyn [Presence-PC]« am 2001-07-15 um 23:37:57 +0200 : Hi, Definitely yes :) But the table structure won't be lost. Thanks to all who replied! filter: sql Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage

Re: MySQL authentication module for Apache

So sprach --==[bMan]==-- am Sat, Jun 09, 2001 at 06:35:31PM -0400: Where can I get MySQL authentication module for Apache? try google.com - the first hit for the exact quesion you asked will tell you Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english

Re: CGI/Perl and MySQL (OT?)

So sprach Jeffrey L. Fitzgerald am Wed, Jun 06, 2001 at 12:08:18AM -0400: Currently the text coming back from the database is all runs together in the web browser... Try nl2br - php.net/nl2br Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english

Re: which the best

also say that RedHat is somewhat nice. I'd take Mandrake, though. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu

Re: PHP MySQL

and ', so it's still a good idea to htmlentites' it if it's only going to be printed afterwards. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art

Re: Values of SET columns with commas (,) are not distinguishable from multiple values

the \\ in my ALTER TABLE statement survived. This is very strange/I don't understand it all Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art

Re: time and date

a DATETIME or TIMESTAMP column. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 0 hours

Re: Case question on inserting data

So sprach Dave Carter am Fri, May 25, 2001 at 06:21:08PM -0400: Is there a way inside of mysql to force the case of data being inserted into the database??? - http://www.mysql.com/doc/S/t/String_functions.html LOWER() / LCASE() and UPPER() / UCASE() Alexander Skwar -- How to quote: http

Re: Reformatting a DATESTAMP out of a table into a readable display date with SELECT

at http://mysql.com/doc Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 6 days 10 hours 27

Re: time and date

will automatically update everytime you update/insert a row, or use a DATETIME column which you'll have to set to the date you want, eg. with 'INSERT INTO Tbl SET DatetimeColumn = NOW();' Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage

Re: sorted select

+0300: SELECT DISTINCT MYID from Table; How can I get the results ordered by time ? SELECT DISTINCT MYID from Table order by time; Alexander Skwar --=20 How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http

Re: LAST_INSERT_ID returning 3 rows?

was? You can't. last_insert_id() will tell you the last_insert_id from the current session/connection. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die

Re: time and date

old value. Not doing this will set it to the then current time. Or add a datetime column and set it to the current time when INSERT'ing with "INSERT INTO TBL SET DatetimeCol = NOW()" Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english)

Re: File types allowed to store in MySQL

On 11.04.2001 10:41:05 Jamaludin Azilawati-F1159Z wrote: .doc and .bmp files can be stored but when retrieved , files get corrupted . Any idea how I can solve this? Uhm, did you escape embedded NULLs in the file? Did you byte compare the files you've stored and retrieved to see if they

Re: swinstall_HPUX10.20

On 06.04.2001 11:46:53 vblkuer wrote: Rckmeldung bitte an [EMAIL PROTECTED] Nein, hier gefragt - hier die Antwort!! Zumal so eine Antwort bestimmt auch andere interessiert - mich zum Beispiel! - Before posting, please

Re: fastest queries

On 04.04.2001 16:42:28 ?iso-8859-1?Q?Ren=E9_Tegel?= wrote: not for speed, but i defitively prefer your second query. Reason for this is simple: you name the field you want to insert. Yes, you are right. But I prefer a third way altogether: INSERT INTO Tbl SET Field=42; The reason for

Re: Storing pictures in mySQL

On 05.04.2001 04:23:55 Taing Nguon wrote: I am not sure what you explained. You mean that place PATH/filename.jpg to picture field. isn't it? If yes, it is just a text. How can we explore that picture thru web browser such as IE or Netscape? Thanks for the answer Well, he said that he has

Antwort: Storing pictures in mySQL

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.

Re: Antwort: Storing pictures in mySQL

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: Problem with Dates...

On 04.04.2001 08:49:07 Nanjunda BM Prasad wrote: i have set the system format of date as DD/MM/. Is there any additional things to do ? pls. send me the solution. use date_format to return the date in any format you want.

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

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 incorrect as

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

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: Warning: Got signal 14 from thread X

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

Re: PHP query

So sprach Kelly Alexander Zia am Sat, Mar 17, 2001 at 11:08:04AM -0700: Warning: Supplied argument is not a valid MySQL result resource in c:\phpweb/searchresults1.php on line 462 The database connection is somehow broken. Alexander Skwar -- How to quote: http://learn.to/quote (german

Antwort: Webmin

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, please

Antwort: Re: Antwort: Webmin

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)

Antwort: Error msg saying what?

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: Configure problems

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:

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

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

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:

Antwort: Bug in 3.23.33? Or design decision?

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:

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

choice. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die guenstige Art an Linux Distributionen zu kommen Uptime: 15 hours 18 minutes

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

tion still is. Why are auto_increment columns are not supported True. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die guenstige Art an Linux Distributionen

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

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

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

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: [auto_increment]

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: AW: version 3.23.29a-1

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: auto_increments

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 your

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 in a variable. Is it possible ??? What's DUAL? - Before posting, please check:

Antwort: boolean type

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: 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 that your MySQL installation creates the socket right there? If I'm not

Antwort: Transactions...

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: Error 1052:Query problem

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 USC

Storing and retireving images (was: Re: storage and retrieval of images)

or " and what not all else. This will become a hassle which I avoid by base64 encoding the data. I also have to store the image type (PNG, JPEG, GIF...), so that it is completely clear what kind of image I'm storing. I don't know if the browser would display

Antwort: Re: storage and retrieval of images

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: RE: how to backup mySQL database?

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

Antwort: Re: how to backup mySQL database?

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 on

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

On 28.02.2001 13:13:05 Bob Hall wrote: Og nu da jeg s nrmere p din email adresse, er du selvflgelig velkommen til at sprge p dansk... ;-) Det er alltid hyggelig se p andre sprg p internettet, men hvis du skriver p dansk, s skal de aller fleste taper sjansen lre om ADO og MySQL. Bitte

Antwort: AW: version 3.23.29a-1

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

Antwort: ?

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

Antwort: Security Question

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: ?

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 field

Antwort: LOOKING FOR A FRONTEND FOR MYSQL

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

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

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: MySQL question to ask

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: Name

Antwort: ReisserFS

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:

Antwort: RE: Suggestion For List Management

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! - Before

Antwort: Re: Antwort: ReisserFS

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*

Antwort: Saving pictures in MySql

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

Antwort: Changing field types?

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 to

Antwort: web based admin?

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

Antwort: storing files in database

On 16.02.2001 10:05:54 I.SivaramaKrishnan wrote: Hi all, Basically I have a requirement where I have to store xml files in the database. The table that I visualised for the purpose will contain two columns, one being the key (varchar) and the other for the xml file. What data type should

Antwort: [Fwd: storing files in database]

On 16.02.2001 10:08:26 I.SivaramaKrishnan wrote: NOTE: Since iam not a member of this group, please reply by cc`ing to my mail id. That's a behavior I never quite understood - you come to list seeking for advice. Fine. Next you say that you do not care at all about the list. Geez, if you

Antwort: difference of two datetime values

On 16.02.2001 13:27:58 Vyacheslav Chukin wrote: Please, tell me, how could I determine, which one of two datetime values is greater? Date1 Date2 In other words, how could I determine, is stored on db datetime value in future or past? Past: DbDateTime NOW() Present: DbDateTime =

Antwort: Re: How many tables in a database?

On 09.02.2001 12:01:01 Kissandrakis S. George wrote: I have 6500 tables under one database there is no problem Pardon me, but how do you keep track of that many tables? I mean, I've a hard time with 10 or 20 tables - but 6500???

Antwort: [win32,mysql v. 3.23.32]Now() function and ERROR in enum

On 08.02.2001 15:09:47 Christian Ribeaud wrote: would like that the table put automatically the today's date for every INPUT as default value. What is wrong? Uhm, why don't you use a timestamp column type then? Okay, it will also save the time, but it's easy to extract only the date, if

Antwort: Boolean Datatype

On 06.02.2001 18:09:36 russ wrote: Im new to the list, apologies if this has been asked before. Im developing a backend for a personal site (www.russd.com) using mySQL. The site is hosted on NT4 and has myODBC installed, I have some database access working, but I'm looking for a way to

  1   2   >