Hi every body
I want to know if there is some easy way to duplicate an entire row, in one
table, only
changing one field?
Somethig like this,
this is the original table:
+---+-++-+
| ReleaseNumber | ReleaseDate | PrositeVersion
Hello list,
After searching the documentation on the site, as well as the archives, I
have yet to find the answer to this question. If I have overlooked it
somewhere, just point me in the right direction.
The question:
I have two tables, set up exactly the same, except the names of the
Can be done in two steps, but not in one:
insert into deleted_users select * from active_where where username='joe';
delete form active_users where username='joe';
what you mention about usernames not being unique in the deleted_users
table is
not a problem as long as you don't have a primary
It is in the manual.
Approximately ( Don;t have manual in front of me ):
insert into deleted_users select from active_users where user_name =
"joe_smith";
delete from active_users where user_name = "joe_smith";
Aaron Williams wrote:
Hello list,
After searching the documentation on the
Aaron Williams wrote:
Hello list,
After searching the documentation on the site, as well as the archives, I
have yet to find the answer to this question. If I have overlooked it
somewhere, just point me in the right direction.
The question:
I have two tables, set up exactly the
Hi,
Table 1 is called: active_users
Table 2 is called: deleted_users
When "joe_smith" wishes to be deleted, I want to remove his entry
from the active_users table, and place it into the delete_users
table, with exactly the same information.
INSERT INTO deleted_users SELECT * FROM
