Questions tagged as 'mysql'

Tagged questions
0
answers

Indexes in Views

I have a database in MySQL with more than 50 tables and each one has its index, views, views of the views, stored procedures. My question is regarding the views, when creating a view with columns of a certain table and one of those columns th...
asked by 22.06.2017 / 19:30
1
answer

amChart Simple graph of lines! Please help

I have a MySql database with a table which has several columns, including the date and time. The rest are columns of values such as temperature. I just need to make a line graph with the date / time combined on the horizontal axis and the val...
asked by 22.06.2017 / 23:45
0
answers

Is it possible to have a query profiler in mysql similar to SQL PROFILER?

I have an application in php, and when I perform actions or reports I would like to track which queries are running, I have tried with JET PROFILER and other applications that mention tracking but when I run the PHP application it does not show...
asked by 21.06.2017 / 17:03
1
answer

Error synchronizing model in mysql workbench

I want to synchronize my model in mysql workbench and I get this error:    Fetching table list.       0 items from dbEnter OK Fetching view list.       0 items from dbEnter OK Fetching routine list. Operation failed: Table 'proc' is ma...
asked by 20.06.2017 / 04:01
1
answer

Call to a member function getClientOriginalName () on null

I get the following error when registering the name of the path in bd, in this case if you save the image in the server folder but not in bd, this is in Laravel Driver code public function store(Request $request) { $file = $reques...
asked by 20.06.2017 / 15:39
3
answers

Create tables from mysql queries

How could a table be created from several queries in mysql . I have the following questions: --selecciona tipo gasto sin repetir un registro --- SELECT DISTINCT tipo_gasto FROM factura' number of records of that variable SELECT...
asked by 14.06.2017 / 23:54
1
answer

Error creating a trigger with MySql

Good, I am trying to make a trigger with MySql, the problem is that I have always worked with Sql-Server and now I am having some complications. From the following code what is wrong with me? : USE 'test_db'; DELIMITER $$ CREATE TRIGGER 'tr_i...
asked by 15.06.2017 / 13:28
1
answer

Help with cron to backup a MySQL bdd

I want to create a backup of my database (MySql with phpMyAdmin) and I found the following script to be able to automate it: echo off mysqldump -hlocalhost -udb_admin -pContrasenaDb bdd_n1 > copia_seguridad_%Date:~6,4%%Date:~3,2%%Date:~0,2...
asked by 16.07.2017 / 11:47
2
answers

Insert array in MySQL table with Laravel 5.4

I have a form like this: What I want is that when selecting two or more sports, add a row for each sport with the id of the selected name, until now in my database is stored as follows: And here is my Controller code: $data =...
asked by 30.06.2017 / 14:53
0
answers

Count inserted csv records with PHP

Before explaining my problem I want to emphasize that I already look at the possible answers to my question, and they all deal with something different. What I want to do is that when I import a CSV file into a table, it shows me the number of r...
asked by 30.06.2017 / 15:30