- Original Message -
> From: "bars0.bars0.bars0"
>
> Hi all!
>
> I need to copy data (result set from query) from one server to
> another.
> This will be done once a month (so cron will be involved:), for data
> from previous month.
> Any ideas how can I achieve this?
>
> Should I expor
Sorry the DROP TABLE Should be TEMP not table1
-Original Message-
From: Gordon Bruce [mailto:[EMAIL PROTECTED]
Sent: Friday, December 09, 2005 3:51 PM
To: Sachin Bhugra; mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Subject: RE: copying data!!!
This is kind of ugly, but with the
;
-Original Message-
From: Sachin Bhugra [mailto:[EMAIL PROTECTED]
Sent: Friday, December 09, 2005 3:00 PM
To: mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Subject: Re: copying data!!!
Tnx for the reply Jimmy. I also sent another question( i know its a
very silly question for you all..but
Check this out.
http://dev.mysql.com/doc/refman/5.0/en/insert-select.html
On 12/9/05, Sachin Bhugra <[EMAIL PROTECTED]> wrote:
> Hello Friend,
>
> Can you please let me know how to copy data from a column in table A
> to a column in table B. e.g. I want to copy value of column "age" from
> table
Tnx for the reply Jimmy. I also sent another question( i know its a
very silly question for you all..but believe me i am tryin this for
past three days and not able to get it)
Pls hlp..(just give me hint in right direction, and i will try to do
the rest)
Tnx
Sachin
--
MySQL General Mailing L
Hello,
We expect to offer native support for LDAP and PAM authentication, late next
year.
Thanks,
Jimmy Guerrero, Senior Product Manager
MySQL Inc, www.mysql.com
-Original Message-
From: Sachin Bhugra [mailto:[EMAIL PROTECTED]
Sent: Friday, December 09, 2005 1:38 PM
To: mysql@lists.my
While the basic issue of correct syntax is still open, this issue has
boiled down to a specific error message, so I've moved to a new thread
called:
""Operand should contain 1 column" error"
However, for future reference, the issue of variables has been solved. I
discovered that to make the
SET collation_connection = utf8_general_ci;
on my server (4.1.14) and it seems to work
I made a new Query, copying the text as you wrote it, and it still
didn't work, but in a different way.
I type:
SET collation_connection = utf8_general_ci;
... and I get the following returned to me:
Your
Dave,
I've tried
SET collation_connection = utf8_general_ci;
on my server (4.1.14) and it seems to work so
I'm afraid I can't help you anymore there.
/Johan
Dave wrote:
My hunch here is that your ' ' in the CONCAT_WS defaults to
latin1_swedish_ci.
It seems you're right. There are a few var
My hunch here is that your ' ' in the CONCAT_WS defaults to
latin1_swedish_ci.
It seems you're right. There are a few variables that are still in
default mode which I discovered through the SHOW VARIABLES command. I've
tried to switch them, but I'm obviously using the syntax incorrectly. I
Dave,
I'm not that good when it comes to collations but latin1_swedish_ci is
normally the default collation for a MySQL installation. Have you
checked via "SHOW VARIABLES" that you don't have latin1_swedish_ci
lurking somewhere. My hunch here is that your ' ' in the CONCAT_WS
defaults to latin1_sw
Hello.
>After reading through the MySQL manuals, as suggested here, I attempted
>to construct the following statement to copy data from the table "members"
>to the table "forum_members":
Please, keep your answers on the list. Use INSERT ... SELECT. Don't put
the functions in the column lis
I think your problem is that you're trying to call one of your columns
MD5(passwd)
Thank you for pointing that out. I had the function in the wrong part of
the statement. Actually, I've realized I'm probably best off to leave
the passwords alone for now, and go ahead and copy the rest of th
Hi Dave,
I think your problem is that you're trying to call one of
your columns MD5(passwd) and my guess would be that you should do:
INSERT INTO forum_members( passwd, dateRegistered, realName,
ID_MEMBER, memberName, emailAddress, active, keitai, number, admin,
cardpic, cardbio, hofpic, hofbio
After reading through the MySQL manuals, as suggested here, I attempted
to construct the following statement to copy data from the table
"members" to the table "forum_members":
INSERT INTO forum_members( MD5(passwd) , dateRegistered, realName,
ID_MEMBER, memberName, emailAddress, active, kei
Hello.
This is not a step by step instructions. But taking into an account
that you're a MySQL beginner, in my opinion, you should read some
parts of the manual:
http://dev.mysql.com/doc/mysql/en/string-functions.html
http://dev.mysql.com/doc/mysql/en/insert-select.html
ht
sql,query
I have two tables which are exactly alike. What I want to do is copy an
entire column(DESCRIPTION)from one table(ebooks2) and put that information
into the other table's(ebooks) description column where the ID(BOOK) matches
up. Is there a way to go about doing this?
Thanks,
A.J. Per
Will this actually work? Because I can't select from the table into which
I'm inserting.
Also I don't want to insert. I want to update a bunch of records that
already exist.
Here is exactly what I want to do.
I have two tables set up that I'm dealing with right now. One is the main
informati
I think what you are looking for is the Insert...Select statement
http://www.mysql.com/doc/I/N/INSERT_SELECT.html
Sheridan Saint-Michel
Website Administrator
FoxJet, an ITW Company
www.foxjet.com
- Original Message -
From: "Eric Spletzer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent
19 matches
Mail list logo