Questions tagged as 'mysql'

Tagged questions
1
answer

Fail to add ADO.NET element

I just downloaded the Visual Studio 2017 , I have XAMPP also in the latest version, and so does the Workbench 6.3 . Also lower the Connector/Net 8.0.11 to make the connection. But at the time I try to add an ADO.NET entity data mo...
asked by 04.05.2018 / 19:36
1
answer

How to export a database from mysql to acces?

I would like to know how I can import a MySQL database from Access. It's for a job and I've looked at it but I have not found how to do it.     
asked by 04.05.2018 / 16:28
0
answers

Validate when executing a PHP query

I have a problem trying to validate 2 quantities before doing an update. In a table I have 2 columns, I send data of a product through a POST with which it makes update to the table, but I have to validate that quantity 1 is equal to quantity...
asked by 26.04.2018 / 07:33
0
answers

google maps api MARKETS php

I want to place the markers on the map with the information stored in my MYSQL db. In the file "index.php" I have the following piece of code that works well with an XML file: // Change this depending on the name of your PHP or XML file...
asked by 26.04.2018 / 03:08
0
answers

VB.NET-MYSQL - how to call a report with a parameter (Crystal Report)

I have a query that when executing it loads the data perfectly according to a id , now, I need to generate a report that brings me that query (filtered with id ). After a lot of struggle with the odbc , I can a...
asked by 04.05.2018 / 18:53
1
answer

Because I do not take the values in method $ _POST | print_r () expects at most 2 parameters ... on line 5

$habitacion=$_POST['habitacion']; $estado=$_POST['estado']; $personas=$_POST['personas']; print_r($habitacion,$estado,$personas); $query="SELECT * FROM habitacion WHERE hab_id='$habitacion'"; $result=mysq...
asked by 26.04.2018 / 06:40
1
answer

Select distinct () with Join in Laravel 5.5

I've been working on an sql query that I want to replicate in Laravel 5.5 with eloquent, but I can not get it to work. I explain, this is my query in SQL: SELECT empresas.companyname_cny, empresas.ruc_cny, municipios.municipality_mty, ciudads...
asked by 28.04.2018 / 02:38
2
answers

Error inserting: duplicate entry '0' for primary key

I have a person table in my database, which I define as follows: CREATE TABLE 'persona' ( 'documento' bigint(20) NOT NULL, 'nombres' varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, 'apellidos' varchar(255) COLLATE utf8_unicode_ci DEFAULT...
asked by 28.04.2018 / 02:06
0
answers

Show record of two tables

In that table they ask me to add the Course field, I could already add the column, I try to bring the result, but it does not show it to me, the course field is in the table records, I would also like to condition that if it has no course, show...
asked by 23.04.2018 / 18:09
0
answers

Insert in a table from python

I have two scripts which I connect to the database and the second extracts information from the database called Timetable. The first function is called persistence which makes the connection and executes a query in the database and the second...
asked by 23.04.2018 / 19:18