I've had no problems with MySQL RAID, and the performance is excellent
as long as you have your indices set up properly. One caveat I might add
is that MySQL RAID does not apply to index files (.MYI). If your index
files are going to grow > 4 GB, you'll need to consider alternate
filesystems anywa
Don't reference the timestamp column at all in your INSERT (or future
UPDATE) statements and the timestamp should update just fine on its own.
i.e.
INSERT INTO Owners (NameID,ProductsKey,RegNum)
VALUES ('$NameID','1','$RegNumc');
BTW, you cannot change the default for a timestamp column - it is
Perfect.
Thanks, Anvar.
--
coop
On Sun, 2001-11-25 at 22:20, Anvar Hussain K.M. wrote:
> Hi Chris,
>
> The following query should work for you.
>
> select date_sub(date_col, interval weekday(date_col) day),
> date_add(date_col, interval 6-weekday(date_col) day) from table_name
>
> Anvar.
Hey all,
I'm hoping someone can help me out with a little date/time problem I'm
having. I've got a database full of timestamps that I want to group
together based on their week. I can use the WEEK() function or
DATE_FORMAT() to convert the timestamp to a week number, but I'd rather
display the bo
Has anyone else tried to set the INSERT_METHOD for MERGE tables? It
keeps throwing a syntax error for me.
Following the docs verbatim (http://www.mysql.com/doc/M/E/MERGE.html),
here's what I get:
>>output
mysql> CREATE TABLE t1 (a INT AUTO_INCREMENT PRIMARY KEY, message
CHAR(20));
Query OK, 0 r
See below.
On Wed, 2001-11-14 at 14:40, Jason Wong wrote:
> The above can be re-written as:
>
> //En record for hvert navnedomene
> $sql = "CREATE TABLE domains (
> dNbr INTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
> dName CHAR(25) NOT NULL,
> payP
http://www.mysql.com/doc/P/r/Privilege_changes.html
"If you modify the grant tables manually (using INSERT, UPDATE, etc.),
you should execute a FLUSH PRIVILEGES statement or run mysqladmin
flush-privileges or mysqladmin reload to tell the server to reload the
grant tables. Otherwise your changes