- 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
@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", wh
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 cou
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
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 alread
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 and
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
Hi all,
I feed data into a db and a jscript draws that data from the db and dumps it
in a Marquee on the pg but what happens is everytime i feed in data, there
is an sql update query which updates my db overwriting earlier data... but i
need to archive the data which i wrote earlier so am trying
re 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]&g
lt;[EMAIL PROTECTED]>
Sent: 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 tabl
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 where
24 matches
Mail list logo
