UPDATE table1 FROM table2

In MySQL 3.23, how to update one table using information from another table. update table1 set value1=t2.value2 from table1 as t inner join table2 as t1 using(pk_key) ??? or update table1 as t1 inner join table2 as t2 using(pk_key) set t1.value1=t2.value2 ??? Is it possible at all? Thank you

Migrating from DATETIME to INT

Hi, I have database in MSSQL, and all the dates are DATETIME. I would like to move it to MySQL, but using INT and UNIX timestamp. Is there direct way to import/export or i have to write a script for it? Thanx for any info :) --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus s

Query Analyzer

Are there tools for MySQL like MS SQL Query Analyzer, that can analyze and estimate effectivity of a query? Or is it possible to approximate execution plan of queries that will be run on MySQL with above mentioned utility? Thank you. --- Outgoing mail is certified Virus Free. Checked by AVG anti

RE: how to sub-select?..

nt_id=t_parent.task_id WHERE t_parent.task_id IS NULL -Original Message- From: Sergei Golubchik [mailto:[EMAIL PROTECTED]] Sent: Monday, October 22, 2001 3:52 PM To: Moshe Gurvich Cc: [EMAIL PROTECTED] Subject: Re: how to sub-select?.. Hi! On Oct 22, Moshe Gurvich wrote: > yeah, noticed

RE: how to sub-select?..

le in JOIN structure? -Original Message- From: Sergei Golubchik [mailto:[EMAIL PROTECTED]] Sent: Monday, October 22, 2001 3:01 PM To: Moshe Gurvich Cc: [EMAIL PROTECTED] Subject: Re: how to sub-select?.. Hi! On Oct 22, Moshe Gurvich wrote: > thank you very much; > > i'm us

RE: load data infile problems

i had similar problem until used line delimiter different than default "\n" try this: load data local infile 'file.txt' into table mytable fields optionally enclosed by '"' escaped by '"' terminated by ',' LINES TERMINATED BY '-= aNy we1Rd cHar 0r Str1Ng =-' :) -Original Message--

RE: Oracle conversion...

select max(length(column)) from table -Original Message- From: Tony [mailto:[EMAIL PROTECTED]] Sent: Monday, October 22, 2001 2:36 PM To: [EMAIL PROTECTED] Subject: Oracle conversion... Is there a quick and easy way to determine the maximum used length of a varchar column? I've built a

RE: MS Access to MySQL conversion? How?

try this: http://www.mysql.com/downloads/contrib.html#SEC653 -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Monday, October 22, 2001 2:12 PM To: [EMAIL PROTECTED] Subject: MS Access to MySQL conversion? How? I am new to this fast database and love MySQL, but I

RE: how to sub-select?..

thanx :) -Original Message- From: Sergei Golubchik [mailto:[EMAIL PROTECTED]] Sent: Monday, October 22, 2001 1:57 PM To: Moshe Gurvich Cc: [EMAIL PROTECTED] Subject: Re: how to sub-select?.. Hi! On Oct 22, Moshe Gurvich wrote: > so what's the remedy? > how to do this task in MyS

RE: how to sub-select?..

so what's the remedy? how to do this task in MySQL without using subselects? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Trond Eivind Glomsrød Sent: Monday, October 22, 2001 1:13 PM To: Moshe Gurvich Cc: [EMAIL PROTECTED] Subject: Re: how t

how to sub-select?..

I'm trying to run: delete from followups where task_id not in (select task_id from tasks) but it gives me an error: Error: 1064 - You have an error in your SQL syntax near 'select task_id from tasks)' at line 1 where's the problem and how to work around? thank you --- Outgoing mail is certifie