Tiny File Manager

Back Back Up Advanced Editor

CREATE TABLE clone_chessmaster_new LIKE chessmaster_new ;
INSERT INTO clone_chessmaster_new SELECT * FROM chessmaster_new ;

CREATE TABLE clone_classement_new LIKE classement_new ;
INSERT INTO clone_classement_new SELECT * FROM classement_new ;

CREATE TABLE clone_parties_new LIKE parties_new ;
INSERT INTO clone_parties_new SELECT * FROM parties_new ;

CREATE TABLE clone_evolution_new LIKE evolution_new ;
INSERT INTO clone_evolution_new SELECT * FROM evolution_new ;

CREATE TABLE clone_elo_affectation LIKE elo_affectation ;
INSERT INTO clone_elo_affectation SELECT * FROM elo_affectation ;

pour la suppressin

TRUNCATE clone_chessmaster_new;

TRUNCATE clone_classement_new;

TRUNCATE clone_evolution_new;

TRUNCATE clone_parties_new;

////TRUNCATE clone_elo_affectation;

/**********************************************************************/

INSERT INTO `clone_elo_affectation` (`joueur`, `elo`) VALUES
('AlvaroM', 1400),
('DamienB', 1400),
('EmileM', 1400),
('FranckV', 1400),
('HenriqueF', 1400),
('PatrickA', 1400),
('PhilippeA', 1400),
('RemyS', 1400),
('StephaneR', 1400);

/**********************************************************************/

INSERT INTO `clone_classement_new` (`id`, `joueur`, `elo`, `initial`, `parties`, `prior`, `bonus`, `oldrating`, `gcount`, `wins`, `losses`, `draws`, `active`) VALUES
(1, 'AlvaroM', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),
(2, 'DamienB', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),
(3, 'EmileM', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),
(4, 'FranckV', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),
(5, 'HenriqueF', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),
(6, 'PatrickA', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),
(7, 'PhilippeA', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),
(8, 'RemyS', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),
(9, 'StephaneR', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1);

ALTER TABLE clone_chessmaster_new AUTO_INCREMENT = 1