File "documentation.txt"

Full Path: /home/analogde/www/Massage_debug_15_11_2017/MassageV3_online/documentation.txt
File size: 694 bytes
MIME-type: text/plain
Charset: utf-8

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";