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
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
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
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 th
>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 p
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 tables
