Home forums Using CanvasJS Issues retrievng data from MySql Reply To: Issues retrievng data from MySql

#7458

andres.chandia
Participant

Just in case, i’m adding the table structure

— phpMyAdmin SQL Dump
— version 4.2.6deb1
http://www.phpmyadmin.net

— Servidor: localhost
— Tiempo de generación: 03-11-2014 a las 12:23:46
— Versión del servidor: 5.5.40-0ubuntu1
— Versión de PHP: 5.5.12-2ubuntu4.1

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 datos: database

— ——————————————————–


— Estructura de tabla para la tabla values

CREATE TABLE IF NOT EXISTS values (
Id int(6) NOT NULL,
Titol varchar(500) DEFAULT NULL,
Autor varchar(200) DEFAULT NULL,
Any_publicacio int(4) NOT NULL,
Pub_prod varchar(200) DEFAULT NULL,
Lloc_publicacio varchar(200) DEFAULT NULL,
Suport varchar(200) DEFAULT NULL,
Consulta_linia varchar(10) NOT NULL,
D_actualitzacio varchar(10) NOT NULL,
Url varchar(500) NOT NULL,
Tipus_1 set(‘lingüístic’,’jurídic’) NOT NULL,
Tipus_2 varchar(1000) NOT NULL,
Tipus_3 varchar(1000) NOT NULL,
P_clau varchar(1000) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=132 ;


— Índices para tablas volcadas


— Indices de la tabla values

ALTER TABLE values
ADD PRIMARY KEY (Id), ADD UNIQUE KEY id (Id);


— AUTO_INCREMENT de las tablas volcadas


— AUTO_INCREMENT de la tabla values

ALTER TABLE values
MODIFY Id int(6) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=132;
/*!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 */;