Re: Re: ER Program
- 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 filter. To bypass the filter you must include > one of the following words in your message: > > 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. Just typing the word MySQL once will be sufficient, for example. > > You have written the following: > > Look out for the Czech Program Case Studio. > > Regards > Bernhard > > - Original Message -=20 > From: "Ricardo Striquer Soares" <[EMAIL PROTECTED]> > To: "Listas (En) - MySQL" <[EMAIL PROTECTED]> > Sent: Thursday, March 21, 2002 1:21 PM > Subject: ER Program > > > > i am looking for a ER Design Freeware tool, i'd like to konw if does > > someone here knows about something like that, the tool name and, > > if possible, the url for download. > >=20 > > - 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 4.0 updated?
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 PROTECTED]> Sent: Friday, November 09, 2001 1:13 AM Subject: Re: MySQL 4.0 updated? > When a new version is available it will have a new version number. The > current version is 4.0.0 but there will almost certainly be a 4.0.1 > soon. If you look at the change history in the documentation, there have > already been changes put into 4.0.0. > - 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: Yes or No
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: Tuesday, October 02, 2001 11:23 AM Subject: Yes or No > If I wanted to define a table to have a cloumn which is either yes or no for > example. Would it be better to use a single char (0 or 1), or can I use an > enum (I find them more friendly ;)). > > Could you offer some advice? > - 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
PROCEDURE ANALYSE
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,String3,String4,String5,String6,... to 191) Why doesnt it simply (intelligently in that case) advise to take varchar(50)??? Best regards Bernhard - 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
Add Character to Output
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 - 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
MySQL and CharSets
Hi, I import a CSV file into MySQL using LOAD DATA INFILE. That's no problem. The problem is the textfile contains German umlauts. When I query the table with MySQL-program on the console (SQL monitor) it even works fine. But when I output in PHP it only shows the correct characters if I 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 - 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 or MS SQL?
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: Wednesday, July 18, 2001 7:51 PM Subject: MySQL or MS SQL? > I'm currently writing proposals for a customer who want to hire our little > programming team for creating corporate information system, wich includes > huge database with number of records between 1-10 millions (incl. blobs - > pictures). Expected database size is tens of Gb. > > There is idea of using MS SQL Server for some reasons, on other hand we have > big experience with MySQL (but with smaller databases). > So I'm very interested to hear advise, especially from people who had > experience with both SQL servers - which SQL Server is preferable in such > situation. - 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: Re: NOT IN
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]>; <[EMAIL PROTECTED]> Sent: Monday, July 16, 2001 10:57 AM Subject: Re: NOT IN > > here the script in php in eine classe eingebaut. > - 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: LOAD DATA INFILE
Hi, it seems to me I have to do something like this. It originally was my goal to only use SQL but this does not seem to be possible. Or do you think it's possible to reformat the string using left(), mid() and right() functions in MySQL and put it in a date-field? Best regards and thanks 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 convert dates in PHP before putting them into db: > - 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: LOAD DATA INFILE
Hi, thanks for your answer. You never have problems since youalways use the date format in the standard way, no european exception ;-) mmhhh... It's hard to make the company administering the original data base change the export format. So I'll have to import dates as strings and 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: <[EMAIL PROTECTED]> Sent: Thursday, July 05, 2001 12:23 PM Subject: Re: LOAD DATA INFILE > From my experience, if you want to import data into a date field, you have to make >sure that the date format in your csv file conforms to a date format required by >MySQL. This part is covered in MySQL documentation. So, your 20.12.1999 date >should become 2001-12-20 and so on. > > P.S. Don't forget to specify "TERMINATED BY ','" while using LOAD DATA INFILE. I >use this feature VERY often and never had any trouble.. :-) > > Bernhard Doebler wrote: > > > 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 imports as many records as lines are given in the file to >import but each date is zero (NULL). Is there a possibility to import it that >"simple" way rather to import it as text in one table and export it using date >conversion-functions in another table? > > - 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
LOAD DATA INFILE
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 imports as many records as lines are given in the file to import but each date is zero (NULL). Is there a possibility to import it that "simple" way rather to import it as text in one table and export it using date conversion-functions in another table? Best Regards Bernhard Dobler - 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