Thanks Joe,
Its really intersteing ..
joe [EMAIL PROTECTED] wrote:
Hope this helps
Data is stored in the RANGE partition that the partition key falls into
regardless if its an insert or update.
One of the benefit of this is partition pruning. By specifing the
partitioned
Unfortunately, we'll have to cancel today's MySQL University session
because the presenter is sick. It will be postponed to
* December 20 *
Please register for this session by filling in your name on the session
Wiki page that you can find here:
http://forge.mysql.com/wiki/EC2
Registering is
Folks
How can one conditionally drop an index in MySQL?
Googling shows that the drop index does not support an if exists qualifier - apparently a bug
has been raised but as far as I know its not fixed yet.
Does anyone know of a work-around?
TIA - Adam
--
MySQL General Mailing List
For
Hi all,
i need to use Eclipse(java SDK) to connect to MYSQL DB,
i write the following code for connection, but when i run it no thing
happen, no output appear, when i debug it, i found that the debuger was
stopped @ the line
conn=DriverManager.getConnection(connectionURL,Eman,Eman);
i asked this question before, but when i tried what D.Vin suggested, i got
an error.
mysql version is 4.1.12
i tried:
CREATE TABLE tbl_spdate(
spdate_ID int NOT NULL PRIMARY KEY AUTO_INCREMENT ,
spdate_date date NOT NULL ,
spdate_notes varchar( 100 ) ,
spdate_created timestamp default 0,
Your missing your data type for the spdate_updated attribute
CREATE TABLE tbl_spdate(
spdate_ID int NOT NULL PRIMARY KEY AUTO_INCREMENT , spdate_date date NOT
NULL , spdate_notes varchar( 100 ) , spdate_created timestamp default 0,
spdate_updated timestamp default CURRENT_TIMESTAMP ON UPDATE
I think you are missing the data type for spdate_updated.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
-Original Message-
On Nov 28, 2007 11:18 PM, B. Keith Murphy [EMAIL PROTECTED] wrote:
The reason I asked about version is that it looks like there is problem
replcating a load data infile command from some versions of 4.x to 5.x
slaves.
Master and Slaves are 5.x. Hopefully I've figured out the issue.
When the