fenway

What is "it" in "it displays"?

OK... now show me the EXPLAIN output that I originally asked for...

Well, it looks like you have the same number of fields as columns, though I'd be explicit about it. Did you try \r\n?

Does CHECK TABLES give the same thing? Are you using a single tablespace?

OK... now show us your table layout... I see lots of potential problems already.

Post the first 10 lines of your file -- you wont "see" \r, it's a carriage return, and it might be CR/LF if it's from a windows box.

What syntax error do yo uget?

A few things... tinyint is way too small for a UID, go with INT UNSIGNED; also, date is a reserved keyword, switch it to something like last_voted_on. That being said, I'm not sure how you mean... you can use the PERIOD in mysql to figure out which YYMM you're talking abuot.

Yikes... sounds like you should be joining all three in a single sql statement...

I prefer INT UNSIGNED for my UIDs.

INSERT... ON DUPLICATE KEY UPDATE... is the way to go.

This is the standard group-wise maximum issue... the only meaningful columns are the ones you group by... if you want anything else, you'll have to join the table back to itself using (id_cart, and min_qty) equal to the values you get back.

Or use a UNIQUE index if possible.

Why not just delete the dupes?

You need to wrap your subquery in parens: (ifnull((select x.nilai from tr_spek_property x where x.id_property=a.id and x.id_spek=4),'-'))

Why not just write it out originally? If it's hasn't been too long, it might still be cached when you run SELECT... INTO OUTFILE.

Could you post the sample data pertaining to these 4?

You have plenty of experts right here.

I've never heard of such an option.

1. Hopefully you didn't index the columns twice 2. You should use UNSIGNED INT, drop the display width. You can use a fulltext index across multiple columns for MyISAM tables. VARCHAR is much better than TEXT, especially in 5.0+, where you can use up to 65K. Lastly, have you used the slow query log to locate the guilty queries? If so, post their eXPLAIN output.

If this form is online without a CAPTCHA, you get easily get bots.

The whole point is NOT to rely on PHP, because otherwise this operation isn't atomic. The "KEY" is a unique key.

What does that mean?

That number after your INT column declaration is NOT related to the size of the data type, rather it's display width (which is meaningless). INT can only hold numbers up to ~2 billion (~4 billion if unsigned), which in too small for "12108923001", hence it's being truncated to it's max. value (~2 billion -> 2147483647 ). SHOW WARNINGS is a separate statement, not part of SELECT. Issue it after your query: $w_q = mysql_query( "SHOW WARNINGS" ); if( mysql_num_rows( $w_q) > 0 ) { while( $warning = mysql_fetch_assoc( $w_q ) ) { echo $warning['Level']."(".$warning['Code'].") - ".$warning['Message']."<BR>"; } }

A competition is only "fun" if it's run properly and there are some objective criteria based upon which a winner is selected... in the past, these judges were the mods/admins. It would be difficult to have random members judging, unless there was a pre-selected panel (maybe Gurus/PFRs). Either way, the point is that it takes time & effort. And for those of us with real-life responsiblities, it's simply not always feasible to take on too many extras hours of forum work above that which we already have. I doubt that many others would echo this sentiment. The purpose of this thread was to announce the new Guru status, not to have it up for debate. As always, members are welcome to give their opinions & suggestions, but the decision to remove post-based ranks and replace it with a designation has been made, and is not up for debate at this point. The new designations were simply designed to make it easier to rely on someone's experience and expertise, nothing more. This was not taking a shot at the other members, who contribute in a positive fashion every hour of every day. Besides, the true spirit of a community is to contribute to the greater good -- if you need kudos, 26 stars or an arbitrary title to motivate you, that's not really in the spirit of community either. There's nothing wrong with being rewarded, but it's not a reward if you're expecting it. Just my $0.02 -- and FWIW, I speak for myself, not the entire mod team (unless they happen to agree).