[Q] moving database to server in new timezone

I'm, using mysqldump to dump a complete database on a server in The Netherlands and want to load the generated SQL onto a server in the USA to make an exact copy of the database. However, I have Timestamp(14) fields that are dumped as e.g. 2004101015 local time and is read as local time too

[Q] Will an index increase performance here?

Table employee: employeeNumber : int (primary key) age: int salary : float Would an index improve performance for these queries? SELECT * FROM USERS ORDER BY age DESC LIMIT 100,200 (index on age) SELECT * FROM USERS ORDER BY salary DESC LIMIT 200,300 (index on salary)

[Q] setting DATE field with default NOW value?

In a table definition, how do I get a date field to be assigned as DEFAULT the current date? I tried: dateField DATE DEFAULT CURDATE() but that gives me syntax errors Help? __ Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online.

[Q] INSERT INTO ... SELECT

Is there a limit on the number of rows that can be inserted in this way? Ie, at what point should I start worrying about out of memory errors or something similar? So, how many rows can/should be returned by the SELECT clause? __ Do you Yahoo!? Yahoo! SiteBuilder

SQL query help required

Hi, Background: I run a prediction league for soccer competitions. For every game, I want to show how many predictions were submitted per scoreline, ie. 10% said 1-0 20% said 0-1 30% said 2-3 etc. My prediction table has a predictionA and predicionB column with the submitted scores. Currently

Problem setting/activating password

Hi, I am created a user by using: GRANT ALL ON *.* TO username@% IDENTIFIED BY password I did this from the mysql command line tool, logged in as root. The command succeeds and the new user is created in the mysql.user table, but the password does not work. I can only use this new user if I use

user@% vs user@localhost question

This follows on a previous mail from me: When using GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY “password” I could not get the password authentication to kick in. Only supplying no password (empty string) succeeded. Even after doing “SET PASSWORD…” and “FLUSH PRIVILEGES”. Then I tried

RE: Problem setting/activating password

of username@% ? According to manual (section 7.34) it should be identic in behaviour: [...] The simple form user is a synonym for user@%. [...] Does it do the same? Lian P.S. Andy, sorry for posting by mistake to you. ;-| -Original Message- From: Riaan Oberholzer