Re: SQL and productivity

Hi, actually it depends on table type. Since you said that it will be temp table then I guess it will be MyISAM table. In this case it is better to use 2 way: 2-nd case: I create table, filling data and then create indexes? But if you will create InnoDB temp table that (according to Heikki

Re: index change moving files to other computer?

Alan, Now I'd love to know why I can't upgrade :) You can upgrade to version 4.0.17 ;) It seems you hit the bug that was introduced in 4.0.16, and fixed in 4.0.17. Look at this: http://www.mysql.com/doc/en/News-4.0.17.html Fixed optimizer bug, introduced in 4.0.16, when REF access plan was

Re: max key length 500 in myisam index

Adam, I've got to create a table that has the following: CREATE TABLE access ( query VARCHAR(255) NOT NULL, INDEX (query) ); and mysql is telling that the max bytes allowed is 500 for key length. The docs say I can change this by recompiling, which I would like to avoid having

Re: Max

Thank you for correction. You are absolutly right! Best regards, Mikhail. - Original Message - From: Brian Mansell [EMAIL PROTECTED] To: Mikhail Entaltsev [EMAIL PROTECTED] Cc: A Z [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, May 12, 2004 10:11 AM Subject: Re: Max Just

MySQL documentation

Hi, I have found that messages a.. Non-standard behavior of UNION statements has changed to the standard ones. So far, a table name in the ORDER BY clause was tolerated. From now on a proper error message is issued (Bug #3064). a.. Added max_insert_delayed_threads system variable as a synonym

surprise from mysql

Hi, Today I was surprised by MySQL... :) I have a table like create table MyTable (a int default 0 not null, b date); insert into MyTable (a, b) values (1, null), (1, null), (1, null); And today morning I executed update query: update MyTable set a = 0 and b = now() where a = 1; After that I

Re: Problem in a very simple SQL statement

Missed FROM clause... ;) Best regards, Mikhail. - Original Message - From: Mário Gamito [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, March 11, 2005 1:49 PM Subject: Problem in a very simple SQL statement Hi, Why do i get an error on this statement: select

Re: why NOT NULL in PRIMARY key??

Jigal, create table YourTable ( id INT(11), name VARCHAR(32), value INT(11), PRIMARY KEY(id,name,value) ) let's assume that PRIMARY KEY works like you want (accept NULLs) and we have a row in your table: (id,name,value) = (1,NULL,12) Then you insert a new row: insert into YourTable

Re: Date validation using mysql

Hi Anoop, In order to validate a date I am using next query: select date_format(date_sub(date_add('yourdate', interval 1 day), interval 1 day),'%Y%m%d') = date_format('yourdate','%Y%m%d'); It will give you 1 if date is valid. Best regards, Mikhail. - Original Message - From: Anoop

<    1   2