Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
File Manager
/
Massage_2000
:
documentation.txt
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
CREATE TABLE newtable LIKE oldtable copy data from one table to another in MySQL mysql> CREATE TABLE reservation_dev2017 LIKE copy_reserve2017; mysql> INSERT INTO reservation2_dev017 SELECT * FROM copy_reserve2017; ////////////// OK ///////////// CREATE TABLE copy_reserve2017 LIKE reservation_dev2017 INSERT INTO copy_reserve2017 SELECT * FROM reservation_dev2017 ALTER TABLE copy_reserve2017 ADD formule VARCHAR(30) AFTER etendu; CREATE TABLE copy_gestion LIKE gestion INSERT INTO copy_gestion SELECT * FROM gestion ALTER TABLE copy_reserve2017 ADD formule VARCHAR(30) AFTER mode; $_SESSION['table_reservation'] = "copy_reservation2017"; $_SESSION['table_gestion'] = "copy_gestion";