Questions tagged as 'mysql'

Tagged questions
1
answer

Problem with procedure and workbench

I have a procedure that fills a table with data for later reference, for it uses two views, if I run from a database manager like HeidySql the procedure works correctly, but I do charge the procedure in the workbench and impact the database from...
asked by 24.06.2017 / 12:57
3
answers

Access Denied mysql

This error appears: Warning: mysqli_connect () [function.mysqli-connect]: (28000/1045): Access denied for user 'root' @ 'localhost' (using password: YES) This is the code: ?php $server = "localhost"; $user = "root"; $pass = ""; $db =...
asked by 24.06.2017 / 22:09
1
answer

Connect MySQL Workbench with an instance of mysql in Google Compute Engine

I have a Google Compute Engine instance in which I create an instance of mysql. I would like to know how I can connect to this instance from MySQL Workbench?     
asked by 27.06.2017 / 01:10
1
answer

Insert current date and time in table

The following table was created, I request to be able to insert the current date and time in which the process is carried out create table "informix".ventas_saldos ( f_inicial date not null , f_final date not null , c_almacen v...
asked by 15.06.2017 / 17:09
2
answers

Get data from MySql to a drop-down list (select option)

I have this code for a select option and it consults the database and brings me the logged in user, but I need to list all the users that I have in the database. I'm not even storing it in the database when choosing the only user that brings...
asked by 15.06.2017 / 18:09
1
answer

How do I get a specific data from the BD and not the first one I find?

I am currently doing a query with php to bring me a specific data of the user that is being used, I have the following, but it brings me the first data that it finds from that column (company), and not the user-related one logged in at the momen...
asked by 20.06.2017 / 13:51
2
answers

Codeigniter transactions with multiple functions

I need to add a product in the "products" table, once the product has been added, return the product ID, then I need to add the details of that product in the "details_product" table In the official page of Codeigniter they show how to do it...
asked by 21.06.2017 / 13:05
1
answer

Do not believe me Symfony database Many to many

I have two classes, the User class and the Functionality class, that relate to manytomany in symfony but when I run doctrine: schema: update --force does not generate the data base of the relationship here my code User Entity: namespace S...
asked by 21.06.2017 / 18:07
2
answers

Get results of two fields in mysql subquery

I'm trying to recover two fields from a subquery but I do not give with the key to show them to me. this is the code I have: SELECT *, art.id AS IdArt, art.nombre AS NombrArt, conf.Conf1 AS Sexo FROM 'Articulos' art INNER JOIN 'Configuraci...
asked by 22.06.2017 / 10:03
1
answer

Error uploading csv file to mysql

I have the Index and the php in a single script. I have a button that gives me the option to search the directory for the csv file to upload to the database. Before selecting the file I get the following error:    Notice: Undefined index:...
asked by 09.08.2017 / 15:13