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

it be possible 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" <

Re: Date and Mysql...

can display the "nicely" formated date in DATE_DSP 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 PROTECT

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

sword yyy. > mysql> grant all privileges on xxx.* to xxx; Here you insert another user but don't set a password! 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 --

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:

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

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 | Jab

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

RY VARCHAR and a VARCHAR 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]

Re: Decimal separator

So sprach »Lars G 'LG' Örne« am 2001-12-07 um 13:19:00 +0100 : > MySQL, float fields: Can I change from "." to ","? Nope, they are always stored with . in the DB. However, when SELECTing, you can easily convert using MySQLs replace() function. Alexander Skwa

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

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

tar.gz which also uncompresses 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:

[fwd] 123box.co.uk mail delivery system (from: MAILER-DAEMON@123box.co.uk)

: > >mksock /var/lib/mysql/mysql.sock >chmod 777 /var/lib/mysql/mysql.sock >chown . /var/lib/mysql/mysql.sock > >replace and by the user/group the mysql process runs >under. > >Alexander Skwar >-- >How to quote: http://learn.to/quote (germ

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 Alexande

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

ess 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 53 minu

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

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

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

Re: Licensing terms for an Intranet site

So sprach »Jay Fesco« am 2001-08-30 um 12:01:09 -0400 : > X-message-flag: Mailbox corrupt. Please upgrade your mail software. It's a "feature" of Outlook, which will interpret this header line and display the note which is in it. > database,sql,query,table Alexander S

Re: MySQL and GPL license: questions and discussion

not GPL. So, you can buy your way out of the GPL wrt. MySQL. 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 Distrib

Re: Best Operating System

ing is fine, but Unstable? 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 Distribu

Re: Telnet

sitive data from 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 U

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 -

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

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

ilto:[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: 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 --

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

l he's already 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üns

[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

Re: mysql and credit cards

ethods. It's rather security-through-obscurity 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

Re: mysql and credit cards

bly do. The last also applies, if you use a program 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:

Re: Text how many characters

version of the same field. And what is the This may 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) ht

Re: mysqldump loses auto_increment

l would not have done 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

Re: modifying table with sort/unique

e ORDER BY name, time; Untested: 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

mysqldump loses auto_increment

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

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

than 7. 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 (engl

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

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 (

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 |

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

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

Re: Can only create 127 records in a table :o(

ppose the auto_inc column is just a TINYINT 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 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

Re: PHP & MySQL

quot; characters like " 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

Re: which the best

ake a lot, I'd 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

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://qu

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

+ | 001 | BLONDE,TALL | NULL| NULL| | 002 | BLONDE,TALL | NULL| NULL| | 003 | NULL| NULL| TALL| +-+-+-+-+ 3 rows in set (0.00 sec) Now, why is for ID == 003 SetCol3 == TALL, and not 'BLONDE\\,TALL'? If it's because

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

Re: time and date

27;t seem Add 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

Re: time and date

column, which 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://q

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

is, it's online available 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

Re: Rolling back of a transaction

So sprach kuttappan am Sun, May 06, 2001 at 11:20:40PM +0530: > Is there a version of MySql for Windoze that supports BDB tables? Don't know, but you can always compile it yourself, can't you? Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6

Re: sorted select

To bypass the filter you must include > > one of the following words in your message: > > > > database,sql,query Stupid filter... Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com |

Re: sorted select

ch Adi Tofan am Sat, May 05, 2001 at 03:27:42PM +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://lear

Re: LAST_INSERT_ID returning 3 rows?

of table 6 > 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

Re: time and date

e timestamp column to the 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:

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 REA

Re: swinstall_HPUX10.20

On 06.04.2001 11:46:53 vblkuer wrote: > Rückmeldung 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: 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 ha

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 fo

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. --

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?

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.

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

Antwort: jpegs in a database

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

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 c

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 (

Re: Antwort: Webmin

at question of sunrise - could you be so kind and explain what he asked? 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

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: 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) http:

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

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: http://www.mysql.com/manual.

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: http://www.mysql.com/manual.p

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

Antwort: Datatype for comment field

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: Re: boolean type

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

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

ex. > The question 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 L

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

is also not a good 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: 1

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

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

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

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

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

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?

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?

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

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

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]

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?

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?

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

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

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?

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

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 sh

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å 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

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

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 th

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. ---

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

Further, if true binary data would be stored in the table, you'd have to escape some "characters" in the binary stream, like \0 (null character) ' or " and what not all else. This will become a hassle which I avoid by base64 encoding the dat

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 f

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

  1   2   >