fenway

You deleted the entire table, but you don't want to empty it? What does that mean? TRUNCATE deletes and resets the counter properly.

Really, the fourth one? What does that represent?

I think that if OPs don't adhere to the rules, they won't get any responses (or shouldn't) -- then they may be "inspired".

If you really want to empty a table, use TRUNCATE, and you won't have this problem.

You'll have to extra the hour from the datetime with DATE_FORMAT().

Use a column alias.

Just space and speed on insert/update.

Where are the quotes? With '$input', you should still see them.

The 4th row? The most recent?

Why would there be two entries? You'll need to limit this either in the join

How do you mean?

Why can't you just add the where clause the the posted code?

Variable is variable... it will take up as much as it needs...

Maatkit has excellent tools like this.

What ! ??? ??? I don't know what I was smoking when I replied... `node_status_type` isn't even a column, so that question doesnt' really make any sense. While the multi-column index would represent all three columns, it's not a simple concaternation... and even if it was, you still couldn't reference it that way. Moreover, why would you want to!?!? Thanks for setting me straight, Barand. I thought the first select was of the first of the columns, and read "or" rather than "instead". My bad.

And what you posted above is the error log? Did you comment out skip-innodb?

Yes, that the problem..no varchar, use a datetime field.

You mean the command-line interface? Check with root and see what permsissions you have from which hosts.

That's right... but if you search for type without status, it won't be indexed. edit: didn't actually read the previous post

Do you have any existing tables? is this a fresh install?

Describe exactly what you're trying to describe.

That means the grants table isn't correct... or the password is wrong.

What do you have so far?

I really hope you didn't think the echo would... it just text to the screen.

This will work: INSERT INTO Table2 (userid,user_email) select userid, email from Table1 where email='$email'