2024-07-12
한어Русский языкEnglishFrançaisIndonesianSanskrit日本語DeutschPortuguêsΕλληνικάespañolItalianoSuomalainenLatina
Hoc saepe accidit in operatione et sustentatione: MySQL nomen mensae mutat, eandem mensam sine notitia creat, et pauca exemplaria ex veteri tabula in eam data sunt.
RENAME TABLE old_table_name TO new_table_name;
Hoc reponere in mensa originaliold_table_name
Rename tonew_table_name
。
CREATE TABLE new_table LIKE old_table_name;
Hoc file creare vocavitnew_table
novam mensam cuius structuram fundaturold_table_name
compages, sed nulla notitia exscribenda erit.
INSERT INTO new_table SELECT * FROM old_table_name LIMIT number_of_rows;
Hoc incipiet aold_table_name
Ante eligensnumber_of_rows
spoliareData insertiovenirenew_table
medium.Necesse est tibinumber_of_rows
Repone quod viseffingoOrdines.
Quaeso fac ut notitias tuas remittas antequam has operationes perficias ne quid improvisum ferat.Si certus non es, incipere atest ametHaec mandata proba in .
- -- 假设原来的表名为 orders
- -- 第一步:重命名原来的表
- RENAME TABLE orders TO orders_backup;
- -- 第二步:创建一个新的空表,结构和原来的表一样
- CREATE TABLE orders LIKE orders_backup;
- -- 第三步:复制原表的前10条数据到新表中
- INSERT INTO orders SELECT * FROM orders_backup LIMIT 10;
Hae operationes in MySQL linea instrumenti mandati peragendae vel instrumentum aliquod administrandi database quod SQL interface praebet. Fac tibi satis facultates ad haec mandata exequenda.