This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- MySQL dump 10.17 Distrib 10.3.16-MariaDB, for debian-linux-gnu (x86_64) | |
-- | |
-- Host: localhost Database: stats | |
-- ------------------------------------------------------ | |
-- Server version 10.3.16-MariaDB-1:10.3.16+maria~bionic-log | |
/*!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 utf8mb4 */; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- MySQL dump 10.17 Distrib 10.3.16-MariaDB, for debian-linux-gnu (x86_64) | |
-- | |
-- Host: localhost Database: stats | |
-- ------------------------------------------------------ | |
-- Server version 10.3.16-MariaDB-1:10.3.16+maria~bionic-log | |
/*!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 utf8mb4 */; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- MySQL dump 10.17 Distrib 10.3.16-MariaDB, for debian-linux-gnu (x86_64) | |
-- | |
-- Host: localhost Database: stats | |
-- ------------------------------------------------------ | |
-- Server version 10.3.16-MariaDB-1:10.3.16+maria~bionic-log | |
/*!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 utf8mb4 */; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE DATABASE IF NOT EXISTS balancetests; | |
USE balancetests; | |
DROP PROCEDURE IF EXISTS insertTransactions; | |
DELIMITER $$ | |
CREATE PROCEDURE insertTransactions(nrows INT) | |
BEGIN | |
DROP TABLE IF EXISTS t; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE DATABASE IF NOT EXISTS balancetests; | |
USE balancetests; | |
DROP TABLE IF EXISTS t; | |
CREATE TABLE t (id INT, client_id INT, transaction INT, amount DECIMAL); | |
SET @nrows = 10; | |
INSERT INTO t WITH RECURSIVE transactions AS | |
( | |
SELECT 1 AS id, 1 AS client_id, 1 AS transaction, 10 AS amount |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* Script dst.sql: calcula la duración entre dos fechas que se ven afectadas */ | |
/* por un cambio de horario de verano a invierno en España */ | |
/* Guarda el valor de la zona horaria */ | |
SET @current_tz = @@SESSION.time_zone; | |
/* Crea la tabla t3 que contiene un campo para las fechas del tipo TIMESTAMP */ | |
USE datetests; | |
DROP TABLE IF EXISTS t3; | |
CREATE TABLE t3(id INT, ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP()); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- phpMyAdmin SQL Dump | |
-- version 4.5.2 | |
-- http://www.phpmyadmin.net | |
-- | |
-- Host: localhost | |
-- Generation Time: May 05, 2016 at 11:24 pm | |
-- Server version: 10.1.10-MariaDB | |
-- PHP Version: 7.0.4 | |
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- phpMyAdmin SQL Dump | |
-- version 4.5.2 | |
-- http://www.phpmyadmin.net | |
-- | |
-- Host: localhost | |
-- Generation Time: Apr 11, 2016 at 05:36 am | |
-- Server version: 10.1.10-MariaDB | |
-- PHP Version: 7.0.4 | |
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; |