Menu
Community /Pin to ProfileBookmark
@NogDogJan 30.2020 — #Well, first thing I would suggest is that this is not necessary, and could end up being an annoyance later if you ever want to pull historical data for a user across multiple years. If the table has some date or timestamp field for each transaction, all you need to do is add
If you decide you still want to do it, the basic way to move data would be:
Then you could use
Mysql Data move
How to move data one table to another table. and old table data delete.
I makes account management software and this software i want end of the year the user move his transaction full data move other table and he start new blank table and start transaction. and old table using other work.
i want php code i could not make this.
Sign in
to post a comment2 Comments(s) ↴
0
@NogDogJan 30.2020 — #Well, first thing I would suggest is that this is not necessary, and could end up being an annoyance later if you ever want to pull historical data for a user across multiple years. If the table has some date or timestamp field for each transaction, all you need to do is add where date_column between '2020-01-01' and '2020-12-31'If you decide you still want to do it, the basic way to move data would be:
<i>
</i>insert into new_table (col1, col2, ... colN)
select col1, col2, ... colN from old_table;
Then you could use
truncate