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

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 ex

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 lo

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: Sent: Saturday, August 26, 2006 9:03 PM Subject: IP Address Function? Hi, I need to make *allot* of queries fr

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 eno

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 tabl

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 Fo

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 galleries

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) wil

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

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 firs

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 beh

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 database_name table_name.txt Tablename.txt would be your datafile with the records. The filename must match the name of the t

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

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. http://ideas.live.com/programpage.as

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

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 in

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 | +++--+-+-+---+ | condition

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 will

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 h

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 unu

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 DELE

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

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 condit