@echo off set PATH=F:\Wamp\bin\mysql\mysql5.6.12\bin\;%PATH% REM *************************************** REM * * REM * Chargement des tables MySql * REM * * REM *************************************** echo "+--------------------+" echo "| DataBase 'ma_base' |" echo "+--------------------+" mysql --user=root --password=root mysql < Ma_Base\Bas_ma_base.sql echo "+--------------------+" echo "| Table 'Tab_access' |" echo "+--------------------+" mysql --user=root --password=root --database=ma_base < Ma_Base\Tab_access.sql
-- -- Database : `ma_base` -- CREATE DATABASE IF NOT EXISTS `ma_base` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; USE ma_base;
-- phpMyAdmin SQL Dump -- version 3.5.1 -- [www.phpmyadmin.net] -- -- Client: localhost -- Généré le: Lun 09 Juillet 2012 à 00:28 -- Version du serveur: 5.5.24-log -- Version de PHP: 5.4.3 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Base de données: `ma_base` -- -- -------------------------------------------------------- -- -- Structure de la table `tab_access` -- DROP TABLE IF EXISTS `tab_access`; CREATE TABLE IF NOT EXISTS `tab_access` ( `ID_REPERTOIRE` char(50) NOT NULL, `ID_LIEN` char(50) NOT NULL, `CODE_PERIODE` char(1) NOT NULL, `NBRE_ACCESS` bigint(20) unsigned NOT NULL, `DATE_PERIODE` date NOT NULL, PRIMARY KEY (`ID_REPERTOIRE`,`ID_LIEN`,`CODE_PERIODE`,`DATE_PERIODE`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Contenu de la table `tab_access` -- INSERT INTO `tab_access` (`ID_REPERTOIRE`, `ID_LIEN`, `CODE_PERIODE`, `NBRE_ACCESS`, `DATE_PERIODE`) VALUES ('toto', 'index.php', 'A', 1, '2011-00-00'), ('toto', 'index.php', 'J', 1, '2011-07-25'), ('toto', 'index.php', 'M', 1, '2011-07-00'); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;