Why can't I delete these records?

Hi all! Who can tell me why the following does not work...? When I do: SELECT COUNT(*) AS counter FROM table1 WHERE condition1 = 'A' AND condition2 IS NULL; it returns: +-+ | counter | +-+ | 2 | +-+ Then I do: DELETE FROM table1 WHERE condition1 = 'A' AND

Re: Why can't I delete these records?

Hi, Query OK, 0 rows affected (0.00 sec) It did not find/delete any rows - please double-check your conditions and make sure you are using the same set as for the SELECT statement. Best regards, Aleksandar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Why can't I delete these records?

Hi! I'm entering the statements exactly as listed in my message (only done a search/replace on table-name). So SELECT says there are 2 records, but then DELETE does not see those same 2 records... :-/ Is there something like a verbose/debug mode in which I can see more precise why my

Why does MySQL accept fake date?

Dear MySQL-ers, Using MySQL 4.1.20, in the function DAYOFWEEK(), why does MySQL accept a bogus date like '2006-02-30'? It says the 30th of February (yeah, right) starts on a the 5th day. I was going to use this to create a table of how many days there are in each month, but that's completely

Re: Why does MySQL accept fake date?

Hello Mark, in Versions of MySQL prior to 5.0.2 it is only checked that the year-part ranges from 1000-, the month-part from 1-12 and the day-part ranges from 1-31 within the date column. With 5.0.2 of MySQL the Dates must be legal, so 2006-02-31 is no more possible by default. You can

Re: Anyone tried solidDB for MySQL?

I've installed the beta and imported data. It took longer to import than InnoDB does so I think at least inserts are slower. I haven't benchmarked reads or anything yet. I like the idea of having MVCC instead of locks. We would benefit more from better query planning so I'm unsure whether we

Re: Why can't I delete these records?

Hello Evert, i just entered your example and had no unusal behaviour on MySQL 5.0: mysql describe table1; +++--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +++--+-+-+---+ |

RE: Why does MySQL accept fake date?

Hello Rocco, Thank you for your reply. Clear and simple. :) I couldn't upgrade the MySQL server on my production server just yet, but I upgraded the local test MySQL server on a Windoze machine. And it worked like a charm. :) I just needed to create a one-time table of how many days there are

Re: Why can't I delete these records?

I'm using MySQL 4.1.21 (on Gentoo). Should this make any difference? Regards, Evert Rocco wrote: Hello Evert, i just entered your example and had no unusal behaviour on MySQL 5.0: mysql describe table1; +++--+-+-+---+ | Field | Type

Batch Update of records

Hi I've am updating a database with about 20,000 records. What is the best way to perform these updates. Can I use batch updating ? Thanks Neil _ Be one of the first to try Windows Live Mail.

Re: Why can't I delete these records?

Hello Evert, i actually do not know and don't have access to a 4.1 Machine. What you could try is to use the alternative way of testing if a value is NULL: Maybe the behavior of IS NULL has been changed in 5.0 . DELETE FROM table1 WHERE condition1='A' AND condition2=NULL Greets Rocco Evert

Re: Batch Update of records

Hallo Neil, take a look at the utility mysqlimport which will exactly fit your needs importing those records into a database table. The basic syntax is: mysqlimport options database_name table_name.txt Tablename.txt would be your datafile with the records. The filename must match the name

Re: Why can't I delete these records?

Hi! I tried your tip, but = gives the same result as = when I execute the query... :-/ Regards, Evert Rocco wrote: Hello Evert, i actually do not know and don't have access to a 4.1 Machine. What you could try is to use the alternative way of testing if a value is NULL: Maybe the

Re: Why can't I delete these records?

Hello Evert, the = Operator can not work with NULL values , so you have to use = or IS NULL. I have no clue why its not working at your side, but i assure you that it must be a rather simply problem (typo, table definition). Are you sure your definition2-column allows NULL values in the first

Re: Why can't I delete these records?

Oops, that was just a typo in my previous reply. My script does use 'IS NULL' and not '= NULL'. I also tried '= NULL'. No luck... Evert Rocco wrote: Hello Evert, the = Operator can not work with NULL values , so you have to use = or IS NULL. I have no clue why its not working at your

displaying a sing thumbnail

I have a database of images, http://www.thethistlehouse.com/db.jpg What I want to do is select ONLY ONE image to display as a the image link for that gallery. As you can see galleries are numbered dynamcially but galleries can also be added and deleted so the galleries no's I have now (7, 8)

Re: displaying a sing thumbnail

[EMAIL PROTECTED] wrote: I have a database of images, http://www.thethistlehouse.com/db.jpg What I want to do is select ONLY ONE image to display as a the image link for that gallery. As you can see galleries are numbered dynamcially but galleries can also be added and deleted so the

feature request, optimize myisam with concurrent read only

Would like to see this, there is a TMD temp table created during an optimize is there any reason read only access cant take place during the optimize process? Update/delete/insert shouldn't, but read access should be allowed on myisam any thoughts on this? -- MySQL General Mailing List

IP Address Function?

Hi, I need to make *allot* of queries from a application dealing with IP Addresses. At the moment, I'm storing IP addresses as a VARCHAR(16). I would *like* to store them as Integers by converting the IP to it's numerical equivalent. I believe this would also save a enormous amount of

Re: IP Address Function?

Chris Knipe wrote: Hi, I need to make *allot* of queries from a application dealing with IP Addresses. At the moment, I'm storing IP addresses as a VARCHAR(16). I would *like* to store them as Integers by converting the IP to it's numerical equivalent. I believe this would also save a

Re: IP Address Function?

RTFM! Let that be a good lesson for me now :) INET_ATON() and INET_NTOA() Brilliant!!! Regards, Chris. - Original Message - From: Chris Knipe [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Saturday, August 26, 2006 9:03 PM Subject: IP Address Function? Hi, I need to make

How a VIEW is stored

I was working with my version 5 and made a couple of views which are very useful. Looking in the db I was able to see the VIEW's saved as TABLE :-) This was a surprise and not sure if this is the expected result or not. Then I did some SELECT that involved the VIEW and it does work a

Re: How a VIEW is stored

In the last episode (Aug 26), Karl Larsen said: I was working with my version 5 and made a couple of views which are very useful. Looking in the db I was able to see the VIEW's saved as TABLE :-) What command did you run to determine this? SHOW TABLES does list them but that's to be

mysqlimport csv file import problem

Hi, I download a csv file from Yahoo in this format: ABIAX 20.63 2006-08-3 ACEIX 8.78 2006-08-3 CIGAX 10.08 2006-08-3 FSCTX 22.25 2006-08-3 GGOAX