Thema: Mysql Abfrage
Einzelnen Beitrag anzeigen
  #3  
Alt 04.03.2018, 13:25:08
GIS GIS ist offline
Anfänger
 
Registriert seit: Mar 2018
Alter: 53
Beiträge: 6
AW: Mysql Abfrage

Hallo,

Hier mal ein Auszug:

Code:
-- phpMyAdmin SQL Dump
-- version 4.0.10
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 04. Mrz 2018 um 12:22
-- Server Version: 5.5.59-0+deb8u1
-- PHP-Version: 5.6.33-0+deb8u1

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 */;

--
-- Datenbank: `test`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `wp_2_rg_lead_detail`
--

CREATE TABLE IF NOT EXISTS `wp_2_rg_lead_detail` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `lead_id` int(10) unsigned NOT NULL,
  `form_id` mediumint(8) unsigned NOT NULL,
  `field_number` float NOT NULL,
  `value` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `form_id` (`form_id`),
  KEY `lead_id` (`lead_id`),
  KEY `lead_field_number` (`lead_id`,`field_number`),
  KEY `lead_field_value` (`value`(191))
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=111477 ;

--
-- Daten für Tabelle `wp_2_rg_lead_detail`
--

INSERT INTO `wp_2_rg_lead_detail` (`id`, `lead_id`, `form_id`, `field_number`, `value`) VALUES
(110903, 4072, 2, 2, 'Testname'),
(110904, 4072, 2, 1, 'Testname'),
(110905, 4072, 2, 67.1, 'Professor'),
(110906, 4072, 2, 67.3, 'São Paulo'),
(110907, 4072, 2, 67.4, 'São Paulo'),
(110908, 4072, 2, 67.5, '2961170'),
(110909, 4072, 2, 67.6, 'Brasil'),
(110910, 4072, 2, 17, '11-2084-8433'),
(110911, 4072, 2, 16, '11-9-9703-2690'),
(110912, 4072, 2, 24, '#NV'),
(110913, 4072, 2, 18, 'dss'),
(110914, 4072, 2, 15, 'testname@testname.com'),
(110915, 4072, 2, 25, '11/12/1988'),
(110916, 4072, 2, 62, 'Sagitário'),
(110917, 4072, 2, 32, 'Esportivo fit'),
(110918, 4072, 2, 27, '154'),
(110919, 4072, 2, 28, '50'),
(110920, 4072, 2, 29, 'Bitte auswählen'),
(110921, 4072, 2, 30, 'Bitte auswählen'),
(110922, 4072, 2, 31, 'Bitte auswählen'),
(110923, 4072, 2, 33, 'Bitte auswählen'),
(110924, 4072, 2, 36, 'Bitte auswählen'),
(110925, 4072, 2, 37, 'solteira'),
(110926, 4072, 2, 39, '0'),
(110927, 4072, 2, 38, 'Eu quero filhos'),
(110928, 4072, 2, 40, 'Bitte auswählen'),
(110929, 4072, 2, 43, 'Bitte auswählen'),
(110930, 4072, 2, 42, 'Outro'),
(110931, 4072, 2, 41, 'de modo nenhum'),
(110932, 4072, 2, 45, 'Diploma universitário');

/*!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 */;
Mit Zitat antworten