- Original Message -
From: bars0.bars0.bars0 bars0.bars0.ba...@gmail.com
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?
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 2 to column age in table 1, provided the entries in column
name, which is there in both the table, should match. In MySQL v 4
it could be
@lists.mysql.com
Subject: copying data!!!
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 2 to
column age in table 1, provided the entries in column name, which is
there in both the 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
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 2 to
;
-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
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
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,
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,
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
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 list. See
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
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'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
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:
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
MySQL General List,
Server specifications:
MySQL 4.1.3-beta, phpMyAdmin 2.5.7-pl1, PHP 4.3.8
My specifications:
MySQL beginner, PHP intermediate, HTML and CSS advanced.
The situation:
I have recently installed a forum ( http://www.simplemachines.org/ )
on my web site. I
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
Hi all,
I need to move a database from a 4.0.20 MySQL server to a 4.0.17
server. I expect it will work fine when simply scp-ing the whole
/var/lib/mysql/MY-DATABASE to the other server's /var/lib/mysql
directory, with only a minor version difference.
Can anyone confirm this is going to work
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.
Hello, I'm a newbie, so pardon my lack of wherewithal with MySQL, and thanks
for the help in advance.
I have two table and I want to copy info from one table to another. I can
pull the correct information out with a select statement that looks
something like this
Select x1 from tbl1, tbl2
: Monday, September 10, 2001 4:38 PM
Subject: Copying data from one table to another.
Hello, I'm a newbie, so pardon my lack of wherewithal with MySQL, and
thanks
for the help in advance.
I have two table and I want to copy info from one table to another. I can
pull the correct information out
/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: Monday, September 10, 2001 4:38 PM
Subject: Copying data from one table to another
23 matches
Mail list logo