query with <> or !=
Hi, I have a strange problem happening. I have created an application on a PC with Mysql-3.23.22-beta and I have different results than on a standard Mysql-3.23.35. The main problem seems to be at the following: Say have 6 rows with a column name "actif", out of these 6 rows 3 have a NULL value in the actif column and three have the value "No" is I do select count(*) from tablename where actif != "Yes" ; or select count(*) from tablename where actif <> "Yes" ; I get the following results: - development machine: I get results = 6 - production machine: I get results = 3 Note all rows are different than "Yes", only 3 of them are actually NULL. OK so that is a fact, but I would like to know if it is just a setting I can change in the database or if I have to modify the whole program to make sure these cases don't happen. Gilles _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - 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 Dump
Hi, I would like to extract the contents of a database to use it in a ASCII format. It is a addresses database and I want to use it in Excel. I have tried Mysqldump but it gives me the CREATE and INSERT statements all the time. Any ideas? Gilles _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - 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: Datatype for comment field
I would recommend the book MySQL by Paul Dubois to anybody that want to do some seriou work on MySQL . It is a really god book with everything explained. I am not earning money by recommending it nor have any financial ties with them. I am just a satisfied customer of that book >From: [EMAIL PROTECTED] >To: "Nguyen, David M" <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Antwort: Datatype for comment field >Date: Wed, 7 Mar 2001 11:25:02 +0100 > > >On 06.03.2001 18:43:32 Nguyen, David M wrote: > > > I try to create a new table and setup a datatype for comment column that >has > > about 7000 characters long. How do I define it in Oracle? > >That's the MySQL mailing list, you know No idea how to do stuff in >Oracle. > > > > > **Here's my SQL and the error I got. > > > > SQL> create table test > > (comment varchar(7000)); > > > > ERROR ---> Character field too long > >See this? v > > >http://www.mysql.com/manual.php (the manual) > > > >It's in there how long a varchar can be. > >But before flaming starts: VarChar can take no more than 255 characters. > > > >- >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 > _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - 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