busboy — 2011-02-28T00:22:59-05:00 — #1
What is the best way to copy firstname, lastname from the users table in a database called oils over to the contacts table in the edownline database?
guelphdad — 2011-02-28T00:48:37-05:00 — #2
If you have a user that can connect to both databases then
insert into edownline (firstname, lastname)
r937 — 2011-02-28T04:42:33-05:00 — #3
what he said, except with proper database qualification on the table names
INTO <font color='"Blue"'>edownline.contacts</font>
, lastname )
FROM <font color='"blue"'>oils.users</font>
busboy — 2011-03-01T18:56:34-05:00 — #4
r937, how come this query didn't work?
WHERE wantSilver = 'Yes';
I didn't get an error message or anything.
samanime — 2011-03-01T19:04:30-05:00 — #5
Most likely cause would be that there are no entries where "wantSilver" is "Yes".
Are you running this in something like MySQL Workbench? If so, does it tell you have many rows are affected? Also, try just the select portion by itself and see what results you get.
busboy — 2011-03-02T10:52:27-05:00 — #6
Yes, I am using mySQL Workbench. I don't understand why I'm getting the following error. I checked that all permissions are granted to this user. Any ideas?
Error Code: 1142
INSERT command denied to user 'recordAdmin'@'18.104.22.168' for table 'people'