Re: Re: ER Program

2002-03-21 Thread Bernhard Doebler
- Original Message - From: <[EMAIL PROTECTED]> To: "Bernhard Doebler" <[EMAIL PROTECTED]> Sent: Thursday, March 21, 2002 1:58 PM Subject: Re: Re: ER Program > Your message cannot be posted because it appears to be either spam or > simply off topic to our

Re: MySQL 4.0 updated?

2001-11-09 Thread Bernhard Doebler
Hi, I think MySQL 4.0.0 is in it's alpha state. Wouldn't it be more right to get a 4.0.0 beta and several release candidates than a 4.0.1 version? Best regards Bernhard - Original Message - From: "Mike Wexler" <[EMAIL PROTECTED]> To: "Mark Maunder" <[EMAIL PROTECTED]> Cc: <[EMAIL PRO

Re: Yes or No

2001-10-02 Thread Bernhard Doebler
Hi, so far I know is MySQL able to handle Enums in a very efficient way. So I'd advise you to use Enums. Best regrads Bernhard - Original Message - From: "Jordan Elver" <[EMAIL PROTECTED]> To: "MySQL Mailing List" <[EMAIL PROTECTED]>; "PHP DB Mailing List" <[EMAIL PROTECTED]> Sent: T

PROCEDURE ANALYSE

2001-08-10 Thread Bernhard Doebler
Hi, I try to optimize my tables. To see possible "errors" I use SELECT statements with PROCEDURE ANALYSE. I have a table that holds unique strings and an index by whitch it's referenced to another table. PROCEDURE ANALYSE advises as datatype for the strings to take an enum of (String1,String2

Add Character to Output

2001-08-09 Thread Bernhard Doebler
Hi, I have a select statement and want to add a Percent sign to the output of one expression. Do I have to use Concat-function or is there another way (for only one character)? Best Regards Bernhard p.S. Since this is no spam I include the words database, MySQL, query and table

MySQL and CharSets

2001-08-03 Thread Bernhard Doebler
send header header("Content-type: text/html; charset=IBM850"); I don't want to use charset IBM850 but ISO-8859-1. How to convert the umlauts. Why are they different in both charsets? Best regards Bernhard Doebler

Re: MySQL or MS SQL?

2001-07-18 Thread Bernhard Doebler
Hi, the question is what operating system you are going to use. If your DB gets to large you will have problems not with tha database but with the filesystem. Best Regards Bernhard - Original Message - From: "Alexander Chernienko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wedn

Re: Re: NOT IN

2001-07-16 Thread Bernhard Doebler
Hi, "eingebaut" is a german word and means something like "build in" or = integrated. Best Regards Bernhard p.S. This message contains words like: database,sql,query,table - Original Message -=20 From: "Gerlinde Fischer" <[EMAIL PROTECTED]> To: "Beatriz Lapaz" <[EMAIL PROTECTED]>; <[EM

Re: LOAD DATA INFILE

2001-07-05 Thread Bernhard Doebler
ks so far Bernhard Doebler - Original Message - From: "John (*\*)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Bernhard Doebler" <[EMAIL PROTECTED]> Sent: Thursday, July 05, 2001 2:13 PM Subject: RE: LOAD DATA INFILE > This is what i wrote to

Re: LOAD DATA INFILE

2001-07-05 Thread Bernhard Doebler
nd somehow convert dates (change the order of day, month and year as well as the delimiter). Any Tip's welcome. Best Regards Bernhard - Original Message - From: "--==[bMan]==--" <[EMAIL PROTECTED]> To: "Bernhard Doebler" <[EMAIL PROTECTED]> Cc: <[EMA

LOAD DATA INFILE

2001-07-05 Thread Bernhard Doebler
Hi, I have a CSV-file exported from another database. It contains fields with dates and dates and times. A somplefied CSV-file version looks like so. 20.12.1999;21.12.1999 03:35:27 When I import it with LOAD DATA INFILE... and use fieldtypes "date" and "datetime" it sadly does not work. It i