[George]

yeah.

Well, i guess i will have to be content with %.% in the end. Still seems weird that mysql doesnt resolve the hostname…

Many thanks

[George]

Thanks for the fast reply.

My isp has a /16 range (65000 hosts). Feels kind of …wide.

I tried to put in both the dyndns host and even a local host defined in /etc/hosts… doesnt appear to work.

Fresh out of ideas.

Best regards.

[George]

yeah, i would have probably tried something like this with php, but thats just because i didnt know you can do it in mysql 🙂

is it faster to do it directly in mysql ?

[George]

ZOMG WOW, cool queryes 😀

I'm trying it on right now ! I got many questions, why is there the delete statement ?

It works only with limit 1 so thats why I need to make a loop ?

What does the delimiter ..delimit ? (never used stored procedures either 😀 but theres a first for everything)

brb with more questions 😀

later edit: heh, so i think i understand that the limit 1 trick is to match the v2 with the id (because selecting only the first row will match), right?

it gave me an error, so i removed the last DELIMITER and then no error. but i dont know why I did that.

[George]

Yes, the goal is to use something like this in production [sometime…]. I use .csv because the office workers use MS excel to work with data so .csv files are easily available. The trick is to get the mysql tables updated from the csv files 🙂

Its not urgent to get it done because the updates are not yet as frequent as they should be, but its on the todo list, sooner or later.

Seems hard to believe that mysql server would actually crash from something like this 😀

[George]

there is one thing that I might have neglected to say 😀

in the real/production world the .csv file would be a lot smaller (rows number) than the products table (which might be huge[the source of the “problem”])

[George]

the products_id column is the primary key in the products table and it exists in the csv file also.

I will try to understand the steps you so kindly presented…. atm i confess i dont comprehend the logic

This situation is the case of people needing to update some prices/whatever within large tables. exporting and importing even chunks of the table has proven to be a tiresome task. Apart from that, people usually work in excel/OOo for such jobs.

I am thinking that a php script is prolly the best solution………

if I wasted your time Im sorry

[George]

mysqld version 5.0.27, can't update it because it is the production server, I can try locally on windows with XAMPP which has 5.0.45

heh, then its too complicated for me :D, dunno what ms text driver is anywayz :>

I'm curious if other people would find such a script useful, but im not good in php and dont have time either.

[George]

heh, what were the chances of me being a n00b 😀 .. , well, thanks for making me find out that views exist…. 😀

“Suppose” I have a table with products resembling:

product_id product_option1 product_option2 blabla1 …. PRICE blablaY ..

The objective is to only import a csv table containing 2 columns: product_id and PRICE

while the rest of the products table be left untouched.

In my first daring attempt to use views i did:

create VIEW bobview as SELECT products_id, price from PRODUCTSTABLE

and then:

load data local infile 'C:\Documents and Settings\Administrator\Desktop\test2.csv'

replace into table `database`.`bobview`

fields terminated by '#' optionally enclosed by '”' lines terminated by 'rn'

(`products_id`, `PRICE`)

problem is: I get a mysql timeout 🙁 Error Code : 2013 Lost connection to MySQL server during query

Is the syntax replace into table correct ?

Anyway, thanks for the help, you definetely have better things to do.

[George]

Hmm its weird, on some tables it seems to be ok.

After I will dig more I will come back with more info. Dont want to waste your precious time that could be otherwise spent coding.

[Author]

Posts