SpamAssassin tags messages from the list as spam (was: [fwd] *****SPAM***** Re: Problems with Time field (from: dump_pj@rediffmail.com))
Hi! As you can see below, SpamAssassin tags messages from the MySQL list as spam. The main reason that this happens, is: SPAM: Hit! (3.5 points) URI: URL of page called unsubscribe That's because: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Would 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 [EMAIL PROTECTED] Date: 6 May 2002 06:09:01 - Subject: *SPAM* Re: Problems with Time field To: [EMAIL PROTECTED] Envelope-to: [EMAIL PROTECTED] Delivery-date: Mon, 06 May 2002 01:17:24 -0500 Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) List-ID: mysql.mysql.com List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] List-Subscribe: mailto:[EMAIL PROTECTED] Reply-To: p j j [EMAIL PROTECTED] X-Spam-Status: Yes, hits=5.0 required=4.9 tests=CLICK_BELOW,UNSUB_PAGE version=2.20 X-Spam-Flag: YES X-Spam-Level: * X-Spam-Checker-Version: SpamAssassin 2.20 (devel $Id: SpamAssassin.pm,v 1.77 2002/04/06 19:28:30 hughescr Exp $) SPAM: Start SpamAssassin results -- SPAM: This mail is probably spam. The original message has been altered SPAM: so you can recognise or block similar unwanted mail in future. SPAM: See http://spamassassin.org/tag/ for more details. SPAM: SPAM: Content analysis details: (5 hits, 4.9 required) SPAM: Hit! (1.5 points) BODY: Asks you to click below SPAM: Hit! (3.5 points) URI: URL of page called unsubscribe SPAM: SPAM: End of SpamAssassin results - i got an error msg. that this was not posted... hence i am doing it once more Praveen On Mon, 06 May 2002 p j j wrote : hi all, I am using mysql on Win98 platoform. Am facing problems using the Time field in SQL queries being executed from a VB program. Would it be possible for someone to help me out with this At mysql prompt 1. CREATE TABLE TEST(field Time) success 2. INSERT INTO TEST(field) VALUES ('11:00:00')-- success 3. SELECT * FROMTEST --- success 11:00:00 But from a VB program - the first two queries get executed successfully ; the values were checked from mysql prompt has been entered successfully But the 3rd query (SELECT) when executed from the VB program returns a result set of Null. kindly help Praveen _ Click below to visit monsterindia.com and review jobs in India or Abroad http://monsterindia.rediff.com/jobs - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Click below to visit monsterindia.com and review jobs in India or Abroad http://monsterindia.rediff.com/jobs - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - End forwarded message - 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 Uptime: 16 hours 19 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Date and Mysql...
»Chuck PUP Payne« sagte am 2002-04-10 um 10:27:19 -0400 : going 9, 8, 5, 10 on the dates. Here is the SQL statement I am using... That's because your DATE which you've made with DATE_FORMAT is treated as string. To fix it, I'd write: SELECT DATE_FORMAT(DATE, '%M %D, %Y') AS DATE, Title, Links, Summary FROM news WHERE TO_DAYS(NOW()) - TO_DAYS(DATE) =5 ORDER BY DATE DESC SELECT DATE_FORMAT(DATE, '%M %D, %Y') AS DATE_DSP, DATE, Title, Links, Summary FROM news WHERE TO_DAYS(NOW()) - TO_DAYS(DATE) =5 ORDER BY DATE DESC This way, you 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 PROTECTED] iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 21 hours 52 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [SECURITY] How do these blank passwords get into mysql.user?
»Philip Mak« sagte am 2002-02-19 um 10:25:38 -0500 : One thing's been bothering me for a while: When I create a user and database in MySQL, the user always ends up with an extra entry with host='%' and password=''. How is this happening? This is how I create a new database and user: mysql create database xxx; Query OK, 1 row affected (0.01 sec) mysql insert into user set host='localhost', user='xxx', password=password('yyy'); Here you set that the user xxx has the password 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 -- 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 Uptime: 6 days 9 hours 56 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 (english) Homepage: http://www.iso-top.de | Jabber: [EMAIL PROTECTED] iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 9 days 20 hours 11 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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://www.iso-top.de | Jabber: [EMAIL PROTECTED] iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 10 days 15 hours 47 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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: [EMAIL PROTECTED] iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 9 days 8 hours 53 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: letter 'O' with umlaut not equivalent to regular 'O'?
So sprach »Shannon Kendrick« am 2001-12-21 um 14:24:31 -0800 : Try setting the column to binary, that what worked for me. Uhm, isn't that another bug in this case? I'm too lazy to check the manual right now, but I think it says that the only difference between a BINARY 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] iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 5 days 6 hours 29 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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.6x.to (english) Homepage: http://www.iso-top.de | Jabber: [EMAIL PROTECTED] iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 5 days 14 hours 49 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: att.beready.com tech support has noticed something wrong with one of the downloads.
So sprach »Erin Lilly« am 2001-09-24 um 14:53:27 -0500 : After working with me on a project, att.beready.com tech support has noticed something wrong with one of the downloads, they have downloaded the mysql-3.23.40-pc-linux-gnu-i686.tar.gz Any particular reason you're trying to setup such an old version? I downloaded http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.42-pc-linux-gnu-i686.tar.gz which transfered me to sunsite.dk and extracting this works fine. However, I also downloaded ftp://ftp.mysql.com/Old-Versions/mysql-3.23.40-pc-linux-gnu-i686.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: 1 day 10 hours 17 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Oops... I think I deleted mysql.sock - WHAT CAN I DO?
So sprach »Felipe Baytelman« am 2001-09-19 um 10:32:14 -0400 : Oops... I think I deleted mysql.sock - WHAT CAN I DO? Become root, and do: mksock /var/lib/mysql/mysql.sock chmod 777 /var/lib/mysql/mysql.sock chown user.group /var/lib/mysql/mysql.sock replace user and group by the user/group 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 53 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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/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: 4 hours 3 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 14 hours 27 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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://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 days 5 hours 3 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[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) 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 8 hours 30 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 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 7 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Telnet
So sprach »tj marlin« am 2001-07-28 um 13:44:03 -0700 : There are secure telnet packages. one for windows is SecureCRT. see www.vandyke.com That's a contradiction in itself. Telnet never can be secure, as it transmits all the data in clear text. It's very easy to sniff sensitive 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 Uptime: 5 hours 8 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Best Operating System
So sprach »Jeremy Zawodny« am 2001-07-28 um 19:28:04 -0700 : Have you looked at Debian unstable? It uses the newer 2.4 kernels and, despite its name, it rather good. You're kidding, aren't you? You cannot honestly suggest Unstable for a prodction server! Well, Testing 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 Distributionen zu kommen Uptime: 5 hours 15 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql and credit cards
So sprach »Fletcher Sandbeck« am 2001-07-25 um 15:08:48 -0700 : I would counter that symmetric encryption is reasonably easy to implement and provides a modicum of security, so why not go ahead and do it. Just don't be fooled that a determined individual won't be able to defeat your encryption. If the goal is to provide protection in a use case like you just layed out, then yes, it's what I'd also recommend. But in this case, even MySQL's builtin ENCRYPT() function is good enough. No need to worry about highly complex/secure methods. 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 - Die günstige Art an Linux Distributionen zu kommen Uptime: 3 days 17 hours 28 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[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://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: 3 days 17 hours 34 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[fwd] Re: mysql and credit cards (from: ASkwar@DigitalProjects.com)
So sprach »William R. Mussatto« am 2001-07-25 um 23:01:49 -0700 : But what happens when the customer returns the product? You no longer have the cC to do a chargeback Have him enter it again. Explain that this is done to increase the security and he may be fine. If not - well 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ünstige Art an Linux Distributionen zu kommen Uptime: 3 days 17 hours 32 minutes - End forwarded message - 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: 3 days 17 hours 35 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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://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: 3 days 17 hours 40 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[fwd] Returned mail: Host unknown (Name server: mailserv: host not found) (from: MAILER-DAEMON@host2.webprovider.net)
Hi! Could someone please do anything about this? - Forwarded message from Mail Delivery Subsystem [EMAIL PROTECTED] - From: [EMAIL PROTECTED] (Mail Delivery Subsystem) Date: Thu, 26 Jul 2001 19:06:21 +0200 (CEST) Subject: Returned mail: Host unknown (Name server: mailserv: host not found) To: [EMAIL PROTECTED] Envelope-to: [EMAIL PROTECTED] Delivery-date: Thu, 26 Jul 2001 13:05:12 -0400 Auto-Submitted: auto-generated (failure) The original message was received at Thu, 26 Jul 2001 19:06:18 +0200 (CEST) from handi6-212-144-247-017.arcor-ip.net [212.144.247.17] - The following addresses had permanent fatal errors - alex@mailserv - Transcript of session follows - 550 alex@mailserv... Host unknown (Name server: mailserv: host not found) - Original message follows - Return-Path: [EMAIL PROTECTED] Received: from newald.homeip.net (handi6-212-144-247-017.arcor-ip.net [212.144.247.17]) by host2.webprovider.net (8.8.5) id TAA16097; Thu, 26 Jul 2001 19:06:18 +0200 (CEST) Received: from localhost (webserv.home.net [192.168.1.50]) by newald.homeip.net (8.12.0.Beta12/8.12.0.Beta12/8.12.0.Beta12) with ESMTP id f6QH5QQA030877 for alex@mailserv; Thu, 26 Jul 2001 19:05:27 +0200 Received: from 192.41.49.97 [192.41.49.97] by localhost with POP3 (fetchmail-5.8.5) for alex@mailserv (single-drop); Thu, 26 Jul 2001 19:05:27 +0200 (CEST) Received: from web.mysql.com ([EMAIL PROTECTED] [192.58.197.162]) by host2.webprovider.net (8.8.5) id TAA15997; Thu, 26 Jul 2001 19:04:50 +0200 (CEST) Received: (qmail 21256 invoked by uid 7797); 26 Jul 2001 16:48:41 - Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) List-ID: mysql.mysql.com Precedence: bulk List-Help: mailto:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [fwd] Re: Re: mysql and credit cards (from: [EMAIL PROTECTED]) Message-ID: [EMAIL PROTECTED] Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable User-Agent: Mutt/1.3.19i X-Operating-System: An i686 Linux with Kernel v2.4.6-5mdk X-Face: nope X-Sender: [EMAIL PROTECTED] X-UIDL: dff8ef9a96c5fdc1d2c62b07679acea3 database,sql,query,table So sprach =3DBBPeter van Dijk=3DAB 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 --=20 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=FCnstige Art an Linux Distributionen zu kommen Uptime: 3 days 17 hours 34 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - End forwarded message - PS: sql filter 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: 3 days 17 hours 51 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 3 days 18 hours 6 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql and credit cards
So sprach »Alan Cox« am 2000-02-20 um 11:57:47 -0500 : Greetings: I was wondering if anyone has any ideas about the best way to store credit cards in a database ... and I'm not referring that much to the field type, but rather encrytption techniques. 'encryption'? Hmm, how about: none? If you don't need to reconstruct the cc#, md5 will be good. However, if you need to reconstruct it, nothing is safe. And that's quite simple: a) You need to get access to the MySQL server. Impossible to do from the outside if '--skip-networking' is used. b) So, only possible from the localhost. This means, there must have been a break in to the MySQL server. Once he's on the server, he can do anything he likes. He can also read the source code of your PHP/PERL pages. There the password will be stored, somewhere. Once the password has been found (which is nothing but a matter of time), your encryption is broken. BUT: If you're using something like C or any other compiled language and do not have the source code flying around and are sure that the password cannot be decrypted from the binary, any symetrical encryption will probably 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: Don't hassle with encryption: It's not worth it. 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 days 17 hours 44 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Text how many characters
So sprach »Nelson Goforth« am 2001-07-22 um 09:00:13 -0600 : According to _MySQL mSQL_, by Yarger et al (O'Reilly) the TEXT datatype holds 64KB of data. Since my math skills and understanding of character storate are, well...wretched, someone should check me on this: 64KB = 64000 bytes = 64,000 characters (@ 1 character/byte), K = 1024 in computing, not 1000 (# bytes + 3) - while for TEXT it's (# bytes + 2). Therefore if your text field consisted of 8MB a MEDIUMTEXT field would be one byte longer than a TEXT 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) 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: 3 days 18 hours 30 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqldump loses auto_increment
Hello. I've just created a table with a auto_increment column. I then did ALTER TABLE tbl AUTO_INCREMENT=4711; Now, when I insert one row into this table, it get's 4711 as the auto_increment column's value. However, dumping this table with mysqldump --opt DB tbl loses the 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 | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 13 hours 25 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: modifying table with sort/unique
So sprach »John Hunter« am 2001-07-17 um 14:42:13 -0500 : I have a table in which I want to eliminate duplicates, where I define a duplicate to be any two rows with the same values on field1 and field2 This gives me the sort I want SELECT * FROM this_table 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 günstige Art an Linux Distributionen zu kommen Uptime: 13 hours 28 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqldump loses auto_increment
So sprach »Warren van der Merwe« am 2001-07-17 um 22:31:02 +0200 : in my plain language there it is, but the pro's may give a more detailed approach. Yeah, that's sorta how I understand it as well. Also auto_increments BREAK when you manually insert a row and set the column with the auto_inc. to 0. Doing a dump will dump the 0 just fine - but using the dump to rebuild the table will set the row with the 0 to 1. In short, my experience is that if you use auto_incs you better do *NOT* touch columns with auto_inc values - especially do not modify them in a way mysql 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 hours 30 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 21 hours 49 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Using IF to select table (from part of SELECT)?
Hi! Is it possible to use IF in the FROM part of a SELECT statement? I've got three tables: Profiles: ID: int CityID: int Cities1: ID: int Name: VarChar 255 Cities2: ID: int Name: VarChar 255 Now I'd like to use Cities2 if the CityID in the table Profiles is bigger 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 (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 40 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 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 20 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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/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 18 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 6 hours 7 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 6 hours 56 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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) 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 18 hours 36 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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) 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 23 hours 47 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: which the best
So sprach PROVVISORIO am Wed, Jun 06, 2001 at 09:21:25AM +0200: MySQL based applications (and if You're thinking of web applications, go for Linux Red Hat 7.1 + MySQL 3.23.38 + Apache 1.3.19 + PHP4pl5). BTW: Mandrake 8.0 also offers these. Other than that I really like Mandrake 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 Linux Distributionen zu kommen Uptime: 1 day 23 hours 51 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP MySQL
So sprach Zak Greant am Wed, Jun 06, 2001 at 01:07:43AM -0600: Now, while you don't need to escape the HTML entities before you insert your data into the database, you will still need to add slashes to the data. While this is true, htmlentites will also take care of nasty 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://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 1 day 23 hours 53 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Values of SET columns with commas (,) are not distinguishable from multiple values
So sprach Benjamin Pflugmann am Sun, Jun 03, 2001 at 11:42:34PM +0200: Hello. Nabend! Yes, this is the documented behaviour: Oh, I must have overlooked the last sentence. Thanks for pointing it out. Regardless, this is an interesting proposal which should be considered. Only problem is, that it would break old programs which rely on using insertions like like BLONDE,TALL currently. Hmm, yes, it will break old programs which used to insert 'BLONDE\,TALL' and where clever enough to not have it clash with possible other values. Ie. programs/programmers which not allowed the three values 'BLONDE', 'TALL' and 'BLONDE,TALL' to exist in one SET column. Adding a \ before each and every returned , of one value would allow all the three column values, though. Or is there currently some workaround that I can use? Sadly, trying to escape the , when adding the column doesn't work: mysql alter table test add SetCol2 SET ('BLONDE', 'TALL', 'BLONDE\,TALL'); Query OK, 2 rows affected (0.03 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql sho show databasesshow fields from show keys fromshow tables mysql show fields from test; +-++--+-+-++ | Field | Type | Null | Key | Default | Extra || +-++--+-+-++ | ID | tinyint(3) unsigned zerofill | | PRI | NULL| auto_increment || | SetCol | set('BLONDE','TALL','BLONDE,TALL') | YES | | NULL| || | SetCol2 | set('BLONDE','TALL','BLONDE,TALL') | YES | | NULL| || +-++--+-+-++ 3 rows in set (0.00 sec) As you can see, SetCol2 contains 'BLONDE,TALL' and not 'BLONDE\,TALL'. BTW: I consider this to be an error as well... Someone please point me to where it's mentioned in the manual that I'm wrong this time :) Uh - more strangeness: mysql alter table test add SetCol3 SET ('BLONDE', 'TALL', 'BLONDE\\,TALL'); Query OK, 2 rows affected (0.01 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql show fields from test; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | | +-+--+--+-+-++ | ID | tinyint(3) unsigned zerofill | | PRI | NULL| |auto_increment | | SetCol | set('BLONDE','TALL','BLONDE,TALL') | YES | | NULL| | | | SetCol2 | set('BLONDE','TALL','BLONDE,TALL') | YES | | NULL| | | | SetCol3 | set('BLONDE','TALL','BLONDE\\,TALL') | YES | | NULL| | | +-+--+--+-+-++ 4 rows in set (0.00 sec) mysql insert into test set SetCol3 = 'BLONDE\\,TALL'; Query OK, 1 row affected (0.01 sec) mysql select * from test; +-+-+-+-+ | ID | SetCol | SetCol2 | SetCol3 | +-+-+-+-+ | 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 of a stripped escape character, than I don't understand at all why 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 an Linux Distributionen zu kommen Uptime: 9 hours 12 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: time and date
So sprach chris am Tue, Apr 02, 2002 at 08:26:01PM -0500: ^ You're quite ahead of me, timewise *G* Is there a way to store the time and date that a record was added within MySQL? I want to show the time and date on some of my records and can'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 Uptime: 0 hours 36 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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://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 hour 26 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Reformatting a DATESTAMP out of a table into a readable display date with SELECT
So sprach Scot Robnett am Sun, May 20, 2001 at 03:03:55PM -0500: Anybody out there that can tell me how this is done? Thanks! Yeah, the manual will tell you. In the section 'Date and Time functions', look for 'DATE_FORMAT'. Since you don't know where the manual 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 Uptime: 6 days 10 hours 27 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: time and date
So sprach chris am Tue, Apr 02, 2002 at 08:26:01PM -0500: Is there a way to store the time and date that a record was added within MySQL? I want to show the time and date on some of my records and can't seem to figure out an easy way to do it. Thanks! Either use a TIMESTAMP 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://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 29 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sorted select
So sprach [EMAIL PROTECTED] am Sat, May 05, 2001 at 12:30:27PM -: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. You have written the following: So sprach 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://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die g=FCnstige Art an Linux Distributionen zu kommen Uptime: 20 hours 4 minutes 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: 20 hours 8 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: LAST_INSERT_ID returning 3 rows?
So sprach Graeme B. Davis am Tue, May 01, 2001 at 01:09:15PM -0400: Ok I was thinking that you had to tell LAST_INSERT_ID the table you wanted to get the last insert id from. What if you run a web site and you have 10 tables in a database, how can you tell what the last insert id 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 iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 2 days 12 hours 3 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: time and date
So sprach chris am Tue, Apr 02, 2002 at 08:26:01PM -0500: Is there a way to store the time and date that a record was added within MySQL? I want to show the time and date on some of my records and can't seem to figure out an easy way to do it. Thanks! Either add a timestamp column to your table, and in your insert statements OMIT this column so that it will be set to the current time. But in your update statements, you've got to take care of this column, so add something like "UPDATE TBL SET TimestampCol = TimestampCol". This will set the value of the 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://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die gnstige Art an Linux Distributionen zu kommen Uptime: 23 hours 38 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 REALLY got corrupted? Also, what are the types of files that can/cannot be stored as blobs in MySQL? MySQL doesn't know a thing about files. Actually, it doesn't have any information about what it stores. It just stores data in a column. So, every kind of data can be stored in a database. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 this is, that it is very easy to change this to an UPDATE query like: UPDATE TBL SET Field=42; While you may hardly ever need to change INSERT - UPDATE, I find it nice that both those statements which do similiar tasks have the same syntax. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 his setup in such a way, that Aliases in the apache config are created automatically to point to the users dir. Next he stores, let's say "user23443/askwar.jpg" in his database. When somebody wanted to watch this picture, the browser would request "user23443/askwar.jpg" and would get it right away, as it is accessible via the filesystem. At least that's how I understood it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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. Reasons: a) The filesystem is the best binary database there is. Accessing the filesystem to retrieve binary data is possibly faster than to do it thru MySQL. b) It's more convenient to have all the data in the database instead of spreading it all over. Here's how I do b) in PHP: 1) Get the MIME type of the image. 2) Read the binary file contents and store it in a PHP variable. 3) Base64 encode the binary data, so that there is no binary anymore, but just plain ASCII data. 4) Store the image in a MEDIUMTEXT or LONGTEXT column 5) Store the MIME type When I want to retrieve and display the image, I do: 1) Retrieve the MIME type 2) Retrieve the Base64 encoded binary 3) Decode the base64 ascii to get the binary 4) Print the MIME type in the header (if we're talking about HTML, that is) 5) Print the image Code: /* BinTable contains at least three columns: ID - autoincrementing int MIME - VARCHAR( 50 ) Bin - MEDIUMTEXT */ function StoreImage( $MIME, $Binary ){ // Store the binary with the associated MIME type in a database // Returns the row id of the just inserted row $base64 = base64_encode( $Binary ); $q = "INSERT INTO BinTable ( MIME, Bin ) VALUES ("; $q .= "'" . $MIME . "'"; $q .= ", '" . $base64 . "'"; $q .= ")"; mysql_query( $q ); return( mysql_insert_id() ); } function PrintImage( $ID ){ // Retrieve the image with the assoc. ID from the BinTable table // Returns TRUE if everything was Okay; FALSE otherwise // Sideeffect: Prints the image with header to stdout $q = "SELECT MIME, Bin FROM BinTable WHERE ID = " . $ID; $rs = mysql_query( $q ); if ( mysql_num_rows( $rs ) ){ // There is something to return if( ! headers_sent() ){ // Headers have not yet been sent - we can go ahead $row = mysql_fetch_object( $rs ); $bin = base64_decode( $row-Bin ); header( "Content-Type: " . $row-MIME ); print $bin; $ret = TRUE; } else { // Headers have already been printed - cannot continue $ret = FALSE; } } else { $ret = FALSE; } return( $ret ); } // The following assumes, that there is a INPUT TYPE=FILE NAME=image in the HTML form // Futher, there also needs to be a form element where the MIME Type is specified // I assume SELECT NAME=MIMEOPTION VALUE="image/png"png/SELECT if( is_uploaded_file( $image['tmp_name'] ) ){ // The file has been uploaded - safe to store in database // Get the size in bytes of uploaded file clearstatcache(); $fs = filesize( $image['tmp_name'] ); // Read file contents into a variable $fd = fopen( $image['tmp_name'], "r" ); $file_bin = fread( $fd, $fs ); // Close the file fclose( $fd ); // Store the image in the database $img_ig = StoreImage( $MIME, $file_bin ); // And also print it if( ! PrintImage( $img_id ) ){ echo "For some reason the image could not be printed!"; } } - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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? Or are you talking about storing it in the database at all? BTW: Is your email adress correct? It got here as: [EMAIL PROTECTED] This looks strange. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 far as PHP is concerned, because: Fatal error: Call to undefined function: mysql_real_query() in data.php3 on line 210 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 connection is closed automatically when the script finishes. See http://www.php.net/manual/en/function.mysql-close.php . Quote from the manual: | Using mysql_close() isn't usually necessary, as non-persistent open | links are automatically closed at the end of the script's execution. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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) 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 hour 8 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 is no way to store *EXACTLY* -0.01 in a float. You can get close to it, but you'll never reach -0.01 - you'll either be a tiny bit above or below the value. So, when MySQL then rounds (? or truncates?) to have only 2 values after the . To come around this, you may multiply the value by hundred and convert it to an integer value. Or you check if it is (-0.01) AND 0.0001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Antwort: Re: Why Heap Tables doesn´t support auto in =?iso-8859-1?Q?crement_ colums?=
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 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Antwort: Re: Why Heap Tables doesn´t support auto increment ?colums
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 the second an unsigned int holding the ip, if the ip is first transformed from the usual dotted notation (1.2.3.4) to the "raw" number (which would be 4+3*256+2*256*256+1*256*256*256 in this case - 16909060 ). Thus would give a timestamp + integer key, which is fast to index. 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 Linux Distributionen zu kommen Uptime: 15 hours 19 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 recreating the database. Anyway... Give it a try! :) Once more: No, it won't. Again, do this, and you'll see that it will not work correctly - or rather it will work correctly, but the recreated table will have different values. Create a table with one AUTO_INCREMENT column called ID. Insert one row, like so: INSERT INTO Tbl (ID) VALUES (0) Check all the rows: SELECT ID FROM Tbl You'll see that the row's ID column is != 0. Do this to set the column to 0: UPDATE Tbl SET ID=0 WHERE ID = 1 Check all the rows: SELECT ID FROM Tbl Now the row will have the ID set to 0. Dump the table, drop the table, replay the dump. Now you'll have just one row again, but ID will be != 0, because the dump contained the statement "INSERT INTO Tbl (ID) VALUES (0)" - as I just explained, this won't work. Give it a try before you disagree again :-)) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 auto_increments was a tinyint, and the other one a mediumint. I still don't get this. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 mistaken, it may be created in /tmp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 Aus A Aus B USD * signifies no data why does the following produce an error: 1052?? SELECT DISTINCT APPL FROM Table_A, Table_B WHERE Table_A.ID=Table_B.ID AND Cnty="US" AND ID="*"; Which ID? ID from Table_A, or ID from Table_B? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Storing and retireving images (was: Re: storage and retrieval of images)
On 28.02.2001 04:57:04 ?iso-8859-1?q?Geetha=20Narayanan?= wrote: can i able to store images in database, not in Yes sure, see below. binary format but directly as image and retrieve An image is nothing but binary data, so I suppose you're just confused. Okay, here's how I do that. I "only" use PHP, so that's all I know - things will work differently in other languages, but it should still help you to get the idea about how I'm doing things! I have a table that has these fields: ID = auto_increment INT Type = ENUM('image/png', 'image/tif' ... ) Data = MEDIUMTEXT ID is the primary key. In PHP I read the image file contents into a variable. Then I base64 encode it ( with base64_encode() ), find out what type of image this is (PNG, JPEG, GIF) and store both these data in a database table. In code, it looks like this: $fp = fopen( $HTTP_POST_FILES['imgfile']['tmp_name'], "r" ); $img_bin = fread( $fp, filesize( $HTTP_POST_FILES['imgfile']['tmp_name'] ) ); fclose( $fp ); $img_b64 = base64_encode( $img_bin ); $img_type = $HTTP_POST_FILES['imgfile']['type'] ); $q = 'INSERT INTO Images (Type, Data) VALUES ("' . $img_type . '", "' . $img_b64 . '")'; mysql_query( $q ); When I want to display the image, I read the row from the database, decode the binary data with base64_decode() and get the image type I stored (PNG, JPEG, GIF). This looks like this: $q = "SELECT Type, Data FROM Images WHERE ID = 42"; $rs = mysql_query( $q ); $row = mysql_fetch_object( $rs ); $img_b64 = $row-Data; $img_bin = base64_decode( $img_64 ); $img_length = strlen( $img_bin ); $img_type = $row-Type; Next I print to stdout the header, telling the browser what kind of image is going to come ( header( "Content-Type: image/png" ); (or what not) ), like so: header( "Content-Type: " . $img_type ); header( "Content-Length: " . $img_length ); After this I simply echo the file contents, so that the browser gets the data: echo $img_bin; That's it! Why am I doing this the way I am doing it? I do not store the data in binary format in the database, so that the data keep easier managable, because base64 encoding guarantees me, that I'll only have "nice" ASCII characters in my data stream. Dumping the data, or managing it with phpMyAdmin becomes a lot easier when there's nothing but ASCII data in my experience. 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 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 the image correctly, if I don't send the correct header when printing the image. Cheers, Alexander Skwar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 this column set to 0, but to the value it would get when normally auto incrementing it. How to circumvent this? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 the mysqldump command line. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 was? Ich wrde ja gerne helfen, nur leider verstehe ich nicht, was ihr gerade gesagt habt. Es wre nett, wenn ihr entweder in Deutsch, oder vlt. doch in Englisch posten wrdet! Danke sehr! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 should be on the system according to its database. The original poster should also try to upgrade the perl RPM. Might help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 don't know for sure, but maybe MySQL can't handle the DOS directory delimeter \ when it's unescaped? So, try "C:\\text.txt" instead of "c:\text.txt". Hmm, or maybe MySQL needs Unix style delimiters? Try "c:/text.txt". - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 from table sastojci into upper query. How do I do that? SELECT rid,nazivRecepta,MATCH sastojci.nazivSastojka,nazivRecepta,uvod,nacinPripreme AGAINST ('vegetine') as relevance FROM recepti order by relevance desc And another question is how to insert date into database but in format dd.mm.. Well, *WHY* would anyone want to do this? *I* always use datetime columns and use date_format when retrieving the data from the row. Anyway, you could use a DATE column, which would store the date as '2001-02-21' if you retrieve it in "raw" format. But again, even here you can use mysql's date_format. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 create/edit/drop tables - therefore it has to be very easy to use. Hmm, phpMyAdmin maybe? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 Income Out Balance Data1 1000 700 300 Data2970 500770 SELECT Name, Income, Out, (Income - Out) AS Balance FROM Table WHERE Name IN['Data1', 'Data2']; Hmm, not to sure about the IN part - look it up *G* Uh, just saw that: Data2970 500770 How is the balance calculated? First I thought, that it is (Income - Out) - but this gives 270, and not 770? Or is it (1st (Income-Out) + 2nd (Income-Out))? But no, this would only give 570. Hmm, nevermind my SELECT statement above, it's probably wrong - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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* - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 Table (ImageType, ImageData) VALUES ( ImageTypeValue, ImageDataValue ) Retrieve: SELECT ImageType, ImageData FROM Table WHERE ID = WhatEver - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 specify a limit for the index length when you index a BLOB type. Further, you cannot specify the length of a BLOB type. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 *NOT* want to? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 I use for the second column. I always use a MEDIUMTEXT type for this, see: http://www.mysql.com/doc/C/o/Column_types.html . Although the column allows you to store 16 MB of data, it maybe that you need to start mysqld with a larger max packet size, as the default is 1 MB, which may not be enough. Further, I store the values base64 encoded in the column, so that I don't need to take care of special characters like ', " or \0. This will also increase the datasize by about 33%. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 want answers, it's *YOUR* responsibility to obtain them! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 = NOW() Future: DbDateTime NOW() Before posting, please check: http://www.mysql.com/manual.php (the manual) ^^ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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??? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 that's all your after. With a timestamp, you could either not set any value when inserting or set it to NULL which both would enter the current time (like in NOW()). Another question, 'showIt ENUM('TRUE') DEFAULT ERROR' did not work but 'showIt Sure, because your ENUM did not contain the value 'ERROR' - it's just containing 'TRUE'. ENUM('TRUE','FALSE') DEFAULT FALSE' worked fine. I would like to have something like bits or boolean values in my table. How to achieve this? Thanks for the I use a TinyINT and store a 0 for FALSE and something other than 0 (like 1, or whatever) for TRUE. That will only take 1 byte to store what you need. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 implement boolean types. Using Access/SQL server I can simple do an insert using SQL like the following (from within ASP): INSERT INTO tblMyTable (booleanField) VALUES (" myBooleanVariant ");" Okay, define booleanField to be TinyINT, or maybe ENUM('TRUE', 'FALSE'), but TinyINT would be a lot easier IMO. Then for FALSE you'd insert a 0 and for TRUE you'd insert something else. values within my ASP code to 1/0. This isn't perfect howevere as its more code, Why? Dunno about ASP but since it's from M$ it must be superior to PHP *G* and in PHP you'd simply do this: $q = "INSERT INTO tblMyTable (booleanField) VALUES ('" . ( "yes" == "no" ) . "')"; $rs = mysql_query( $q ); Now booleanField would be set to a FALSE value, or: $q = "INSERT INTO tblMyTable (booleanField) VALUES ('" . ( "answer to life, universe and everything" == "42" ) . "')"; $rs = mysql_query( $q ); This time, we'd have set your booleanField to TRUE *G* (well, sorta :]). $q = "SELECT booleanField FROM tblMyTable WHERE Something=42"; $rs = mysql_query( $q ); $row = mysql_fetch_object( $rs ); if( $row-booleanField ){( // booleanField is anything but 0, ie. it's TRUE } else { // booleanField is 0, ie. it is FALSE } In how far is this more code?? Could anyone suggest a better way of implementing this, or am I missing something? Yeah, you're missing something. In many languages there's no bool data type, basically, because something like a tinyINT handles this very well. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php